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

SA-50816

Summary




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


com.ibm.db2.jcc.am.SqlException: [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 com.ibm.db2.jcc.am.kd.a(Unknown Source) ~[db2jcc4.jar:?]

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

at com.ibm.db2.jcc.am.ge.a(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.db2.jcc.am.lc.c(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.db2.jcc.am.lc.a(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.db2.jcc.am.lc.a(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.db2.jcc.am.gp.a(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.db2.jcc.am.gp.setString(Unknown Source) ~[db2jcc4.jar:?]

at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.psSetString(InternalGenericDataStoreHelper.java:734) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setString(WSJdbcPreparedStatement.java:2668) ~[com.ibm.ws.runtime.jar:?]

at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.setString(DatabasePreparedStatementImpl.java:662) ~[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 yyyy-mm-dd-hh.mm.ss[.ffffffffffff][ ](+|-)th:tm and thus the error.


Resolution



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