Error "Failed constraint check" When Validating MASTER_REPL_ATTR
(Doc ID 2710486.1)
Last updated on MAY 16, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
When validating a MASTER_REPL_ATTR.dat file, an error appear, but the file has the correct data.
ERROR
-----------------------
Failed constraint check: (((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or REJECT_STORE_ORD_IND IS NULL) ) OR (REJECT_STORE_ORD_IND IS NULL OR ((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or REJECT_STORE_ORD_IND IS NULL) )
Steps to replicate:
1) Build conversion file for MASTER_REPL_ATTR
2) Use REPL_METHOD as 'W' and REJECT_STORE_ORD_IND as NULL
3) Import the file in data conversion tool
4) Preform data validation with tool, fails with error:
Failed constraint check: (((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in
('SO')) or REJECT_STORE_ORD_IND IS NULL) ) OR (REJECT_STORE_ORD_IND IS NULL
OR ((REJECT_STORE_ORD_IND in ('Y','N') and REPL_METHOD in ('SO')) or
REJECT_STORE_ORD_IND IS NULL) )
Changes
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 |