1. UNIFYBroker Forum
  2. Bugs
0
Fixed

Container Foreign Key conflict

Adam van Vliet 12 years ago • updated by anonymous 9 years ago • 4

For investigation, please try and reproduce the error from IDB-116 and IDB-400.

As discussed, try to get the delete individual partition and the delete script to be called. Run a SQL trace to ensure that the correct calls are being made.

Tony Sheehy 12 years ago

The Clear.sql file doesn't readd the FK_Container_Container constraint back correctly (misses out on the Delete/Update cascade), which means that the assumptions made by the delete calls to adapters/connector are incorrect.

Tony Sheehy 12 years ago

Reassigned for confirmation of completion.

Matthew Clark 12 years ago

Confirm by

  1. Adding only one connector
  2. Delete the connector
  3. Add a new connector and two adapters, with one adapter containing a container
  4. Delete the adapter with the container
Matthew Clark 12 years ago

Following the above steps, I could delete the adapter with the container with no issues. Closed.

Customer support service by UserEcho