Root Cause Analysis Document
Internal Ticket No | : | Q2-000847 |
External Ticket No | : | CS2220909 |
Incident Date | : | |
Report Date | : | 2020-07-09 |
Report By | : | BMI |
Event Description
When customer click on magnifying glass icon under 'Alert Details' to see transactions detail in account, the transaction details is not shown/blank.
Customer Impact
User unable to see transactions detail that triggering alert
Root Cause
Customer inform that the alert having this magnifying glass issue was generated by AML-MLB-ALL-OUT-P-D05-MBD rule. Magnifying glass will work to respective rule to show transaction detail, need to check if there's entry/data in CONFIG_RULES_TO_DRILLS and USER_RULES_TO_DRILLS tables related to the rule AML-MLB-ALL-OUT-P-D05-MBD, check from database using below query:
| SELECT * FROM SAM_APP.dbo.CONFIG_RULES_TO_DRILLS WHERE RULE_ID LIKE 'AML-MLB%' SELECT * FROM SAM_APP.dbo.USER_RULES_TO_DRILLS WHERE RULE_ID LIKE 'AML-MLB%' |
From above query, there's no record related to AML-MLB-ALL-OUT-P-D05-MBD rule.
| RULE_ID | DRILL_ID | DRILL_LEVEL_CD | IS_ACTIVE | DISPLAY_ORDER | BUSINESS_PARAM | TECHNICAL_CONFIG_PARAM |
| AML-MLB-ALL-INN-A-D05-MBD | ACT_AML_transactions_details | 2 | 1 | 1 | NULL | NULL |
| AML-MLB-ALL-INN-A-D05-MBD | ACT_AML_transactions_pinpoint | 4 | 1 | 1 | NULL | NULL |
| AML-MLB-ALL-INN-A-D05-MBD | AML_SAM_Branches | 2 | 1 | 1 | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | ACT_AML_transactions_details | 2 | 1 | 1 | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | ACT_AML_transactions_pinpoint | 4 | 1 | 1 | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | AML_SAM_Branches | 2 | 1 | 1 | NULL | NULL |
| RULE_ID | DRILL_ID | DRILL_LEVEL_CD | DRILL_LABEL | IS_ACTIVE | DISPLAY_ORDER | BUSINESS_PARAM | TECHNICAL_CONFIG_PARAM |
| AML-MLB-ALL-INN-A-D05-MBD | ACT_AML_transactions_details | 2 | NULL | NULL | NULL | NULL | NULL |
| AML-MLB-ALL-INN-A-D05-MBD | ACT_AML_transactions_pinpoint | 4 | NULL | NULL | NULL | NULL | NULL |
| AML-MLB-ALL-INN-A-D05-MBD | AML_SAM_Branches | 2 | NULL | NULL | NULL | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | ACT_AML_transactions_details | 2 | NULL | NULL | NULL | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | ACT_AML_transactions_pinpoint | 4 | NULL | NULL | NULL | NULL | NULL |
| AML-MLB-ALL-INN-P-D05-MBD | AML_SAM_Branches | 2 | NULL | NULL | NULL | NULL | NULL |
Corrective Action
The issue caused by the record in CONFIG_RULE_TO_DRILLS table for the custom rule (AML-MLB-ALL-OUT-P-D05-MBD). Below the script to insert to CONFIG_RULE_TO_DRILLS table.
| INSERT INTO CONFIG_RULES_TO_DRILLS (RULE_ID, DRILL_ID, DRILL_LEVEL_CD, IS_ACTIVE, DISPLAY_ORDER) VALUES ( 'AML-MLB-ALL-OUT-A-D05-MBD', 'ACT_AML_transactions_details', '2' , 1, 1) INSERT INTO CONFIG_RULES_TO_DRILLS (RULE_ID, DRILL_ID, DRILL_LEVEL_CD, IS_ACTIVE, DISPLAY_ORDER) VALUES ( 'AML-MLB-ALL-OUT-A-D05-MBD', 'AML_SAM_Branches', '2' , 1, 1) INSERT INTO CONFIG_RULES_TO_DRILLS (RULE_ID, DRILL_ID, DRILL_LEVEL_CD, IS_ACTIVE, DISPLAY_ORDER) VALUES ( 'AML-MLB-ALL-OUT-A-D05-MBD', 'ACT_AML_transactions_pinpoint', '4' , 1, 1) |