Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - Sqoop Export to Teradata (BatchUpdateException)


Copy link to this message
-
Sqoop Export to Teradata (BatchUpdateException)
Dipesh Kumar Singh 2013-12-02, 18:17
Hello Users,
It is not evident to me what might have went wrong which is leading to this
exception --
"[Error 1154] [SQLState HY000] A failure occurred while inserting the batch
of rows destined for database table "DW1_DS_WORK"."dd_TP_BAL_REPT4".
Details of the failure can be found in the exception chain that is
accessible with getNextException.

"
Can anyone help me on resolving this exception. Below is the complete stack
trace.
inserting the batch of rows destined for database table
"DW1_DS_WORK"."dd_TP_BAL_REPT1". Details of the failure can be found in the
exception chain that is accessible with getNextException.
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:133)
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:27)
        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:531)
        at
org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:82)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:40)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at
com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper
13/12/02 09:34:25 INFO mapred.JobClient: Task Id :
attempt_201311141752_15941_m_000003_0, Status : FAILED
java.io.IOException: java.sql.BatchUpdateException: [Teradata JDBC Driver]
[TeraJDBC 13.10.00.35] [Error 1154] [SQLState HY000] A failure occurred
while inserting the batch of rows destined for database table
"DW1_DS_WORK"."dd_TP_BAL_REPT3". Details of the failure can be found in the
exception chain that is accessible with getNextException.
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:133)
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:27)
        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:531)
        at
org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:82)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:40)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at
com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper
13/12/02 09:34:26 INFO mapred.JobClient: Task Id :
attempt_201311141752_15941_m_000004_0, Status : FAILED
java.io.IOException: java.sql.BatchUpdateException: [Teradata JDBC Driver]
[TeraJDBC 13.10.00.35] [Error 1154] [SQLState HY000] A failure occurred
while inserting the batch of rows destined for database table
"DW1_DS_WORK"."dd_TP_BAL_REPT4". Details of the failure can be found in the
exception chain that is accessible with getNextException.
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:133)
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:27)
        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:531)
        at
org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:82)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:40)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at
com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper
13/12/02 09:34:27 INFO mapred.JobClient: Task Id :
attempt_201311141752_15941_m_000008_0, Status : FAILED
java.io.IOException: java.sql.BatchUpdateException: [Teradata JDBC Driver]
[TeraJDBC 13.10.00.35] [Error 1154] [SQLState HY000] A failure occurred
while inserting the batch of rows destined for database table
"DW1_DS_WORK"."dd_TP_BAL_REPT8". Details of the failure can be found in the
exception chain that is accessible with getNextException.
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:133)
        at
com.cloudera.sqoop.teradata.exports.TeradataRecordWriter.write(TeradataRecordWriter.java:27)
        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:531)
        at
org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:82)
        at
com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:40)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)

Thanks & Regards
Dipesh
Dipesh Kr. Singh