Trying to connect to DB2 using Sqoop Generates Map Tasks Raising: "Error: com.ibm.db2.jcc.am.lm.isClosed()Z" on the BDA
(Doc ID 1956451.1)
Last updated on DECEMBER 10, 2019
Applies to:
Big Data Appliance Integrated Software - Version 3.0.1 and laterx86_64
Symptoms
NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.
While trying to connect to DB2 using Sqoop, map tasks raising the error "Error: com.ibm.db2.jcc.am.lm.isClosed()Z" on the BDA.
Running the sqoop job with "-verbose" shows map tasks failing with:
...
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_0, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_1, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_2, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_3, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Job job_1417824162389_3059 failed with state FAILED due to:
...
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: The MapReduce job has already been retired. Performance
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: counters are unavailable. To get this information,
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: you will need to enable the completed job store on
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: the jobtracker with:
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.active = true
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.hours = 1
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: A jobtracker restart is required for these settings
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: to take effect.
14/12/15 11:26:39 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.Launcher$AppClassLoader@<STRING>
14/12/15 11:26:39 ERROR tool.ImportTool: Error during import: Import job failed!
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_0, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_1, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_2, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Task Id : attempt_1417824162389_3059_m_000000_3, Status : FAILED
Error: com.ibm.db2.jcc.am.lm.isClosed()Z
14/12/15 11:26:39 INFO mapreduce.Job: Job job_1417824162389_3059 failed with state FAILED due to:
...
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: The MapReduce job has already been retired. Performance
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: counters are unavailable. To get this information,
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: you will need to enable the completed job store on
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: the jobtracker with:
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.active = true
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: mapreduce.jobtracker.persist.jobstatus.hours = 1
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: A jobtracker restart is required for these settings
14/12/15 11:26:39 INFO mapreduce.ImportJobBase: to take effect.
14/12/15 11:26:39 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.Launcher$AppClassLoader@<STRING>
14/12/15 11:26:39 ERROR tool.ImportTool: Error during import: Import job failed!
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |