My Oracle Support Banner

"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 APRIL 29, 2019

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: <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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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