My Oracle Support Banner

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

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

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