4 Replies Latest reply on Jun 14, 2021 1:19 AM by user186817

    how to solve the column containing character % in mass ingetsion with source SQL Server

    Niaga Prima Active Member

      Hi Support,

       

      I create mass ingestion job with simple table and column, but its failed because the column containing character '%", how to solve it?

      Please check log and attached image.

       

      2021-05-31 19:59:53.485 <LdtmWorkflowTask-pool-5-thread-270> INFO: Remove compiled files failed with exception: URLDecoder: Incomplete trailing escape (%) pattern

      java.lang.IllegalArgumentException: URLDecoder: Incomplete trailing escape (%) pattern

          at java.net.URLDecoder.decode(URLDecoder.java:187)

          at org.apache.sqoop.SqoopOptions.parseColumnMapping(SqoopOptions.java:1360)

          at org.apache.sqoop.SqoopOptions.setMapColumnJava(SqoopOptions.java:1375)

          at org.apache.sqoop.tool.BaseSqoopTool.applyCodeGenOptions(BaseSqoopTool.java:1363)

          at org.apache.sqoop.tool.ImportTool.applyOptions(ImportTool.java:1011)

          at org.apache.sqoop.tool.SqoopTool.parseArguments(SqoopTool.java:435)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil$SqoopT.run(SqoopExecUtil.java:330)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil.runInfaSqoop(SqoopExecUtil.java:800)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil.invoke(SqoopExecUtil.java:766)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil.access$1(SqoopExecUtil.java:646)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil$GetSqoopHandler.run(SqoopExecUtil.java:626)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil$GetSqoopHandler.run(SqoopExecUtil.java:1)

          at java.security.AccessController.doPrivileged(Native Method)

          at javax.security.auth.Subject.doAs(Subject.java:422)

          at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1920)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil.run(SqoopExecUtil.java:956)

          at com.informatica.platform.dtm.executor.hadoop.shellcmd.SqoopExecUtil.main(SqoopExecUtil.java:556)

          at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:498)

          at com.informatica.platform.ldtm.executor.userdefinedjob.UserDefinedJobMethodInvocationExecutor.run(UserDefinedJobMethodInvocationExecutor.java:232)

          at com.informatica.platform.ldtm.executor.userdefinedjob.UserDefinedJobBaseExecutor.execute(UserDefinedJobBaseExecutor.java:54)

          at com.informatica.executor.workflow.taskhandler.impl.UserDefinedTaskHandlerImpl.executeMainScript(UserDefinedTaskHandlerImpl.java:153)

          at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.executeMainScriptAsync(BaseTaskHandlerImpl.java:451)

          at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.startTaskAsync(BaseTaskHandlerImpl.java:234)

          at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.runAsync(BaseTaskHandlerImpl.java:200)

          at com.informatica.executor.workflow.taskhandler.impl.BaseTaskHandlerImpl.run(BaseTaskHandlerImpl.java:119)

          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)

      2021-05-31 19:59:53.485 <LdtmWorkflowTask-pool-5-thread-270> INFO:

      2021-05-31 19:59:53.485 <LdtmWorkflowTask-pool-5-thread-270> INFO: Summary Statistics for Task [Pre_UserDefinedJob_Task_0]: [

        |  Name: Pre_UserDefinedJob_Task_0

        |  Status: Failed

      ]

      2021-05-31 19:59:53.486 <LdtmWorkflowTask-pool-5-thread-270> INFO: Sqoop Execution has failed

      2021-05-31 19:59:53.486 <LdtmWorkflowTask-pool-5-thread-270> SEVERE: UserDefinedJob execution failed

       

      Thanks,

      Suyanto