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 JUNE 16, 2017
Applies to:
Big Data Appliance Integrated Software - Version 3.0.1 and laterx86_64
Symptoms
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@1a722ef
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@1a722ef
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 |