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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.