Db2- Batch failure. Error - ERRORCODE=-4229, SQLSTATE=null


Article ID: 222945


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)



Hi Team,

When we try to mask the Db2 database we are getting the below error, PFA of the files for the error caused and let us know if you need information from our end.

Error Message : 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 





Permission issues on the target database



TDM 4.9.x

Component : test data manager



Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null 
2021-08-24 16:55:14.975 Thread:ACTUARIAL_POLICY_TYPE - Error for batch element #1: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=TDM_USR;UPDATE;BHA_MONTHLY.ACTUARIAL_POLICY_TYPE, DRIVER=4.19.66 

I did some checking ad the SQL error code -551 can mean that there log space on the target machine is full.
or it could be a permissions issue for the user being used.

I found another document that said the -551 error is a permissions issue.
You will need to work with your DBA to understand and correct these errors as they are being returned directly from the Database server.