Sqoop command is failing for Oracle database on CDP 7.1.9 cluster and same command works on different cluster of same version The only difference between working and non-working is storage, it might not be the main issue. sqoop command: sqoop import -libjars ./ojdbc8.jar -Doracle.jdbc.defaultNChar=true -Doracle.jdbc.OracleConnection.CONNECTION_PROPERTY_SET_ROW_PREFETCH_SIZE=10 -Doracle.jdbc.timezoneAsRegion=false -Doracle.sessionTimeZone=Asia/Kolkata -Doracle.jdbc.NLS_LANG=AMERICAN_AMERICA.AL32UTF8 -Doracle.jdbc.timezoneAsRegion=false --connect jdbc:oracle:thin:@hostname:1522:servicename --password $password --map-column-java CHAR_COL=String,DATE_COL=String,FLOAT_COL=Double,TIMESTAMP_COL=String,VARCHAR_COL=String,VARCHAR2_COL=String,NUMPERPS_COL=String,LONG_COL=String --username $username --as-avrodatafile --split-by FLOAT_COL --mapreduce-job-name SQOOP_SOURCE --columns CHAR_COL,DATE_COL,FLOAT_COL,TIMESTAMP_COL,VARCHAR_COL,VARCHAR2_COL,NUMPERPS_COL,LONG_COL --delete-target-dir --table SQOOP_SOURCE --target-dir hdfs://nameservice1/tmp/SPARK we tried removing "-Doracle.jdbc.NLS_LANG=AMERICAN_AMERICA.AL32UTF8" from cluster node and still facing same issue. 5/08/01 15:54:13 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7.7.1.9.1000-103 25/08/01 15:54:13 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 25/08/01 15:54:13 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled. 25/08/01 15:54:13 INFO manager.SqlManager: Using default fetchSize of 1000 25/08/01 15:54:13 INFO tool.CodeGenTool: Beginning code generation 25/08/01 15:54:14 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified https://docs.oracle.com/error-help/db/ora-00604/ java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified https://docs.oracle.com/error-help/db/ora-00604/ at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:712) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:607) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:602) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1695) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:936) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:969) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:547) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTHWithO5Logon(T4CTTIoauthenticate.java:1746) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1493) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1433) at oracle.jdbc.driver.T4CConnection.authenticateWithPassword(T4CConnection.java:2056) at oracle.jdbc.driver.T4CConnection.authenticateUserForLogon(T4CConnection.java:1993) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:1086) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1158) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:106) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:895) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:702) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:353) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:747) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:770) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:286) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:257) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:243) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:334) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1883) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1676) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:524) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:680) at org.apache.sqoop.Sqoop.run(Sqoop.java:151) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:81) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:187) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:250) at org.apache.sqoop.Sqoop.main(Sqoop.java:259) 25/08/01 15:54:14 ERROR tool.ImportTool: Import failed: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1682) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:524) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:680) at org.apache.sqoop.Sqoop.run(Sqoop.java:151) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:81) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:187) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:250) at org.apache.sqoop.Sqoop.main(Sqoop.java:259) ... View more