Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 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: Jan 30, 2016
Last activity: Feb 24, 2016
Posted: 30 Jan 2016 7:15 EST
Last activity: 24 Feb 2016 6:47 EST
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. 

To see attachments, please log in.
Data Integration

  • Venkat Raman Malaiarasan
Posted: 8 years ago
Posted: 1 Feb 2016 1:23 EST
Dineshkumar Sivakumar (DineshkumarS)
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
Associate Architect
ARETEANS TECHNOLOGY SOLUTIONS PVT. LTD.
AU
For those who is facing the similar issue, i fixed this issue by executing the following query CALL SYSPROC.ADMIN_CMD('REORG TABLE MY_TABLE_NAME') as mentioned in http://stackoverflow.com/questions/7578013/db2-sqlcode-668-when-inserting
To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center 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