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 October 24, 2016 - Updated November 11, 2016

Have a question? Get answers now.

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