"Your connection was terminated" Error Received when Testing an ODICS Microsoft SQL Server Data Server Connection to Microsoft Azure Database (Doc ID 2408290.1)

Last updated on SEPTEMBER 14, 2022

Applies to:

Symptoms

On Oracle Data Integrator Cloud Service (ODICS) 17.1.3, while testing a "Microsoft SQL Server" Data Server connection to a Microsoft SQL Server database hosted on Microsoft Azure, the following errors occur:

java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Your connection was terminated.
  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:1258)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:204)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$500(SnpsDialogTestConnet.java:62)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:402)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:398)
  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:748)
Caused by: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Your connection was terminated.
  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:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  ... 1 more

Reviewing the "Local (No Agent)" log (studio.log), the following error is reported:

[2018-05-04T17:02:17.151-05:00] [] [NOTIFICATION] [] [] [tid: <TID>] [ecid: <ECID>] New data source: [<sql_server_db_user>/*******@jdbc:weblogic:sqlserver://<microsoft_azure_servername>:1433;DatabaseName=<sql_server_database_name>;]
[2018-05-04T17:09:56.786-05:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: <TID>] [ecid: <ECID>] inactive connection timeout timer canceled
[2018-05-04T17:09:56.796-05:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: <TID>] [ecid: <ECID>] inactive connection timeout timer canceled
[2018-05-04T17:12:54.715-05:00] [ide] [NOTIFICATION] [] [oracle.ide.ExtensionRegistry] [tid: <TID>] [ecid: <ECID>] VIEW_JAVA_SUB_MENU has no label and therefore will not be added to the menu bar.
[2018-05-04T17:12:54.813-05:00] [ide] [NOTIFICATION] [] [oracle.ide.ExtensionRegistry] [tid: <TID>] [ecid: <ECID>] APPLICATION_MENU has no label and therefore will not be added to the menu bar.
[2018-05-04T17:13:08.572-05:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: <TID>] [ecid: <ECID>] inactive connection timeout timer scheduled

When trying to make the connection using the J2EE agent, a similar error is logged:

[2018-05-04T21:35:26.985+00:00] [OJCS-ODI_server_1][NOTIFICATION] [] [] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: oraclediagent] [partition-name:DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: <ID>][oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase:ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer][oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid:<GUID>] New data source:
[<sql_server_db_user>/*******@jdbc:weblogic:sqlserver://<microsoft_azure_servername>:1433;DatabaseName=<sql_server_database_name>;]
[2018-05-04T22:25:27.016+00:00] [OJCS-ODI_server_1] [ERROR][ODI-1592] [oracle.odi.agent] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: oraclediagent] [partition-name:DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: <ID>][oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase:
ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer][oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid:<GUID>] Error occurred testing connection todataserver with agent OracleDIAgent[[ODI-1592: Error occurred testing connection to dataserver with agent OracleDIAgent Caused By: oracle.odi.core.exception.OdiRuntimeException:
oracle.odi.jdbc.datasource.ConnectionTimeoutException: A login timeout occured while connecting to the database

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.