Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Issue when saving instance of class PegaHealth-Work-CodeSet



PegaHealth-Work-CodeSet instances (viz. PEGAHEALTH-WORK CSET-1) are failing to import due to this error after HEALTHCODES_WORK table columns pyAgeFromDate, pySLADeadline and pySLAGoal were set to DATA TYPE TIMESTAMP.

Environment Details:
PegaFHC_7.31 PFHC_Sample_Codes_731.jar import on IBM DB2 10.5 FP6 with jdbc driver 4.19.26.

Error Messages [jcc][1093][10427][4.19.26] Invalid data conversion: Parameter instance 20131226T125209.180 GMT is invalid for the requested conversion to java.sql.Timestamp. ERRORCODE=-4220, SQLSTATE=null

at Source) ~[db2jcc4.jar:?]

Caused by: java.lang.IllegalArgumentException: [jcc][10501][13501]DBTimestamp format must be in the format of[.ffffffffffff][ ](+|-)th:tm, yyyy-mm-dd hh:mm:ss[.ffffffffffff][ ](+|-)th:tm,[.ffffffffffff], or yyyy-mm-dd hh:mm:ss[.ffffffffffff] where the number of digits of fractional seconds can range from 0 to 12.

at Source) ~[db2jcc4.jar:?]

at Source) ~[db2jcc4.jar:?]

at Source) ~[db2jcc4.jar:?]

at Source) ~[db2jcc4.jar:?]

at Source) ~[db2jcc4.jar:?]

at Source) ~[db2jcc4.jar:?]

at ~[]

at ~[]

at ~[prprivate.jar:?]

Steps to Reproduce

Import PFHC_Sample_Codes_731.jar.

Root Cause

A defect in Pegasystems’ code or rules:

20131226T125209.180 GMT is not a valid DBTimestamp value of the format[.ffffffffffff][ ](+|-)th:tm and thus the error.


Make the following change to the operating environment:

Following HEALTHCODES_WORK table columns pyAgeFromDate, pySLADeadline and pySLAGoal data type DATA TYPE change TIMESTAMP Engine Class map must be rebuilt. For this restart the JVM and then perform the import.

Suggest Edit

Published February 21, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us