CA_BI_INTFC Abended at Step CA_BI_INTFC.MAIN.EMAILCK (SQL) -- RC = 8601 (108,524) (Doc ID 2056931.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Interface

When attempting to CA_BI_INTFC in an environment that uses MS SQL Server database

the following error occurs.

ERROR
-----------------------
File: e:\pt85413c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'TMP'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: DELETE FROM PS_CA_EMAIL_TMP TMP WHERE TMP.PROCESS_INSTANCE = 2532058 AND NOT EXISTS( SELECT 'X' FROM PS_CA_EMAIL_CONTR EML WHERE TMP.CONTRACT_NUM = EML.CONTRACT_NUM AND TMP.CA_COMP_NAME = EML.CA_COMP_NAME AND EML.CA_COMP_NAME = 'BP')
2015-08-19-12.37.12.000092 GetNextStateRecord [68] Exception logged: RC=3.
2015-08-19-12.37.12.000092 ExecuteSql [1335] Exception logged: RC=8.
2015-08-19-12.37.12.000092 ExecuteSql [1454] Exception logged: RC=8.
2015-08-19-12.37.12.000092 DoSqlAction [2544] Exception logged: RC=8.
2015-08-19-12.37.12.000092 DoSqlAction [2592] Exception logged: RC=8.
2015-08-19-12.37.12.000093 DoStepActions [2013] Exception logged: RC=8.

Process 2532058 ABENDED at Step CA_BI_INTFC.MAIN.EmailCK (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
2015-08-19-12.37.12.000225 DoMessageLogError [1109] Exception logged: RC=3.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run CA_BI_INTFC


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms