TDM Portal generator fails with Teradata Error 1338

book

Article ID: 185712

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

When executing the TDM Portal Generator against a Teradata database, error code 1338 is shown.

The full error message:
Insert into Mytable failed: UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO "DEV_JV"."Mytable" ("Code","Name","Location","Manager","Active_ts","Archive_ts") VALUES (?,?,?,?,?,?)]; SQL state [HY000]; error code [1338]; [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.; nested exception is java.sql.BatchUpdateException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch request. Details of the failure can be found in the exception chain that is accessible with getNextException.

Environment

Release : 4.6

Component : CA Test Data Manager

Resolution

Check that the Teradata data type and the value to be inserted are matching.

Additional Information

https://stackoverflow.com/questions/39492145/teradata-jdbc-error-1338-after-certain-number-of-batch-executions
This could be related to size or value.