G
Ganesh G
Guest
Hi, I downloaded Salesforce drivers for ODI and I was able to load drivers. However, I'm getting the error while testing the connection. 2016-10-28 00:08:59.392 NOTIFICATION VIEW_JAVA_SUB_MENU has no label and therefore will not be added to the menu bar. 2016-10-28 00:08:59.556 NOTIFICATION APPLICATION_MENU has no label and therefore will not be added to the menu bar. 2016-10-28 00:10:26.732 NOTIFICATION New data source: [ODI_M/*******@jdbc
racle:thin
localhost:1521/xe] 2016-10-28 00:10:27.579 NOTIFICATION inactive connection timeout timer scheduled 2016-10-28 00:10:32.068 NOTIFICATION New data source: [ODI_W/*******@jdbcracle:thinlocalhost:1521/xe] 2016-10-28 00:10:32.074 NOTIFICATION inactive connection timeout timer scheduled 2016-10-28 00:10:35.444 NOTIFICATION Created OdiInstance instance id=1 2016-10-28 00:10:35.540 WARNING Refreshing static component type cache. 2016-10-28 00:10:35.546 NOTIFICATION Successfully set the current thread authentication 2016-10-28 00:10:39.284 NOTIFICATION Cannot find AgentETLHelper. 2016-10-28 00:10:39.384 NOTIFICATION Loading PIG custom KMs is not needed. 2016-10-28 00:10:39.387 NOTIFICATION Loading SPARK_PYTHON custom KMs is not needed. 2016-10-28 00:10:39.814 NOTIFICATION Successfully set the current thread authentication 2016-10-28 00:11:54.775 NOTIFICATION New data source: [integration.user@altayer.com.dev/*******@jdbc:datadirect:sforce://test.salesforce.com;User=integration.user@altayer.com.dev;Password=Altayer#00spYj33W19SU2QhCCgejfiqb6F] 2016-10-28 00:12:15.645 NOTIFICATION findProxyForURL( http://www.internic.net) returns null. 2016-10-28 00:12:15.666 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:17.090 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:18.441 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:19.735 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:21.065 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:22.316 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. ******************************************************************************************************************** Creating context popup menu for the node:Salesforce.com OdiNavTreeNode:Salesforce.com Associate method 'ImportFromXmlPSchema' to a SnpsPopupActionHandler or a derivated type Associate method 'edit' to a SnpsPopupActionHandler or a derivated type Associate method 'consult' to a SnpsPopupActionHandler or a derivated type Associate method 'insert' to a SnpsPopupActionHandler or a derivated type Associate method 'duplicate' to a SnpsPopupActionHandler or a derivated type Associate method 'delete' to a SnpsPopupActionHandler or a derivated type Associate method 'ImportFromXmlConnect' to a SnpsPopupActionHandler or a derivated type ******************************************************** java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:203) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1100(SnpsDialogTestConnet.java:62) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:400) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:396) at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258) at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.sql.SQLNonTransientConnectionException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at com.ddtek.jdbc.sforcebase.ddcn.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcn.a(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforce.SForceImplConnection.c(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.b(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.m(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.e(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.a(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseDriver.connect(Unknown Source) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331) ... 6 more Can you help. Thanks, Ganesh
Continue reading...
racle:thinlocalhost:1521/xe] 2016-10-28 00:10:27.579 NOTIFICATION inactive connection timeout timer scheduled 2016-10-28 00:10:32.068 NOTIFICATION New data source: [ODI_W/*******@jdbcracle:thinlocalhost:1521/xe] 2016-10-28 00:10:32.074 NOTIFICATION inactive connection timeout timer scheduled 2016-10-28 00:10:35.444 NOTIFICATION Created OdiInstance instance id=1 2016-10-28 00:10:35.540 WARNING Refreshing static component type cache. 2016-10-28 00:10:35.546 NOTIFICATION Successfully set the current thread authentication 2016-10-28 00:10:39.284 NOTIFICATION Cannot find AgentETLHelper. 2016-10-28 00:10:39.384 NOTIFICATION Loading PIG custom KMs is not needed. 2016-10-28 00:10:39.387 NOTIFICATION Loading SPARK_PYTHON custom KMs is not needed. 2016-10-28 00:10:39.814 NOTIFICATION Successfully set the current thread authentication 2016-10-28 00:11:54.775 NOTIFICATION New data source: [integration.user@altayer.com.dev/*******@jdbc:datadirect:sforce://test.salesforce.com;User=integration.user@altayer.com.dev;Password=Altayer#00spYj33W19SU2QhCCgejfiqb6F] 2016-10-28 00:12:15.645 NOTIFICATION findProxyForURL( http://www.internic.net) returns null. 2016-10-28 00:12:15.666 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:17.090 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:18.441 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:19.735 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:21.065 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. 2016-10-28 00:12:22.316 NOTIFICATION findProxyForURL( test.salesforce.com/.../34.0) returns null. ******************************************************************************************************************** Creating context popup menu for the node:Salesforce.com OdiNavTreeNode:Salesforce.com Associate method 'ImportFromXmlPSchema' to a SnpsPopupActionHandler or a derivated type Associate method 'edit' to a SnpsPopupActionHandler or a derivated type Associate method 'consult' to a SnpsPopupActionHandler or a derivated type Associate method 'insert' to a SnpsPopupActionHandler or a derivated type Associate method 'duplicate' to a SnpsPopupActionHandler or a derivated type Associate method 'delete' to a SnpsPopupActionHandler or a derivated type Associate method 'ImportFromXmlConnect' to a SnpsPopupActionHandler or a derivated type ******************************************************** java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:203) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1100(SnpsDialogTestConnet.java:62) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:400) at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:396) at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258) at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144) at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73) at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ... 1 more Caused by: java.sql.SQLNonTransientConnectionException: [DataDirect][SForce JDBC Driver][SForce]java.lang.NullPointerException: NullPointerException invoking test.salesforce.com/.../34.0: null at com.ddtek.jdbc.sforcebase.ddcn.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcn.a(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.b(Unknown Source) at com.ddtek.jdbc.sforcebase.ddcm.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforcecloud.ddd.a(Unknown Source) at com.ddtek.jdbc.sforce.SForceImplConnection.c(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.b(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.m(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.e(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseConnection.a(Unknown Source) at com.ddtek.jdbc.sforcebase.BaseDriver.connect(Unknown Source) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352) at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331) ... 6 more Can you help. Thanks, GaneshContinue reading...