My Oracle Support Banner

E1: DB: Troubleshooting Connectivity Issues with the SQL Server Database (Doc ID 1528841.1)

Last updated on JUNE 17, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
Information in this document applies to any platform.


The purpose of this document is to provide help in troubleshooting different situations when there is a connectivity problem between SQL Server database and EnterpriseOne software.

Troubleshooting Steps

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
Troubleshooting Steps
 Issue 1: Connection between iSeries and SQL Server with Central Objects
 Issue 2: Connection between JAS Server and SQL Server database
 Issue 3: Intermittent connection lost
 Issue 3A: Intermittent connection lost with Communication link failure error
 Issue 4: New install on 64 bit operating system
 SQL timeout
 Issue 5: Connection is busy with results from another command
 Issue 6: SQL Server connection problems due to incorrect default setting for updateableResultSetTimeout

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