Support Article
BIX extracts date time properties are not correct after upgrade
SA-20697
Summary
After upgrade to 7.1.9, BIX extracted date and datetime properties to XML are not in the correct format. Running the BIX extracts from command prompt using -I option.
Error Messages
Output files contains incorrect date timestamp.
Example :-
After upgrade XML output has different date and datetime format
<CompleteByDateTime>20140904T210000.000 GMT</CompleteByDateTime>
<DueDate>20140904</DueDate>
Before the upgrade, output was in correct format:
<CompleteByDateTime>2015-06-04T00:00:00.000Z</CompleteByDateTime>
<DueDate>2015-06-04</DueDate>
Steps to Reproduce
Run the BIX extracts from command prompt and check the output file
Root Cause
A defect in Pegasystems’ code or rules. Datetime , date properties are not properly formatted, when -i/-I is used without -a, -p as the requestor is not authenticated. Need way for -I option to be able to provide -a/-p parameters so the extract can run with an authenticated user. The -i option already has ability to run with -a/-p.
Resolution
Apply HFix-26448
Run your extract from the command line using -I and the -a <username> and -p <password> parameters for a Pega operator who has the correct access group to run the BIX extraction. When the -a/-p parameters are used the extraction will no longer be running as an unauthenticated requestor and the date and datetime properties will be written to the XML file in the correct format.
Published March 16, 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.