Ansicht
Dokumentation

SQL0603 - Unique index cannot be created because of duplicate keys. ( OS/400 )

SQL0603 - Unique index cannot be created because of duplicate keys. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   Vendor Master (General Section)  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0603
Unique index cannot be created because of duplicate keys.

Message Long Text :

Cause . . . . . : An attempt was made to create unique index &1 in &2 or add unique constraint &1 in &2. The operation cannot be performed because the rows in table &3 in &4 contain one or more duplicate values in the columns used to create the index.
Recovery . . . : Do one of the following and try the request again:
-- Remove the UNIQUE attribute from the CREATE INDEX statement.
-- Remove the UNIQUE constraint from the ALTER TABLE statement.
-- Change the data in the related table so that all key values are unique.
-- Specify UNIQUE WHERE NOT NULL on the CREATE INDEX statement if the duplicate keys contain nulls. The uniqueness restriction would not apply when the key value contains nulls.
For information on what rows contain the duplicate key values, see the previously listed messages in the job log.

Message File : QSQLMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.

Length: 3249 Date: 20240329 Time: 082602     sap01-206 ( 3 ms )