Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

BIX Extract does not extract correct data

SA-100137

Summary



Business Intelligence Exchange (BIX) Extract does not extract the correct data.


Error Messages



Not Applicable


Steps to Reproduce



Configure the agent activity such that it executes the BIX extract.


Root Cause



A defect or configuration issue in the operating environment 

When using -g/-G command line arguments, the agent context defines the timezone.

-g <start date> only extracts instances with a pxCommitDateTime equal to or greater than <start date>.

The <start date> must be in the '20110823T164017.000' format, following the Java pattern 'yyyyMMddTHHmmss.SSS' and relative to the local time zone.

Note: Clear the Use Last Update Time as Start checkbox on the Filter criteria tab of the Extract form when using this parameter because it does not override the checkbox setting.

-G <end date> only extracts instances with a pxCommitDateTime equal to or less than <end date>.

The <end date> must be in the '20110823T164017.000' format, following the Java pattern 'yyyyMMddTHHmmss.SSS' and relative to the local time zone.

Note: Clear the Use Last Update Time as Start checkbox on the Filter criteria tab of the Extract form when using this parameter because it does not override the checkbox setting.



Resolution



Perform the following local-change:

Use the -u/U boundary and specify a timezone.

-u <start date> only extracts instances with a pxUpdateDateTime equal to or greater than <start date>.

The <start date> must be in the '20110823T164017.000' format, following the Java pattern 'yyyyMMddTHHmmss.SSS'. The user can also optionally include the timezone (for example, 20110823T164017.000 GMT).

If the user does not include the time zone, the time zone is the locale that is set on the thread or the default locale of 'en_US' and time zone of 'EST'.

Note: Clear the Use Last Updated Time as Start checkbox on the Filter criteria tab of the Extract form when using this parameter because it does not override the checkbox setting.

-U <end date> only extracts instances with a pxUpdateDateTime equal to or less than <end date>. The <end date> must be in the '20110823T164017.000' format, following the Java pattern 'yyyyMMddTHHmmss.SSS'. 

The user can optionally include the time zone (for example, 20110823T164017.000 GMT).

If the user does not include the time zone, the time zone is the locale that is set on the thread or the default locale of 'en_US' and time zone of 'EST'.

Note: Clear the Use Last Updated Time as Start checkbox on the Filter criteria tab of the Extract form when using this parameter because it does not override the checkbox setting.

Published February 10, 2020 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us