Why can't I delete a resource?

book

Article ID: 39893

calendar_today

Updated On:

Products

OBLICORE GUARANTEE

Issue/Introduction

Question: 

Why can't I delete a resource?

Environment:  

BSI 8.3 and 8.3.5 on any environment.

Answer: 

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>

ecm1.jpg

 

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

 

<Please see attached file for image>

ecm2.jpg

 

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>

ecm3.jpg

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.

Environment

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

Attachments

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