Posted: 30 Jan 2016 7:15 EST Last activity: 24 Feb 2016 6:47 EST
Error while inserting saving Interaction History using Database via Class in Pega DSM
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][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
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.