After generating PO suggestions and selecting New PO suggestions, we’re getting a Failed to enable constraints error.
Error Detail: Failed to enable constraints. One or more rows contain values violating non-null, unique or foreign-key constraints.
Table: SugPoDtl
Company=‘XXX’ SugNum=‘1757414’ RowIdent=‘0x00000000059740c2’. Column ‘RelQty’ does not allow DBNull Value.
I did a lookup in the table SugPoDtl. It seems that SugNum 1757414 does not exist. So, I’m not sure what is trying to reference a non existent suggestion number or how to fix/get rid of this error.
This is running on a Progress/OpenEdge database.
Any help would be appreciated…
Thanks!