SA-13296

Summary

An error is encountered when trying to write to external DB2 table from Pega 7.1.7 using Obj-Save. Pega is running on Oracle 11g.

The DB2 table has a column defined as Date and Pega 7.1.7 has corresponding Date property.

Error Messages

Problem saving instance of class PEGA-FW-CLASS: code: -4474 SQLState: <none> Message: [jcc][1083][10395][4.19.26] Illegal conversion: can not convert from "java.lang.int" to "java.sql.Date" ERRORCODE=-4474, SQLSTATE=null

Steps to Reproduce

1. Create a data class and have it mapped to an external DB2 table.
2. Create an activity that uses Obj-Save to write to the DB2 table.
3. Run the activity.

Root Cause

A defect in Pegasystems’ code or rules. The issue occurs when a class is mapped to a table in external database which is not same as the database hosting Pega. External database is DB2 and table has a Date column.

Resolution

Apply HFix-23317 to resolve this issue.