Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Can't get column types" when Sqoop Teradata mapping fails
Problem Description
Sqoop Teradata mapping against a Teradata table with TITLES for columns fails with the following exception:

2019-01-07 11:01:28.438 <LdtmWorkflowTask-pool-1-thread-1> INFO: The Integration Service finished running the task [Pre_Spark_Task_Command_1].
2019-01-07 11:01:28.942 <LdtmWorkflowTask-pool-1-thread-2> INFO: Beginning code generation
2019-01-07 11:01:29.031 <LdtmWorkflowTask-pool-1-thread-2> INFO: Got exception running Sqoop: java.lang.RuntimeException: Can't get column types
2019-01-07 11:01:29.037 <LdtmWorkflowTask-pool-1-thread-2> INFO: 
2019-01-07 11:01:29.039 <LdtmWorkflowTask-pool-1-thread-2> FINE: Summary Statistics for Task [Pre_UserDefinedJob_Task_1]: [
  |  Name: Pre_UserDefinedJob_Task_1
  |  Status: Failed
]
2019-01-07 11:01:29.039 <LdtmWorkflowTask-pool-1-thread-2> INFO: Sqoop Execution has failed
2019-01-07 11:01:29.039 <LdtmWorkflowTask-pool-1-thread-2> SEVERE: UserDefinedJob execution failed
java.lang.RuntimeException: UserDefinedJob execution failed
 at com.informatica.platform.ldtm.executor.userdefinedjob.UserDefinedJobMethodInvocationExecutor.run(UserDefinedJobMethodInvocationExecutor.java:236)
 at com.informatica.platform.ldtm.executor.userdefinedjob.UserDefinedJobBaseExecutor.execute(UserDefinedJobBaseExecutor.java:42)
 at com.informatica.executor.workflow.taskhandler.impl.UserDefinedTaskHandlerImpl.executeMainScript(UserDefinedTaskHandlerImpl.java:109)
 at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.executeMainScriptAsync(BaseTaskHandlerImpl.java:388)
 at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.startTaskAsync(BaseTaskHandlerImpl.java:212)
 at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.runAsync(BaseTaskHandlerImpl.java:188)
 at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.run(BaseTaskHandlerImpl.java:115)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
2019-01-07 11:01:29.040 <LdtmWorkflowTask-pool-1-thread-2> SEVERE: The Integration Service failed to run the task [Pre_UserDefinedJob_Task_1]. See the additional error messages for more information.
java.lang.RuntimeException: [java.lang.RuntimeException: UserDefinedJob execution failed]
Cause
Configuration
Solution
To resolve the issue, update the connection string at Additional Sqoop arguments section in the Sqoop connection as follows:
--connect jdbc:teradata://tdserver.xxxxx/database=xyz,LOGMECH=LDAP,column_name=on 
More Information
Applies To
Product: PowerExchange; PowerCenter; Big Data Management
Problem Type: Connectivity
User Type: Administrator
Project Phase: Implement
Product Version: PowerExchange for Teradata Parallel Transporter API 10.2.0; PowerExchange for Teradata Parallel Transporter API 10.2.1
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:5/16/2019 10:50 PMID:531874
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)