java.io.IOException: ORA-00933: SQL command not properly ended

incubator-sqoop-user | bejoy ks | 5 years ago
  1. 0

    Re: Fw: Fw: [sqoop-user] sqoop import shows ORA-00933: SQL command notproperlyended error

    incubator-sqoop-user | 5 years ago | bejoy ks
    java.io.IOException: ORA-00933: SQL command not properly ended
  2. 0

    Attempting to perform a HBase import using Quest® Data Connector for Oracle and Hadoop (formerly known as Oraoop) causes an IOException. Cause appears to be use of DataDrivenDBInputFormat.class in HBaseImportJob initialisation instead of importContext.getInputFormat(). Will submit a patch once I've confirmed the cause. Stack trace follows. 11/05/19 12:23:46 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: ORA-00936: missing expression at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:201) at org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:944) at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:961) at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880) at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115) at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833) at org.apache.hadoop.mapreduce.Job.submit(Job.java:476) at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:506) at com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:107) at com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:166) at com.cloudera.sqoop.manager.SqlManager.importTable(SqlManager.java:386) at com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:255) at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:350) at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423) at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79) at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)

    Cloudera Open Source | 6 years ago | Peter Hall
    java.io.IOException: ORA-00936: missing expression
  3. 0

    java.io.IOException: Job failed! ORA-00933: sql command not properly ended , hadoop

    Stack Overflow | 2 years ago
    java.io.IOException: ORA-00933: sql command not properly ended
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [~gagravarr] noticed that one of our old test files fails a Tika test now with PDFBox 1.8.7 and Java 1.6. I just tested the pure PDFBox app built with PDFBox 1.8.8-SNAPSHOT, and I'm getting the same exception with Java 1.6 and Java 1.7. Stacktrace: {noformat} ExtractText failed with the following exception: java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded at javax.crypto.CipherInputStream.getMoreData(CipherInputStream.java:118) at javax.crypto.CipherInputStream.read(CipherInputStream.java:236) at javax.crypto.CipherInputStream.read(CipherInputStream.java:212) at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.encryptData(SecurityHandler.java:316) at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decryptStream(SecurityHandler.java:421) at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decrypt(SecurityHandler.java:390) at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.decryptObject(SecurityHandler.java:365) at org.apache.pdfbox.pdmodel.encryption.SecurityHandler.proceedDecryption(SecurityHandler.java:196) at org.apache.pdfbox.pdmodel.encryption.StandardSecurityHandler.decryptDocument(StandardSecurityHandler.java:158) at org.apache.pdfbox.pdmodel.PDDocument.openProtection(PDDocument.java:1598) at org.apache.pdfbox.ExtractText.startExtraction(ExtractText.java:216) at org.apache.pdfbox.ExtractText.main(ExtractText.java:85) at org.apache.pdfbox.PDFBox.main(PDFBox.java:58) Caused by: javax.crypto.BadPaddingException: Given final block not properly padded at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:811) at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:676) at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:423) at javax.crypto.Cipher.doFinal(Cipher.java:1708) at javax.crypto.CipherInputStream.getMoreData(CipherInputStream.java:112) ... 12 more {noformat} java version "1.7.0_71" OpenJDK Runtime Environment (rhel-2.5.3.1.el6-x86_64 u71-b14) OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode) and java version "1.6.0_33" OpenJDK Runtime Environment (IcedTea6 1.13.5) (rhel-1.13.5.0.el6_6-x86_64) OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)

    Apache's JIRA Issue Tracker | 2 years ago | Tim Allison
    java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.io.IOException

      ORA-00933: SQL command not properly ended

      at com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits()
    2. com.cloudera.sqoop
      DataDrivenDBInputFormat.getSplits
      1. com.cloudera.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:201)
      1 frame
    3. Hadoop
      JobClient$2.run
      1. org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:944)
      2. org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:961)
      3. org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170)
      4. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:880)
      5. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833)
      5 frames
    4. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:396)
      2 frames
    5. Hadoop
      UserGroupInformation.doAs
      1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1127)
      1 frame
    6. Hadoop
      Job.waitForCompletion
      1. org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833)
      2. org.apache.hadoop.mapreduce.Job.submit(Job.java:476)
      3. org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:506)
      3 frames
    7. com.cloudera.sqoop
      Sqoop.run
      1. com.cloudera.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:107)
      2. com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:166)
      3. com.cloudera.sqoop.manager.SqlManager.importQuery(SqlManager.java:419)
      4. com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:352)
      5. com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
      6. com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      6 frames
    8. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      2. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
      2 frames
    9. com.cloudera.sqoop
      Sqoop.main
      1. com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
      2. com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
      3. com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)
      3 frames