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.
Following the above steps, I could delete the adapter with the container with no issues. Closed.
Customer support service by UserEcho