sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dipesh Kumar Singh <dipesh.t...@gmail.com>
Subject Sqoop Export to Teradata (BatchUpdateException)
Date Mon, 02 Dec 2013 18:17:54 GMT
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

Mime
View raw message