My Oracle Support Banner

Error while creating Index for Record PS_DATA_C_AUDIT (Doc ID 2498128.1)

Last updated on FEBRUARY 05, 2019

Applies to:

PeopleSoft Enterprise FIN Purchasing Argentina - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms


System throwing the error while applying bundle "LOCAL ARA - SCM 9.1 BUNDLE #13"

Steps to Reproduce Issue :

Run the below script in MS SQL Server 2016

SET IMPLICIT_TRANSACTIONS ON
SET ARITHABORT ON
CREATE UNIQUE CLUSTERED INDEX PS_DATA_C_AUDIT ON PS_DATA_C_AUDIT
(MSSCONCATCOL)
Msg 1944, Level 16, State 1, Server DESABDERP, Line 1
Index 'PS_DATA_C_AUDIT' was not created because the index key size is at least 996 bytes. The clustered index key size cannot exceed 900 bytes. If the index key includes implicit key columns, the index key size cannot exceed 2600 bytes.

 

Changes

 Not Applicable

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
References


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