Symptoms
Provider is trying to remove some resource from PBA-E Control Panel, however the following error is displayed:
Can not remove Resource #XXX. The Resource is used
In the logs the following error can be found:
[14-04-01 12:12:32.879 RDBMS RQ61318 NTE] Code: 1002. ODBC code #23503: ERROR: update or delete on table "BMResource" violates foreign key constraint "UsageDetail_resourceID" on table "UsageDetail
"
Key (resourceID)=(XXX) is still referenced from table "UsageDetail".;
Error while executing the query
[14-04-01 12:12:32.879 Worker1.68 RQ61318 TRC] ...[1] *** INTERRUPTED BY EXCEPTION *** ErrorMessage* BM::ResourceRemove_API(Int)
Cause
The resource in question still stored in PBA-E database. It is referenced from "Resource Service Usage Details" for some of the subscriptions.
Resolution
A feature request #PBA-55852 to provide ability to remove unused resources and other stuff has been submitted.
Currently, as a workaround please archive old orders which had Provisioning Items referring to the resource in question. All the UsageDetails will be dropped in such case.