"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 JUNE 28, 2018

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

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: 68] [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: 17] [ecid: ] inactive connection timeout timer canceled
[2018-05-04T17:09:56.796-05:00] [ucp] [NOTIFICATION] [] [oracle.ucp.common.UniversalConnectionPoolBase] [tid: 17] [ecid: ] inactive connection timeout timer canceled
[2018-05-04T17:12:54.715-05:00] [ide] [NOTIFICATION] [] [oracle.ide.ExtensionRegistry] [tid: 17] [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: 17] [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: 57] [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: 33] [userId: <anonymous>] [ecid:] [APP: oraclediagent] [partition-name:DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1519412795582][oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase:ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer][oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid:c64e7b17-c557-4a6b-9085-ba5c715e8fc1] 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: 33] [userId: <anonymous>] [ecid:] [APP: oraclediagent] [partition-name:DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1519412795582][oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase:
ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer][oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid:c64e7b17-c557-4a6b-9085-ba5c715e8fc1] 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms