Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop Export to Teradata (BatchUpdateException)


Copy link to this message
-
Sqoop Export to Teradata (BatchUpdateException)
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
+
Abraham Elmahrek 2013-12-07, 19:11
+
Dipesh Kumar Singh 2013-12-11, 07:41
+
Abraham Elmahrek 2013-12-11, 08:11
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB