CS9 Bundle #30 CREATEVIEWS Script Fails on MS SQL Server
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