Shailesh Lahariya created SQOOP-3314: ----------------------------------------
Summary: Sqoop doesn't display full log on console Key: SQOOP-3314 URL: https://issues.apache.org/jira/browse/SQOOP-3314 Project: Sqoop Issue Type: Bug Reporter: Shailesh Lahariya I am running a sqoop command (using sqoop 1.4.7) and getting an error. I cant see full error, it seems some of the useful information is not being displayed on console, for ex. instead of ...19 more in the log below, it should be given the complete message to help debug the issue. 18/04/17 01:59:12 WARN tool.EvalSqlTool: SQL exception executing statement: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691) 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:329) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59) at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:64) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:523) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:521) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518) ... 14 more Caused by: oracle.net.ns.NetException: The method specified in wallet_location is not supported. Location: /home/hadoop/wallet/jnetadmin_c at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:487) at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:143) at oracle.net.nt.ConnOption.connect(ConnOption.java:161) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470) ... 19 more Also, sharing the command that is producing the above error (altered it to remove any confidential info)- sqoop eval -D mapred.map.child.java.opts='-Doracle.net.tns_admin=. -Doracle.net.wallet_location=.' -files /home/hadoop/wallet/jnetadmin_c/ewallet.jks,/home/hadoop/wallet/jnetadmin_c/ewallet.jks,$HOME/wallet/sqlnet.ora,$HOME/wallet/tnsnames.ora --username xx --password xx --connect "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xx)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=xx)))" --query "select 1 from dual" --verbose --throw-on-error Please let me know if there is any option to get more log than it is producing currently. -- This message was sent by Atlassian JIRA (v7.6.3#76005)