Support Article
BIX extract fails due to past date in the request
SA-12709
Summary
BIX extract fails due to a date in the request.
Below is the XML request/case received with date 03/30/1871 for which BIX (Pega Job which extracts the data) generated an error because the job cannot support the DateTime value before the year 1901.
<abc>data1</abc>
<def>data2</def>
<adatetime>18710330T045602.000 GMT</adatetime>
Error Messages
(internal.access.ExtractImpl) ERROR - Unable to process Work-MyWork: Assertion botch: negative time
Steps to Reproduce
Not Applicable
Root Cause
The root cause of this problem is in a third-party product. There is a bug in the Oracle JDBC driver.
Resolution
This issue is resolved by making the following change to the operating environment:
Use the following version of the Oracle JDBC driver or later to address the bug noted below (9491954).
Oracle JDBC Drivers release 11.2.0.2 Readme.txt
===============================================
Note: this readme is specific to fixes in 11.2.0.2 patch-set; see
...
9491954 RuntimeException "Assertion botch: negative time" from Timestamp bind
Published August 12, 2015 - 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.