Hello Jarcec, thank you very much for your time and effort!
I used the Hue UI to recreate the scenario, since I had lost the logs from the last run, and this time it worked. I can't honestly tell you what else I did differently but I can move on with testing and evaluating now. Thank you again! Christos -- initions AG Christos Kallinteris Weidestraße 120a D-22083 Hamburg t: +49 (0) 40 / 41 49 60-79 f: +49 (0) 40 / 41 49 60-11 e: [email protected] w: www.initions.com Vollständiger Name der Gesellschaft: initions innovative IT solutions AG Sitz der Gesellschaft: Hamburg Handelsregister Hamburg B 83929 Aufsichtsratsvorsitzender: Dr. Michael Leue Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn -----Ursprüngliche Nachricht----- Von: Jarek Jarcec Cecho [mailto:[email protected]] Gesendet: Montag, 16. September 2013 10:06 An: [email protected] Betreff: Re: Data export to SQL Server fails with MAPRED_EXEC_0017:Error occurs during extractor run Hi Christos, yes I mean the logs that can be retrieved from JobTracker. On the main webpage, you need to get into job details and then find one failed task. We need entire log not just the exception. Jarcec On Thu, Sep 12, 2013 at 07:48:07AM +0000, Kallinteris, Christos wrote: > Hello Jarcec, > > I'm not sure which logs you require. > > Do you mean the ones accessed through http://server:50030/jobdetails.jsp ? > > This is what I get there. If you need a different log please let me know how > and where to access it. > > Thank you! > > Christos > > ------------------BEGIN LOG-------------------- > > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during > extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > at > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > at org.apache.sqoop.job.etl.HdfsExportExtract > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during > extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > at > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > at org.apache.sqoop.job.etl.HdfsExportExtract > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during > extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > at > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > at org.apache.sqoop.job.etl.HdfsExportExtract > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs during > extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > at > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > at > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > at org.apache.sqoop.job.etl.HdfsExportExtract > > --------------------------------------------------END LOG > --------------------------------- > > -- > > initions AG > Christos Kallinteris > Weidestraße 120a > D-22083 Hamburg > > t: +49 (0) 40 / 41 49 60-79 > f: +49 (0) 40 / 41 49 60-11 > e: [email protected] > w: www.initions.com > > > Vollständiger Name der Gesellschaft: initions innovative IT solutions > AG Sitz der Gesellschaft: Hamburg Handelsregister Hamburg B 83929 > Aufsichtsratsvorsitzender: Dr. Michael Leue > Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn > > -----Ursprüngliche Nachricht----- > Von: Jarek Jarcec Cecho [mailto:[email protected]] > Gesendet: Donnerstag, 12. September 2013 08:38 > An: [email protected] > Betreff: Re: Data export to SQL Server fails with > MAPRED_EXEC_0017:Error occurs during extractor run > > Hi Christos, > would you mind sharing with us map task log from the failed job? > > Jarcec > > On Mon, Sep 09, 2013 at 12:39:34PM +0000, Kallinteris, Christos wrote: > > > > Hello all! > > > > I have installed the latest CDH + Manager version from Cloudera on a > > freshly installed Ubuntu 12.04 virtual host. > > > > I have successfully imported a table from SQL Server into HDFS text files. > > > > When I try to export it again to a new table with the exact same schema as > > the original I get the following error in the logs: > > > > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs > > during extractor run > > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:396) > > at > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > > at org.apache.hadoop.mapred.Child.main(Child.java:262) > > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > > write to the data writer > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > > at > > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > > at org.apache.sqoop.job.etl.HdfsExportExtract > > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs > > during extractor run > > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:396) > > at > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > > at org.apache.hadoop.mapred.Child.main(Child.java:262) > > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > > write to the data writer > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > > at > > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > > at org.apache.sqoop.job.etl.HdfsExportExtract > > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs > > during extractor run > > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:396) > > at > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > > at org.apache.hadoop.mapred.Child.main(Child.java:262) > > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > > write to the data writer > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > > at > > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > > at org.apache.sqoop.job.etl.HdfsExportExtract > > org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0017:Error occurs > > during extractor run > > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:98) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330) > > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:396) > > at > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > > at org.apache.hadoop.mapred.Child.main(Child.java:262) > > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > > write to the data writer > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeContent(SqoopMapper.java:146) > > at > > org.apache.sqoop.job.mr.SqoopMapper$MapDataWriter.writeCsvRecord(SqoopMapper.java:133) > > at > > org.apache.sqoop.job.etl.HdfsExportExtractor.extractTextFile(HdfsExportExtractor.java:176) > > at org.apache.sqoop.job.etl.HdfsExportExtract > > > > > > Any help or ideas will be greatly appreciated! > > > > Thanks! > > > > Christos > > > > -- > > > > initions AG > > Christos Kallinteris > > Weidestraße 120a > > D-22083 Hamburg > > > > t: +49 (0) 40 / 41 49 60-79 > > f: +49 (0) 40 / 41 49 60-11 > > e: [email protected]<mailto:[email protected]> > > w: www.initions.com<http://www.initions.com/> > > > > > > Vollständiger Name der Gesellschaft: initions innovative IT > > solutions AG Sitz der Gesellschaft: Hamburg Handelsregister Hamburg > > B 83929 > > Aufsichtsratsvorsitzender: Dr. Michael Leue > > Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn > >
