Error running UPD915103_17.DMS when applying CS 9 Bundle 36 in SQL Server Environment (Doc ID 1964148.1)

Last updated on APRIL 13, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to apply CS 9 Bundle 36, the following error occurs when running upd915103_17.dms

ERROR
-----------------------
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not
UPDATE PS_SSR_IAM_ASGNEXT A SET A.SSR_ACT_ID_ROOTXRF = (SELECT (X.SSR_ACT_ID_ROOT) FROM PS_SSR_IAM X WHERE X.EMPLID = A.EMPLID AND X.INSTITUTION = A.INSTITUTION AND X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND X.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND X.SSR_ACT_ID_ROOT <> ' ') WHERE A.SSR_ACT_ID_ROOTXRF = ' ' AND A.SSR_ACTIVITY_ID IN (SELECT (Z.SSR_ACTIVITY_ID) FROM PS_SSR_IAM Z WHERE Z.EMPLID = A.EMPLID AND Z.INSTITUTION = A.INSTITUTION AND Z.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND Z.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND Z.SSR_ACT_ID_ROOT <> ' ')
Error: SQL execute error for UPDATE PS_SSR_IAM_ASGNEXT A SET A.SSR_ACT_ID_ROOTXRF = (SELECT (X.SSR_ACT_ID_ROOT) FROM PS_SSR_IAM X WHERE X.EMPLID = A.EMPLID AND X.INSTITUTION = A.INSTITUTION AND X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND X.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND X.SSR_ACT_ID_ROOT <> ' ') WHERE A.SSR_ACT_ID_ROOTXRF = ' ' AND A.SSR_ACTIVITY_ID IN (SELECT (Z.SSR_ACTIVITY_ID) FROM PS_SSR_IAM Z WHERE Z.EMPLID = A.EMPLID AND Z.INSTITUTION = A.INSTITUTION AND Z.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND Z.SSR_ACT_ID_SEQ_NBR = A.SSR_ACT_ID_SEQ_NBR AND Z.SSR_ACT_ID_ROOT <> ' ')
Ended: Thu Jan 22 23:04:26 2015
Unsuccessful completion



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Find and open upd915103_17.dms delivered in the Bundle

2. Copy the first 'Update' statement and run it stand-alone in an SQL Tool

WHAT IS WORKING
------------------------
Some SQL's within the script are executed successfully before the problem occurs. Also, this problem will not occur except in an SQL Server Environment

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users will see the Bundle installation halted.

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