MICC error Foreign Key Constraints

Source

 

Problem: tblConfig_AgentGroupMembers : ForeignKeyConstraint tblConfig_AgentGroup_tblConfig_AgentGroupMembers_fk_constraint requires the child key values (d5dac6e3-f237-40bc-806b-2d9d4713c066) to exist in the parent table.

select * from tblConfig_AgentGroupMembers where FKAgentGroup like ‘d5dac6e3-f237-40bc-806b-2d9d4713c066’

Problem: Error: 2018-Jun-13 16:29:29.376   Synchronization failed – System.Data.ConstraintException: tblConfig_QueueAgentGroupMembers : ForeignKeyConstraint tblConfig_Queue_tblConfig_QueueAgentGroupMembers_fk_constraint requires the child key values (c3ca877f-85ca-41be-b3bc-bef09140752b) to exist in the parent table.

statement to find it: select * from tblConfig_QueueAgentGroupMembers where FKQueue like ‘c3ca877f-85ca-41be-b3bc-bef09140752b’

To remove change remove select * and replace with del

Leave a Reply