Hi Yapas,

We dont have the PAL reading as its coming from runtime, here the alert details,

2016-09-27 13:26:49,053 GMT*6*PEGA0042*4119*500*31e5ff525dcb9f716f644b9c172118ef*H190F956AB35B5F744157C84299CB4E93*l-betz*Ford-FW-OWS-Work*FordOWSOneApp:01.01.04*e982e566781e3cb4d926359e49d82df2*N*142*9249*TP_http : 21583*@undefined!TABTHREAD1*com.pega.pegarules.data.internal.access.DatabaseImpl*www.warrantyprocessing.dealerconnection.com| Proprietary information hidden*Activity=ReloadSection*Rule-Obj-Activity:ReloadSection*SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 29 Circum: 0*183:doActivity Rule-Obj-Activity:GetClaimStatusReport;184:RULE-OBJ-ACTIVITY FORD-FW-OWS-INT-API- GETCLAIMSTATUSREPORT #20151125T113047.783 GMT Step: 1 Circum: 0;185:Page-New;186:RULE-OBJ-ACTIVITY FORD-FW-OWS-INT-API- GETCLAIMSTATUSREPORT #20151125T113047.783 GMT Step: 2 Circum: 0;187:Page-New;188:RULE-OBJ-ACTIVITY FORD-FW-OWS-INT-API- GETCLAIMSTATUSREPORT #20151125T113047.783 GMT Step: 3 Circum: 0;189:Call GetClaimStatusReport;190:doActivity Rule-Obj-Activity:GetClaimStatusReport;191:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 1 Circum: 0;192:Page-New;193:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 2 Circum: 0;194:Property-Set;195:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 3 Circum: 0;196:Property-Set;197:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 3 Circum: 0;198:Property-Set;199:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 3 Circum: 0;200:Property-Set;201:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 3 Circum: 0;202:Property-Set;203:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 4 Circum: 0;204:Property-Set;205:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 5 Circum: 0;206:Preconditions;207:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 6 Circum: 0;208:Preconditions;209:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 7 Circum: 0;210:Preconditions;211:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 8 Circum: 0;212:Preconditions;213:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 9 Circum: 0;214:Preconditions;215:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 10 Circum: 0;216:Preconditions;217:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 11 Circum: 0;218:Preconditions;219:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 12 Circum: 0;220:Preconditions;221:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 13 Circum: 0;222:Preconditions;223:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 14 Circum: 0;224:Preconditions;225:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 15 Circum: 0;226:Preconditions;227:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 16 Circum: 0;228:Preconditions;229:Property-Set;230:Transitions;231:RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 29 Circum: 0;232:RDB-List;*pxRunOtherRuleCount=2;pxOtherCount=1;pxInteractions=1;pxRuleCount=2;pxOtherIOElapsed=0.01;pxTotalReqTime=4.16;pxRunWhenCount=7;pxActivityCount=8;pxRDBRowWithoutStreamCount=1;pxConnectElapsed=4.14;pxOtherIOCount=1;pxRDBWithStreamCount=1;pxJavaStepElapsed=0.00;pxTotalReqCPU=0.01;pxDBInputBytes=18,309;pxInputBytes=2,238;pxRulesUsed=183;pxConnectCount=3;pxRDBWithoutStreamCount=1;pxRDBRowWithStreamCount=4;pxJavaStepCount=10;pxAlertCount=1;pxRuleFromCacheCount=2;pxRulesExecuted=17;pxOtherFromCacheCount=2;*Shared-Int-API-*DataPage*NA*NA*RDB-List;RULE-OBJ-ACTIVITY SHARED-INT-API- GETCLAIMSTATUSREPORT #20151228T071248.424 GMT Step: 29 Circum: 0;doActivity Rule-Obj-Activity:GetClaimStatusReport;Call GetClaimStatusReport;RULE-OBJ-ACTIVITY FORD-FW-OWS-INT-API- GETCLAIMSTATUSREPORT #20151125T113047.783 GMT Step: 3 Circum: 0;8 additional frames in stack;*Response=RODetails;DealerCode=00088;SubDealerCode=;ToDate=;RepairOrderNumber=564464;ClaimStatus=06;pyForEachCount=4;AreaOfResponsibility=NA;pyTempPlaceHolder=TempPlaceHolder;Country=USA;FromDate=;RepairOrderOpenDate=;VIN=;*Packaging of database query took more than threshold of 500 ms: 4,119 ms SQL: WITH CTE_DATE AS ( SELECT GETDATE() AS CURR_DATE ) SELECT     R05W.owsr05_dms_svc_agt_pa_c  AS DealerCode ,             R05W.owsr05_dms_svc_agt_sub_c AS SubDealerCode ,             R05W.owsr05_aor_c             AS AOR ,             R05W.owsr05_geo_sls_c         AS Cntry ,             R05W.owsr05_full_vin_r        AS VIN ,             R05W.owsr05_repair_vst_k      AS RepairVisitKey ,             R05W.owsr05_repair_ord_r      AS RepairOrderNumber ,             R05W.owsr05_repair_ord_open_y AS RepairOrderOpenDate ,             CASE                        WHEN C01WH.owsl60_proc_state_c = '01' THEN 1                        WHEN C01WH.owsl60_proc_state_c = '09' THEN 2                        WHEN C01WH.owsl60_proc_state_c = '11' THEN 3                        WHEN C01WH.owsl60_proc_state_c = '06' THEN 4                        ELSE 99             END                     AS Claim_Order ,             C01WH.owsl60_proc_state_c AS ".WarrantyClaim(1).ClaimStatus" ,             C01W.owsc01_repair_ln_r AS ".WarrantyClaim(1).RepairLineNumber" ,             CASE                        WHEN C01WH.owsl60_proc_state_c = '01' THEN 'PAID'                        WHEN C01WH.owsl60_proc_state_c = '02' THEN 'DEALER ACTION REQUIRED'                        WHEN C01WH.owsl60_proc_state_c = '03' THEN 'MANUAL REVIEW'                        WHEN C01WH.owsl60_proc_state_c = '09' THEN 'PAID ADJUSTED'                        WHEN C01WH.owsl60_proc_state_c = '11' THEN 'DENIED'                        WHEN C01WH.owsl60_proc_state_c = '06' THEN 'CANCELLED'             END                                                                  AS ".WarrantyClaim(1).ClaimStatusDesc",               C01W.owsc01_clm_k                                                      AS ".WarrantyClaim(1).ClaimKey2" ,             C01WH.owsc01_submt_t                                                   AS ".WarrantyClaim(1).SubmissionCount" ,             Isnull(C01WH.owsl15_prim_cvge_catg_c,C01WH.owsl15_secndry_cvge_catg_c) AS ".WarrantyClaim(1).WarrantyClaimHistory(1).CoverageCategory" ,             C01WH.owsl17_clm_typ_c                                                 AS ".WarrantyClaim(1).WarrantyClaimHistory(1).ClaimTypeCode" ,             C01WH.owsc01_clm_clp_paid_a                                            AS Requested_Amt ,             C01WHT.owsc01_clm_pay_a                                                AS ".WarrantyClaim(1).WarrantyClaimHistory(1).ClaimPaidAmount2" ,             C01WH.owsc01_clm_paid_y                                                AS ".WarrantyClaim(1).WarrantyClaimHistory(1).ClaimPaidDate" ,             C01WH.owsc01_clm_ref_num_c                                             AS ".WarrantyClaim(1).WarrantyClaimHistory(1).ClaimReferenceNo" ,             Isnull(C01WH.owsc01_appeal_cnt_r,0)                                    AS ".WarrantyClaim(1).WarrantyClaimHistory(1).pyCount" ,             c01wh.OWSC01_EFF_IN_Y                                               AS ".WarrantyClaim(1).WarrantyClaimHistory(1).LastActionDate" ,             c01wh.OWSC01_EFF_IN_Y                                                  AS Disposition_Date ,             C01WHT.owsc01_adj_clm_pay_a                                            AS ".WarrantyClaim(1).WarrantyClaimHistory(1).pyLabel" ,             C01WHT.owsc01_clm_part_tot_a                                           AS ".WarrantyClaim(1).WarrantyClaimHistory(1).PartTotalAmount2" ,             C01WHT.owsc01_clm_lbr_tot_a                                            AS ".WarrantyClaim(1).WarrantyClaimHistory(1).LaborTotalAmount2" ,             C01WHT.owsc01_clm_misc_tot_a                                           AS ".WarrantyClaim(1).WarrantyClaimHistory(1).MiscTotalAmount2"  FROM       dbo.sowsr05w_wrty_repair_visit     AS R05W WITH (nolock)   INNER JOIN dbo.sowsc01w_wrty_clm AS C01W WITH (nolock)  ON         R05W.owsr05_repair_vst_k =C01W.owsr05_repair_vst_k             and R05W.OWSR05_AOR_C = ?       and R05W.OWSR05_DMS_SVC_AGT_PA_C = ?       and R05W.OWSR05_GEO_SLS_C=?       AND R05W.OWSR05_REPAIR_ORD_R = ?  INNER JOIN dbo.sowsc01wh_wrty_clm_hist AS C01WH WITH (nolock)  ON         C01W.owsc01_clm_k=C01WH.owsc01_clm_k  AND        (C01WH.owsc01_src_sys_c LIKE 'OWS%' OR C01WH.owsc01_src_sys_c = 'WQDR')  AND        C01WH.owsl60_proc_state_c IN ('06','11','01','09')   INNER JOIN  dbo.sowsc01wht_wrty_clm_tot AS C01WHT WITH (nolock)  ON         C01WH.owsc01_clm_k=C01WHT.owsc01_clm_k  AND        C01WH.owsc01_eff_in_y = C01WHT.owsc01_eff_in_y       inserts: <NA> <00088> <USA> <564464> *