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.

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.

Reassigned for confirmation of completion.

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

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