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

book

Article ID: 222945

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

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 

 

 

Cause

 

Permission issues on the target database

Environment

 

TDM 4.9.x

Component : test data manager

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 

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.