Error while creating Index for Record PS_DATA_C_AUDIT
(Doc ID 2498128.1)
Last updated on OCTOBER 01, 2020
Applies to:PeopleSoft Enterprise FIN Purchasing Argentina - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
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
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.
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