Get a sequence of errors when submitting a case in Support Self Service

(Doc ID 622377.1)

Last updated on FEBRUARY 13, 2018

Applies to:

PeopleSoft Enterprise CRM Support - Customer Self Service - Version 8.8 and later
PeopleSoft Enterprise CRM HelpDesk - Employee Self Service - Version 8.9 and later
PeopleSoft Enterprise CRM Support - Version 9.1 and later
PeopleSoft Enterprise CRM HelpDesk - Version 9.2 and later
Information in this document applies to any platform.
PeopleSoft Enterprise CRM HelpDesk - Employee Self Service - Version: 8.8 - Release: 8.8

PeopleSoft Enterprise CRM Support - Version: 8.8 - Release: 8.8

PeopleSoft Enterprise CRM Support - Customer Self Service - Version: 8.8 - Release: 8.8


Information in this document applies to any platform.



SPECIFIC TO:   Enterprise, CRM 8.8SP1



This document was previously published as Customer Connection Solution 200766637

Symptoms



When Submitting a Case via Self-Service, the user gets following sequence of errors and the case cannot be saved(User used is  SUP636)
1)
SQL error.Stmt #:1450 Error Position: 0 Return:8602 - [Microsoft][ODBC SQL Server Driver]]SQL Server]
Incorrect syntax near keyword 'WHERE'
Microsoft][ODBC SQL Server Driver]]SQL Server]Statement(s) could not be prepared.(SQLSTATE 37000)8180
Click 'OK'
2)
UPDATE PS_RF_ASSIGN_SCH SET update_field='Y', WHERE setid = 'CRM01' AND provider_grp_id = 'APLW' AND dayofweek = 1 AND time_start = '00:01:00.000' AND time_to = '23:59:00' AND update_field <> 'Y'
Click 'OK'
3)
Process 0 ABENDED at Step RF_ASGN_ENG.54TwoSch.UpdDay (SQL) -- RC = 8602 (108,524)
Click 'OK'
4)
CallAppEngine: Application RF_ASGN_ENG: AppEngine error. (2,653) At
FUNCLIB_RF.SEARCH_GRP_MEM.FieldFormula RunAssignmentCase PCPC:7055 Statement: 91
During a CallAppEngine builtin function call, the Application Engine detected an error.
The Application Engine log may provide more information

Changes

 

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