My Oracle Support Banner

E-SQR: Troubleshooting (SQR 1803) ERROR for MSS platform (Doc ID 652243.1)

Last updated on DECEMBER 03, 2024

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
MICROSOFT SQL SERVER SQR platform PeopleTools 8.4x

Purpose

 SQR programs run via the Process Scheduler server are receiving this error:

"(SQR 1803) CONNECT failed.  Perhaps username/password incorrect. SQR for PeopleSoft: Program Aborting."

in the ".out" file (the sqr log).  Other process types seem to be working fine like Crystal and AE and nVision.

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
 1) DBBIN Setting
 2) Verify a "Working" system ODBC
 3) Test SQRW outside of the Process Scheduler
 4) Verify the data source type of authentication
 5) PATH variable

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