search cancel

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

Test Data Manager
TDM Portal

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.