FDMEE Data Rule Status Change

Issue: 
FDMEE Data Rule does not show Completed status . The data rule hangs in the running state forever.
Checking the ODI operator or process details reveals that the rule was successfully completed.

Tried updating many tables in the Oracle DB: AIF_PROCESSES and AIF_PROCESS_DETAILS but this does not contain data for Data Rule Summary Page.
Finally found that AIF_BALANCE_RULES table impacts the Data Rule Summary page.

To fix this:

• Connect to the Database . 
• Connect to the FDMEE Schema
• Update the  particular field using below query 

SELECT PROCESS_ID FROM  AIF_BALANCE_RULES WHERE STATUS='RUNNING';

• Note the process_id and update the status

UPDATE "HYP_FDMEE"."AIF_BALANCE_RULES" SET STATUS = 'SUCCESS' WHERE PROCESS_ID = '<PROCESS_ID>'

 

The link that really helped me solve this - https://community.oracle.com/thread/3891226 

This provides alternative solutions to this issue.