1 Reply Latest reply on Dec 15, 2019 6:40 AM by Saurabh Verma-Oracle

    Password must not be null error with Standalone Agent - NetSuite JDBC

    Saurabh Verma-Oracle

      I have a custom technology in ODI to connect to netsuite via jdbc and am getting Password must not be null error while trying to test connection with the standalone agent. The connection works fine with the local(noagent) option and the password entered in ODI is correct.

       

      I have regenerated the DemoIdentity.jks and  DemoTrust.jks using the steps in Doc ID 1392455.1 and copied them to the following locations

      C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\security\DemoIdentity.jks

      C:\Program Files\Java\jdk1.8.0_221\jre\lib\security\DemoIdentity.jks

      C:\Oracle\Middleware\Oracle_Home\wlserver\server\lib\DemoTrust.jks

       

      I have also looked at instance.cmd entry below and the variables WL_HOME and DOMAIN_HOME are defined as system variables.

      if defined IS_AGENT_SCRIPT (

       

              set ODI_SSL_PROPERTIES=-Djavax.net.ssl.trustStore=%WL_HOME%/server/lib/DemoTrust.jks -Djavax.net.ssl.keyStore=%DOMAIN_HOME%/security/DemoIdentity.jks

      ) else (

             set ODI_SSL_PROPERTIES=-Djavax.net.ssl.trustStore=%WL_HOME%/server/lib/DemoTrust.jks -Djavax.net.ssl.trustStorePassword=DemoTrustKeyStorePassPhrase

      )

       

      Please advise what might be going wrong. I have tried several combinations with no progress. I had this setup working on another machine earlier so it has been configured to work earlier.

       

      The full stack of the error is below

       

      Caused by: java.sql.SQLNonTransientConnectionException: Internal network error, connection closed.

              at com.netsuite.jdbc.oabase.oaa0.b(Unknown Source)

              at com.netsuite.jdbc.oabase.oaa0.a(Unknown Source)

              at com.netsuite.jdbc.oabase.oaa_.b(Unknown Source)

              at com.netsuite.jdbc.oabase.oaa_.a(Unknown Source)

              at com.netsuite.openaccess.ssp.oaax.a(Unknown Source)

              at com.netsuite.openaccess.ssp.oaa6.a(Unknown Source)

              at com.netsuite.openaccess.ctxt.conn.oaa.p(Unknown Source)

              at com.netsuite.openaccess.ctxt.conn.oaa.a(Unknown Source)

              at com.netsuite.jdbc.openaccess.OpenAccessImplConnection.open(Unknown Source)

              at com.netsuite.jdbc.oabase.BaseConnection.f(Unknown Source)

              at com.netsuite.jdbc.oabase.BaseConnection.b(Unknown Source)

              at com.netsuite.jdbc.oabase.BaseConnection.a(Unknown Source)

              at com.netsuite.jdbc.oabase.BaseDriver.connect(Unknown Source)

              at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:419)

              at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:392)

              at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:355)

              at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:334)

              at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)

              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)

              ... 1 more

      Caused by: com.netsuite.openaccess.net.oar: Internal network error, connection closed.

      com.netsuite.openaccess.net.oar: Session aborted due to network problems.

      com.netsuite.openaccess.net.oar: Error establishing socket to host and port: tstdrv2132139.connect.api.netsuite.com:1708. Reason: Password must not be null

              at com.netsuite.openaccess.net.oao.b(Unknown Source)

              at com.netsuite.openaccess.net.oaak.a(Unknown Source)

              at com.netsuite.openaccess.net.oaak.b(Unknown Source)

              at com.netsuite.openaccess.net.oaak.c(Unknown Source)

              at com.netsuite.openaccess.net.oaak.a(Unknown Source)

              ... 18 more