My Oracle Support Banner

EPY: CAN: TAX106CN.SQR IS FAILING ON SQL SERVER AND DB2 (Doc ID 2738057.1)

Last updated on DECEMBER 24, 2020

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

TAX106CN.sqr abends with the following error: 

SQR error:
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 174 in cursor 8:
  [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The rtrim function requires 1 argument(s).
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 11501 in cursor 8:
  [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The batch could not be analyzed because of compile errors.

Error on line 470:
  (SQR 3716) Error in SQL statement.

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
References


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