CS9 Bundle #30 CREATEVIEWS Script Fails on MS SQL Server (Doc ID 1579510.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

On : CS 9 version, Campus Community Other

CS9 Bundle #30 CREATEVIEWS script fails on MS SQL Server

Installing CS9 Bundle #30 into a copy of production and the createviews SQL script fails with the following error:

ERROR
-----------------------

Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Argument data type text is invalid for argument 1 of len function.

[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180

Failed SQL stmt:CREATE VIEW PS_SCC_GE_NTFDA_VW (SCC_NTFREQ_ID, SCC_GE_DESCR) AS SELECT SCC_NTFREQ_ID ,RTRIM(SUBSTRING((CASE WHEN UNICODE(SUBSTRING(SCC_NTFREQ_DAT_VAL , LEN(SCC_NTFREQ_DAT_VAL) , (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Argument data type text is invalid for argument 1 of len function.

[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Following the Installation instructions for CS Bundle #30, run \scripts\createvw.dms

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to proceed with installation of bundle 30

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