Article ID: 123342, created on Oct 30, 2014, last review on Oct 30, 2014

  • Applies to:
  • Business Automation 5.5
  • Business Automation 5.4

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.

Search Words

Can not remove Resource The Resource is used

Can't delete resource

odbc

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 210d017ddc3a076d22f0f865b1cf0730

Email subscription for changes to this article
Save as PDF