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

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

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 

 

 

Environment

 

All supported TDM releases.

Cause

 

Permission issues on the target database

Resolution

 

 

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 

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.

Work with your DBA to understand and correct these errors as they are being returned directly from the Database server.