Discussion

2
Replies
830
Views
Close popover
Dineshkumar Sivakumar (DineshkumarS)
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
Associate Architect
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
AU
DineshkumarS Member since 2012 1 post
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
Posted: January 30, 2016
Last activity: February 24, 2016
Closed

Error while inserting saving Interaction History using Database via Class in Pega DSM

Hi All,

I am getting the following error in Pega DSM connected to DB2 while saving Interaction History using "Database via Class" option in the interaction rule of Pega DSM framework.

Caused by SQL Problems.
Problem #1, SQLState null, Error code -4229: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.63.75] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

Problem #2, SQLState 57016, Error code -668: com.ibm.db2.jcc.am.SqlException: Error for batch element #1: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;RULES.SIMPLEOFFER, DRIVER=3.63.75

On googling

Error -4229 = insert failed due to some issue

Error -668 = don't have privilage to alter table (but i am \ pega not trying to update :-( )

Please let me know if know the fix for this issue. 

Data Integration
Moderation Team has archived post