My Oracle Support Banner

H2T execution using Sqoop SSH Mode fails (Doc ID 2755819.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

While executing H2T using the sqoop SSH mode, the job fails with below error

Error
-------
2021-02-02 14:53:30,422 ERROR [IPC Server handler 3 on 12313] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Task: attempt_1611315700833_23241_m_000001_0 - exited : java.io.IOException: Can't export data, please check failed map task logs
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:121)
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146)

Caused by: java.lang.RuntimeException: Can't parse input data: '2020-03-19'
at STG_EXCHANGE_RATE_HIST.__loadFromFields(STG_EXCHANGE_RATE_HIST.java:599)
at STG_EXCHANGE_RATE_HIST.parse(STG_EXCHANGE_RATE_HIST.java:480)
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:88)
... 10 more
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:204)
at STG_EXCHANGE_RATE_HIST.__loadFromFields(STG_EXCHANGE_RATE_HIST.java:551)
... 12 more

Steps to reproduce
---------------------
Execute H2T

Business impact
--------------------
Due to this issue, users cannot execute H2T

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.