Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 12-Jul-2026 2:09:41:5471 AM Connection : wrench Command(s) : UPDATE WBS_DETAILS SET PERCENT_COMPLETED = ISNULL((SELECT CASE CAST(SUM((CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END)) AS DECIMAL(18,8)) WHEN 0 THEN 0 ELSE CAST(SUM(ISNULL(TP.PERCENT_COMPLETED,0)*(CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END))AS DECIMAL(18,8))/ SUM(CAST((CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END) AS DECIMAL(18,8))) END FROM WBS_DETAILS TP WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND ISNULL(TP.CONTRIBUTION_TOWARDS,0) <> 1 AND (CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,0) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) END)<>0 GROUP BY TP.PARENT_ID),0), ACT_START_DATE = (SELECT MIN(TP.ACT_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID =WBS_DETAILS.TASK_ID AND TP.ACT_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ) , ACT_FINISH_DATE = NULL, INTR_START_DATE = (SELECT MIN(TP.INTR_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.INTR_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ) , INTR_FINISH_DATE = (SELECT MAX(TP.INTR_FINISH_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.INTR_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), BASELINE_START_DATE = (SELECT MIN(TP.BASELINE_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.BASELINE_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), BASELINE_FINISH_DATE = (SELECT MAX(TP.BASELINE_FINISH_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.BASELINE_FINISH_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), ACT_START_DATE_MANUAL = (SELECT MIN(TP.ACT_START_DATE_MANUAL) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.ACT_START_DATE_MANUAL IS NOT NULL GROUP BY TP.PARENT_ID ), ACT_FINISH_DATE_MANUAL = NULL WHERE IS_SUMMARY = 1 AND EDIT_ACTUAL <> 1 AND TASK_LEVEL = 2 AND WBS_ID = 10462296 Connection Timeout : 0 Queries : UPDATE WBS_DETAILS SET PERCENT_COMPLETED = ISNULL((SELECT CASE CAST(SUM((CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END)) AS DECIMAL(18,8)) WHEN 0 THEN 0 ELSE CAST(SUM(ISNULL(TP.PERCENT_COMPLETED,0)*(CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END))AS DECIMAL(18,8))/ SUM(CAST((CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,1) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,1) END) AS DECIMAL(18,8))) END FROM WBS_DETAILS TP WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND ISNULL(TP.CONTRIBUTION_TOWARDS,0) <> 1 AND (CASE WHEN ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) = 0 THEN ISNULL(TP.CONTRIBUTION_TO_PARENT,0) ELSE ISNULL(TP.CONTRIBUTION_TO_PROJECT,0) END)<>0 GROUP BY TP.PARENT_ID),0), ACT_START_DATE = (SELECT MIN(TP.ACT_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID =WBS_DETAILS.TASK_ID AND TP.ACT_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ) , ACT_FINISH_DATE = NULL, INTR_START_DATE = (SELECT MIN(TP.INTR_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.INTR_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ) , INTR_FINISH_DATE = (SELECT MAX(TP.INTR_FINISH_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.INTR_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), BASELINE_START_DATE = (SELECT MIN(TP.BASELINE_START_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.BASELINE_START_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), BASELINE_FINISH_DATE = (SELECT MAX(TP.BASELINE_FINISH_DATE) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.BASELINE_FINISH_DATE IS NOT NULL GROUP BY TP.PARENT_ID ), ACT_START_DATE_MANUAL = (SELECT MIN(TP.ACT_START_DATE_MANUAL) FROM WBS_DETAILS TP WITH(NOLOCK) WHERE TP.PARENT_ID = WBS_DETAILS.TASK_ID AND TP.ACT_START_DATE_MANUAL IS NOT NULL GROUP BY TP.PARENT_ID ), ACT_FINISH_DATE_MANUAL = NULL WHERE IS_SUMMARY = 1 AND EDIT_ACTUAL <> 1 AND TASK_LEVEL = 2 AND WBS_ID = 10462296 ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 159) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 12-Jul-2026 2:27:20:6501 AM Connection : wrench Command(s) : UPDATE WD SET CUST_WEIGHTAGE = WD.CONTRIBUTION_TO_PROJECT FROM WBS_DETAILS WD WHERE WD.WBS_ID = 10554077 AND (ISNULL(WD.WEIGHTAGE,0) = 0 OR ISNULL(WD.AREACODE_ID,0) = 0) AND (ISNULL(WD.CONVERSION_FACTOR,0) = 0 OR iSNULL(WD.BUDGETED_QUANTITY,0) = 0) AND ISNULL(CONTRIBUTION_TO_PROJECT,0) > 0 Connection Timeout : 0 Queries : UPDATE WD SET CUST_WEIGHTAGE = WD.CONTRIBUTION_TO_PROJECT FROM WBS_DETAILS WD WHERE WD.WBS_ID = 10554077 AND (ISNULL(WD.WEIGHTAGE,0) = 0 OR ISNULL(WD.AREACODE_ID,0) = 0) AND (ISNULL(WD.CONVERSION_FACTOR,0) = 0 OR iSNULL(WD.BUDGETED_QUANTITY,0) = 0) AND ISNULL(CONTRIBUTION_TO_PROJECT,0) > 0 ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 159) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 12-Jul-2026 2:27:38:2180 AM Connection : wrench Command(s) : UPDATE WD SET CUST_WEIGHTAGE = WD.CONTRIBUTION_TO_PROJECT FROM WBS_DETAILS WD WHERE WD.WBS_ID = 10554077 AND (ISNULL(WD.WEIGHTAGE,0) = 0 OR ISNULL(WD.AREACODE_ID,0) = 0) AND (ISNULL(WD.CONVERSION_FACTOR,0) = 0 OR iSNULL(WD.BUDGETED_QUANTITY,0) = 0) AND ISNULL(CONTRIBUTION_TO_PROJECT,0) > 0 Connection Timeout : 0 Queries : UPDATE WD SET CUST_WEIGHTAGE = WD.CONTRIBUTION_TO_PROJECT FROM WBS_DETAILS WD WHERE WD.WBS_ID = 10554077 AND (ISNULL(WD.WEIGHTAGE,0) = 0 OR ISNULL(WD.AREACODE_ID,0) = 0) AND (ISNULL(WD.CONVERSION_FACTOR,0) = 0 OR iSNULL(WD.BUDGETED_QUANTITY,0) = 0) AND ISNULL(CONTRIBUTION_TO_PROJECT,0) > 0 ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 159) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 12-Jul-2026 2:27:43:2336 AM Connection : wrench Command(s) : UPDATE AA SET PLANNED_PERCENT = CASE WHEN (AA.PLAN_COMPLETION_PERCENTAGE IS NULL OR AA.PLAN_COMPLETION_PERCENTAGE < 0) THEN (CASE WHEN AA.NEXT_PLAN_COMPLETION_PERCENTAGE IS NULL THEN ISNULL(AA.TASK_PERCENTAGE,0.00) ELSE 0.00 END ) ELSE AA.PLAN_COMPLETION_PERCENTAGE END FROM ( SELECT TASK_ID,PLANNED_PERCENT ,( SELECT TOP(1) WTR.CUM_PERCENTAGE_PROGRESS FROM WBS_TASK_RULES WTR WITH(NOLOCK) WHERE WTR.PLAN_FINISH_DATE <= ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) AND WTR.CUM_PERCENTAGE_PROGRESS > 0 AND WTR.TASK_REV_NO=WD.TASK_REVNO AND WTR.TASK_ID=WD.TASK_ID AND ISNULL(WTR.PARENT_RULE_ID,0)=0 ORDER BY WTR.PLAN_FINISH_DATE DESC,WTR.CUM_PERCENTAGE_PROGRESS DESC ) AS PLAN_COMPLETION_PERCENTAGE ,( SELECT TOP(1) WTR.CUM_PERCENTAGE_PROGRESS FROM WBS_TASK_RULES WTR WITH(NOLOCK) WHERE WTR.PLAN_FINISH_DATE > ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) AND WTR.CUM_PERCENTAGE_PROGRESS > 0 AND WTR.TASK_REV_NO=WD.TASK_REVNO AND WTR.TASK_ID=WD.TASK_ID AND ISNULL(WTR.PARENT_RULE_ID,0)=0 ORDER BY WTR.PLAN_FINISH_DATE DESC,WTR.CUM_PERCENTAGE_PROGRESS DESC ) AS NEXT_PLAN_COMPLETION_PERCENTAGE ,CASE WHEN PLAN_FINISH_DATE <> '' THEN CASE WHEN PLAN_FINISH_DATE<=ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) THEN 100 ELSE 0 END END AS TASK_PERCENTAGE FROM WBS_DETAILS WD WITH(NOLOCK) INNER JOIN WBS_HEADER WH WITH(NOLOCK) ON WH.WBS_ID = WD.WBS_ID WHERE WD.WBS_ID=10554077 AND WD.IS_PROJECTED_PROGRESS=0 AND ISNULL(WD.PROGRESS_VALUE_TYPE,0) <> 1 AND ISNULL(WD.CONTRIBUTION_TOWARDS,0) <> 2 ) AA Connection Timeout : 0 Queries : UPDATE AA SET PLANNED_PERCENT = CASE WHEN (AA.PLAN_COMPLETION_PERCENTAGE IS NULL OR AA.PLAN_COMPLETION_PERCENTAGE < 0) THEN (CASE WHEN AA.NEXT_PLAN_COMPLETION_PERCENTAGE IS NULL THEN ISNULL(AA.TASK_PERCENTAGE,0.00) ELSE 0.00 END ) ELSE AA.PLAN_COMPLETION_PERCENTAGE END FROM ( SELECT TASK_ID,PLANNED_PERCENT ,( SELECT TOP(1) WTR.CUM_PERCENTAGE_PROGRESS FROM WBS_TASK_RULES WTR WITH(NOLOCK) WHERE WTR.PLAN_FINISH_DATE <= ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) AND WTR.CUM_PERCENTAGE_PROGRESS > 0 AND WTR.TASK_REV_NO=WD.TASK_REVNO AND WTR.TASK_ID=WD.TASK_ID AND ISNULL(WTR.PARENT_RULE_ID,0)=0 ORDER BY WTR.PLAN_FINISH_DATE DESC,WTR.CUM_PERCENTAGE_PROGRESS DESC ) AS PLAN_COMPLETION_PERCENTAGE ,( SELECT TOP(1) WTR.CUM_PERCENTAGE_PROGRESS FROM WBS_TASK_RULES WTR WITH(NOLOCK) WHERE WTR.PLAN_FINISH_DATE > ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) AND WTR.CUM_PERCENTAGE_PROGRESS > 0 AND WTR.TASK_REV_NO=WD.TASK_REVNO AND WTR.TASK_ID=WD.TASK_ID AND ISNULL(WTR.PARENT_RULE_ID,0)=0 ORDER BY WTR.PLAN_FINISH_DATE DESC,WTR.CUM_PERCENTAGE_PROGRESS DESC ) AS NEXT_PLAN_COMPLETION_PERCENTAGE ,CASE WHEN PLAN_FINISH_DATE <> '' THEN CASE WHEN PLAN_FINISH_DATE<=ISNULL(WH.PROGRESS_AS_ON_DATE, GETDATE()) THEN 100 ELSE 0 END END AS TASK_PERCENTAGE FROM WBS_DETAILS WD WITH(NOLOCK) INNER JOIN WBS_HEADER WH WITH(NOLOCK) ON WH.WBS_ID = WD.WBS_ID WHERE WD.WBS_ID=10554077 AND WD.IS_PROJECTED_PROGRESS=0 AND ISNULL(WD.PROGRESS_VALUE_TYPE,0) <> 1 AND ISNULL(WD.CONTRIBUTION_TOWARDS,0) <> 2 ) AA Baton Error Messages : Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------