issue with pyArgs of pxExtractDataWithArgs in BIX file generation
Running BIX extract on cloud using pxExtractDataWithArgs; what are the options/parameters Do I have to pass to pyArgs property; to generate the BIX file for one case ID or pzinskey?
what options do I have to set; if I have to generate file for list of case ID ?
I saw option in BIX guide to generate a file for single case ID from command line using -z -Z option. I tried that option by passing -z ABC-FW-PRJ-WORK C-100 -Z ABC-FW-PRJ-WORK C-100; the step3 of the pxExtractDataWithArgs failed with "** Invalid pyArgs specified."
***Updated by Moderator: Marissa to add SR Details***
Accepted Solution
Pegasystems Inc.
US
It wasn't clear originally that Ramesh was calling pxExtractDataWithArgs from an activity. In order to pass -z and -Z to pxExtractDataWithArgs from an activity, they should be specified like this:
"-z \"LOVI-LOVINAPP-WORK C-1\" -Z \"LOVI-LOVINAPP-WORK C-1\""
Backslashes need to be added to escape the quotes used for the pzInsKeys, and in addition, the entire string needs to be placed in quotes.
If you have an agent that calls pxExtractDataWithArgs, you would specify the values as I originally mentioned:
-z "ABC-FW-PRJ-WORK C-100" -Z "ABC-FW-PRJ-WORK C-100"
Pegasystems Inc.
US
Hi Ramesh,
Check out the BIX user guide, specifically the section "Running an Extract rule using a Pega 7 Platform agent", this should explain what arguments will not work: https://docs-previous.pega.com/bix-722-user-guide
That being said, I think -z / -Z should work. Perhaps it had to do with how you tried to pass the arguments. Try passing the pzInsKey in quotes: -z "ABC-FW-PRJ-WORK C-100" -Z "ABC-FW-PRJ-WORK C-100"
US
1. An error message is displayed, If pzInsKey is passed in quotes (-z "ABC-FW-PRJ-WORK C-100" -Z "ABC-FW-PRJ-WORK C-100").
2. If I pass -z C-100; no error message displayed and also no data is displayed because query did not fetch any details.
SELECT pzPVStream FROM PEGADATA.CPMHC_ABC_FW_PRJ_WORK WHERE
pzInsKey like 'ABC-FW-PRJ-WORK%' AND
pzInsKey >= 'C-100' ORDER BY pzInsKey
3. How to pass pzInskey like this with classname and case ID( -z ABC-FW-PRJ-WORK C-100 -Z ABC-FW-PRJ-WORK C-100)
US
I have below error
List of params for Method or activity that this step is calling:
Invalid expression or reference: line 1:23 no viable alternative at input '-FW-PRJ-WORK OCL'
-z=ABC-FW-PRJ-WORK OCL-10559 -Z=ABC-FW-PRJ-WORK OCL-10559
^^^
line 1:23 extraneous input 'OCL' expecting {<EOF>, '-=', '*', '-', '<', '!=', '<=', '?', '~=', '+=', '^=', '%', '*=', '+', '<>', '=', '&&', '||', '>', '%=', '/=', '==', '/', '>='}
-z=ABC-FW-PRJ-WORK OCL-10559 -Z=ABC-FW-PRJ-WORK OCL-10559
^^^
Pegasystems Inc.
US
Hello Ramesh,
The usage of the -z and -Z parameters filtering based on the pzInsKey is explained clearly over here.
Kindly look into this documentation for the better understanding of filtering based on the range of pzInsKey values.
If using the BIX command line, specify the following parameters:
Hello Ramesh,
The usage of the -z and -Z parameters filtering based on the pzInsKey is explained clearly over here.
Kindly look into this documentation for the better understanding of filtering based on the range of pzInsKey values.
If using the BIX command line, specify the following parameters:
-z <PEGASAMPLE C-1>-Z <PEGASAMPLE C-10>
Note: The pzInsKey is a text property of type VARCHAR. Therefore, it does not sort like a NUMERIC data type. Understanding this principle is important to successfully filtering the pzInskey property on a range of values.
Hope this might be helpful in achieving your requirement.
Regards
Mahesh
Pegasystems Inc.
US
I was able to get -z to work by passing the argument in the way that I mentioned (-z "ABC-FW-PRJ-WORK C-100"), but it doesn't seem to work with both -z and -Z simultaneously. Ramesh, can you please open an SR for this and let us know the SR number? If there isn't a bug preventing this from working, at the very least the documentation needs to be updated to explain how to accomplish this.
Accepted Solution
Pegasystems Inc.
US
It wasn't clear originally that Ramesh was calling pxExtractDataWithArgs from an activity. In order to pass -z and -Z to pxExtractDataWithArgs from an activity, they should be specified like this:
"-z \"LOVI-LOVINAPP-WORK C-1\" -Z \"LOVI-LOVINAPP-WORK C-1\""
Backslashes need to be added to escape the quotes used for the pzInsKeys, and in addition, the entire string needs to be placed in quotes.
If you have an agent that calls pxExtractDataWithArgs, you would specify the values as I originally mentioned:
-z "ABC-FW-PRJ-WORK C-100" -Z "ABC-FW-PRJ-WORK C-100"