UPD898732_47.dms Script from CS 9 Bundle #31 Fails on MS SQL Server Database (Doc ID 1596123.1)

Last updated on NOVEMBER 08, 2016

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.

Symptoms

CS 9.0 Bundle 31 dms script upd898732_47.dms errors in MS SQL Server environments.

 

Error Message:
"Database: HSDMO (ENG) SQL Successful - UPDATE PS_SSR_RS_RQSUBTYP SET EFFDT= (SELECT MIN(EFFDT) FROM PS_SSR_RS_REQSTTYP WHERE INSTITUTION = INSTITUTION AND SSR_RS_RQUEST_TYPE= SSR_RS_RQUEST_TYPE ) WHERE EFFDT NOT IN ( SELECT EFFDT FROM PS_SSR_RS_REQSTTYP WHERE INSTITUTION = INSTITUTION AND SSR_RS_RQUEST_TYPE= SSR_RS_RQUEST_TYPE )


SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]'CONCAT' is not a recognized built-in function name.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180


UPDATE PS_SSR_RS_THESIS SET SSR_RS_THESIS_TITL = concat(concat( '<p>' , SSR_RS_THESIS_TITL) , '</p>' ) WHERE SSR_RS_THESIS_TITL <> ' ' and SSR_RS_THESIS_TITL not like '<p>%'

Error: SQL execute error for UPDATE PS_SSR_RS_THESIS SET SSR_RS_THESIS_TITL = concat(concat( '<p>' , SSR_RS_THESIS_TITL) , '</p>' ) WHERE SSR_RS_THESIS_TITL <> ' ' and SSR_RS_THESIS_TITL not like '<p>%'

Ended: Mon Oct 28 15:29:03 2013
Unsuccessful completion

Attached error log file.
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Attempt to execute this script in a MS SQL Server environment.

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