[
https://issues.apache.org/jira/browse/SQOOP-3314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16440999#comment-16440999
]
Daniel Voros commented on SQOOP-3314:
-------------------------------------
Hi [~shailu.lahar], thank you for reporting this!
The {{... 19 more}} part is refering to the previous lines above, it's not
truncated. I'm afraid the {{--verbose}} is your best bet. The "method specified
in wallet_location is not supported" message suggests you have misconfigured
your Oracle wallet. Could you please confirm if it's working outside of Sqoop?
> 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
> Priority: Major
>
> 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)
