Why can't I delete a resource?
search cancel

Why can't I delete a resource?


Article ID: 39893


Updated On:


CA Business Service Insight



Why can't I delete a resource?


BSI 8.3 and 8.3.5 on any environment.


Resources can only be deleted when they are first created and before they are used. If a resource is in use then it cannot be deleted because it's being referenced by the other objects in the database. However, even if it is no longer used, you cannot delete a resource which was used in the past because there are too many places in the database where it may be referenced by old versions of contracts and other objects. In the past this has caused too many problems. The recommended method to deal with this is to flag that resource as "not effective". This can keep it from appearing in a list of effective resources and basically removes it from having to be dealt with but without actually removing it. An example of this is below:

You go to DESIGN -> RESOURCES -> RESOURCES and edit:


<Please see attached file for image>



 Then you click edit on the effective date of the resource:


<Please see attached file for image>



Then you set the resource to no longer be effective for those dates. If you have other dates and you don't want it effective for those, edit them as well.


<Please see attached file for image>


While this is the recommended and supported method. In an emergency you may delete a resource directly from the database. However this WILL corrupt your database if the resource is still in use and if this is needed then it's recommended that you backup your database first and then contact support for assistance.


Release: GATBIL05900-8.3-Business Service Insight-Business Intelligence Layer-(RDL)


1558719575240000039893_sktwi1f5rjvs16vdl.jpeg get_app
1558719573544000039893_sktwi1f5rjvs16vdk.jpeg get_app
1558719571578000039893_sktwi1f5rjvs16vdj.jpeg get_app