Discussion

2
Replies
789
Views
DineshkumarS Member since 2012 1 post
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
Posted: 4 years ago
Last activity: 4 years 8 months ago
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
Share this page LinkedIn