Troubleshooting Scenarios

Run the following script for the RCM/FMEA equipment, recommendation, and the RCM/FMEA recommendation families. This improves the loading performance of the Reliability Centered Maintenance page.

CREATE NONCLUSTERED INDEX [<N_MI_RCMEQPMT_ID_NK>]
ON [dbo].[MI_RCMEQPMT] ([MI_RCMEQPMT_EQUIP_ID_C])
INCLUDE ([ENTY_KEY])

CREATE NONCLUSTERED INDEX [<N_MI_REC_ANALY_KEY_FK>]
ON [dbo].[MI_REC] ([MI_REC_ANALY_KEY_NBR])
INCLUDE ([ENTY_KEY])

CREATE NONCLUSTERED INDEX [<N_MI_RECRCM_ACTIO_TYPE_FK>]
ON [dbo].[MI_RECRCM] ([MI_RECRCM_ACTIO_TYPE_C])
INCLUDE ([ENTY_KEY])

1. Do not have same Failure effect or Failure mode or Recommendation or Secondary action names.
2. If you cannot implement the first option, then the column Related Asset ID must be added in the Failure Mode, Failure Effect, Recommendations, and Secondary action sheet.

1. In the Applications menu, navigate toTools > Operations Manager > Risk Matrix. If the current default risk matrix differs from the one returned in the following query for that analysis, then you will not be able to promote to ASM. The risk assessment should be same as mentioned in the query to mitigate an action in ASM.
2. Run the following query for the analysis to know which Risk Matrix is being used when promoting to ASM:

   SELECT [MI_RCMFMODE].[MI_RCMFMODE_NAME_C] "Failure Mode Name"
   , [MI_RCMFMODE].[MI_RCMFMODE_REL_ASSET_ID_C] "Mode Name Asset ID"
   , [MI_RECRCM].[MI_REC_ID] "Recommendation ID"
   , MI_ENTITIES.ENTY_ID "Recommendation Asset"
   , [MI_RISKASSE].[MI_RISKASSE_RM_NAME_C] "Risk Matrix Name"
   FROM [MI_RCMANALY]
   JOIN_SUCC [MI_RCMFUNCN]
   JOIN_SUCC [MI_RCMFFAIL]
   JOIN_SUCC [MI_RCMFMODE]
   JOIN_SUCC [MI_RCMFEFFT]
   JOIN_SUCC [MI_RECRCM] LEFT
   JOIN_SUCC [MI_RISKASSE] ON {MIR_MITRISK} ON {MIR_HRCMREC} ON {MIR_HRCMFEF} ON {MIR_HRCMFMD} ON {MIR_HRCMFFL} ON {MIR_HRCMFNC}
   JOIN {MI Has Recommendations} ON [MI_RECRCM].ENTY_KEY = {MI Has Recommendations}.SUCC_ENTY_KEY
   JOIN MI_ENTITIES ON MI_ENTITIES.ENTY_KEY = {MI Has Recommendations}.PRED_ENTY_KEY
   WHERE [MI_RCMANALY].ENTY_KEY = (? :n :id=AnalysisKey)
   

3. If the current risk matrix is marked as Default, then change the risk matrix to the previous matrix and then mark as Default.