Unable to create Business Process Rules after purging repositories associated with Business Process Rules (BPR).
Article ID: KB0084409
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | - |
| Not Applicable | - |
Description
Description:
This issue occurs when Repositories associated with BPR are purged before deleting BPRs. While accessing Business Process Rules, RUL-4510 error thrown on MDM UI. Snapshot attached (Filename: devError.png)..
Symptoms:
If BPR is created using the default template, when clicking on Default in Business Processes --> Record Delete Approval or any BPR created, an error page is displayed showing the following error.
RUL-4510: Failed to retrieve a rule. for user 34508, organization 34009, business process rule Process Definition Selection, template name Default. CAT-1233: Repository 34782 not found, may have been deleted.
Cause:
When clicking on Default, MDM is failing to retrieve the rule associated with the repository as the repository is already purged and repository references are not available in the database.
Resolution
Remove references to the purged repositories from RULETEXTDATA, RULEINTEGERDATA and in some cases from RULESTRINGDATA tables. With reference to the error shown above, remove references to the repository with the ID 34782 from these tables. Execute the following queries in the given sequence.
1). Delete from RULETEXTDATA where value=<repository_name> . If you do not know the name of the purged repository then execute the following alternative query.
delete from RULETEXTDATA where ID=(select T.ID from RULETEXTDATA T, RULEINTEGERDATA I where T.ID=I.ID and I.value=34782 )
2). Delete from RULEINTEGERDATA where value=34782 .
3). Delete from RULESTRINGDATA where RULEMODELINSTANCEID=34782 .
After execution of these queries, if the error is shown with a different repository ID, execute these queries by changing the repository ID with the one shown on error page.
Issue/Introduction
Unable to create Business Process Rules after purging repositories associated with Business Process Rules (BPR).
Additional Information
SR 667376
Feedback
Yes
No
Powered by
