Vantage 8.03 New PO Suggestions failed to enable constraints

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…


1 Like

Five years ago was your last post, welcome back!

Queues Aerosmith - Back in the Saddle