Support Article
BIX Extract using shell script -u param off by one hour
SA-29526
Summary
Developer wants to use the -u and -U parameters in the BIX script to extract cases by pxUpdateDateTime from midnight of a particular day to midnight of another day, using parameters like:
b=1, a=BixUser, U=20160926T235959.999, u=20160926T000000.000, i=PegaSample!Test, p=password
However, the query that is generated for the extract shows, it is actually extracting from 1 am to 1am.
Generated SQL:
SELECT pzPVStream FROM PEGADATA.your_work_table WHERE pzInsKey like ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? ORDER BY pzInsKey <2016-09-26 01:00:00.0> <2016-09-27 00:59:59.999>
The server running this is currently using the EDT timezone.
Error Messages
Not applicable
Steps to Reproduce
Run a BIX extract from command line and use the -u / -U parameters.
Root Cause
A defect in Pegasystems’ code or rules causes the EST timezone to be used by default.
Resolution
Perform the following local-change:
Include the timezone with the -u / -U parameters like "-u 20161012T235959.999 EDT" or "-U 20161012T235959.999 GMT".
Published November 12, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.