My Oracle Support Banner

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

Last updated on JUNE 07, 2024

Applies to:

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




Purpose

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
Purpose
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
References

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