Failure : Method Name : ExecuteSQL Database connection failed. Please contact Network/Database Administrators. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated. Login : ADMIN 20-Apr-2026 5:04:47:8657 PM Connection : wrench Command(s) : UPDATE WBS_DETAILS SET CONTRIBUTION_TO_PROJECT=0, CUST_WEIGHTAGE=0 WHERE WBS_ID = 10554077 Connection Timeout : 0 Queries : UPDATE WBS_DETAILS SET CONTRIBUTION_TO_PROJECT=0, CUST_WEIGHTAGE=0 WHERE WBS_ID = 10554077 ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 441) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Warning: Null value is eliminated by an aggregate or other SET operation. Login : ADMIN 20-Apr-2026 5:04:58:4750 PM Connection : wrench Command(s) : IF OBJECT_ID ('TEMPDB..#ARTEMP') IS NOT NULL DROP TABLE #ARTEMP; WITH CTE AS ( SELECT ORD_AREA_ID,PARENT_ORD_AREA_ID, CAST(CASE WHEN ISNULL(WEIGHTAGE,0) >0 THEN AREA_CODE ELSE '' END AS NVARCHAR(4000)) HIERARCHY , WEIGHTAGE, CASE WHEN ISNULL(WEIGHTAGE,0) = 0 THEN CAST(1 AS DECIMAL(18,8)) ELSE CAST(CAST(WEIGHTAGE AS DECIMAL(18,8))/100 AS DECIMAL(18,8)) END CONTRIBUTION FROM ORDER_AREA WHERE ORDER_ID = (SELECT ORDER_ID FROM WBS_HEADER WHERE WBS_ID = 10554077) AND LEVEL = 0 UNION ALL SELECT OA.ORD_AREA_ID,OA.PARENT_ORD_AREA_ID, CAST(AT.HIERARCHY + (CAST(CASE WHEN ISNULL(OA.WEIGHTAGE,0) >0 THEN '->' + OA.AREA_CODE ELSE '' END AS NVARCHAR)) AS NVARCHAR(4000)) HIERARCHY, OA.WEIGHTAGE, CAST(CASE WHEN ISNULL(OA.WEIGHTAGE,0) = 0 THEN CAST(1 AS DECIMAL(18,8)) ELSE CAST(OA.WEIGHTAGE AS DECIMAL(18,8))/100 END * CAST(AT.CONTRIBUTION AS DECIMAL(18,8)) AS DECIMAL(18,8)) CONTRIBUTION FROM CTE AT INNER JOIN ORDER_AREA OA ON OA.PARENT_ORD_AREA_ID = AT.ORD_AREA_ID ) SELECT * INTO #ARTEMP FROM CTE; UPDATE WD SET CUST_WEIGHTAGE = ISNULL((100 * CAST(WD.WEIGHTAGE AS DECIMAL(18,8)) * CONTRIBUTION /WEIGHTAGE_SUM), WD.WEIGHTAGE), CONTRIBUTION_TO_PROJECT = ISNULL((100 * CAST(WD.WEIGHTAGE AS DECIMAL(18,8)) * CONTRIBUTION /WEIGHTAGE_SUM),WD.WEIGHTAGE) FROM #ARTEMP AT INNER JOIN WBS_DETAILS WD ON AT.ORD_AREA_ID = WD.AREACODE_ID OUTER APPLY ( SELECT SUM(WD1.WEIGHTAGE) WEIGHTAGE_SUM FROM WBS_DETAILS WD1 WHERE WD1.WBS_ID = WD.WBS_ID AND WD1.AREACODE_ID IN ( SELECT ORD_AREA_ID FROM #ARTEMP WHERE #ARTEMP.HIERARCHY = (SELECT TOP 1 HIERARCHY FROM #ARTEMP WHERE ORD_AREA_ID = WD.AREACODE_ID) ) )WT WHERE WD.WBS_ID = 10554077 AND ISNULL(WD.WEIGHTAGE,0) > 0 Connection Timeout : 0 Queries : IF OBJECT_ID ('TEMPDB..#ARTEMP') IS NOT NULL DROP TABLE #ARTEMP; WITH CTE AS ( SELECT ORD_AREA_ID,PARENT_ORD_AREA_ID, CAST(CASE WHEN ISNULL(WEIGHTAGE,0) >0 THEN AREA_CODE ELSE '' END AS NVARCHAR(4000)) HIERARCHY , WEIGHTAGE, CASE WHEN ISNULL(WEIGHTAGE,0) = 0 THEN CAST(1 AS DECIMAL(18,8)) ELSE CAST(CAST(WEIGHTAGE AS DECIMAL(18,8))/100 AS DECIMAL(18,8)) END CONTRIBUTION FROM ORDER_AREA WHERE ORDER_ID = (SELECT ORDER_ID FROM WBS_HEADER WHERE WBS_ID = 10554077) AND LEVEL = 0 UNION ALL SELECT OA.ORD_AREA_ID,OA.PARENT_ORD_AREA_ID, CAST(AT.HIERARCHY + (CAST(CASE WHEN ISNULL(OA.WEIGHTAGE,0) >0 THEN '->' + OA.AREA_CODE ELSE '' END AS NVARCHAR)) AS NVARCHAR(4000)) HIERARCHY, OA.WEIGHTAGE, CAST(CASE WHEN ISNULL(OA.WEIGHTAGE,0) = 0 THEN CAST(1 AS DECIMAL(18,8)) ELSE CAST(OA.WEIGHTAGE AS DECIMAL(18,8))/100 END * CAST(AT.CONTRIBUTION AS DECIMAL(18,8)) AS DECIMAL(18,8)) CONTRIBUTION FROM CTE AT INNER JOIN ORDER_AREA OA ON OA.PARENT_ORD_AREA_ID = AT.ORD_AREA_ID ) SELECT * INTO #ARTEMP FROM CTE; UPDATE WD SET CUST_WEIGHTAGE = ISNULL((100 * CAST(WD.WEIGHTAGE AS DECIMAL(18,8)) * CONTRIBUTION /WEIGHTAGE_SUM), WD.WEIGHTAGE), CONTRIBUTION_TO_PROJECT = ISNULL((100 * CAST(WD.WEIGHTAGE AS DECIMAL(18,8)) * CONTRIBUTION /WEIGHTAGE_SUM),WD.WEIGHTAGE) FROM #ARTEMP AT INNER JOIN WBS_DETAILS WD ON AT.ORD_AREA_ID = WD.AREACODE_ID OUTER APPLY ( SELECT SUM(WD1.WEIGHTAGE) WEIGHTAGE_SUM FROM WBS_DETAILS WD1 WHERE WD1.WBS_ID = WD.WBS_ID AND WD1.AREACODE_ID IN ( SELECT ORD_AREA_ID FROM #ARTEMP WHERE #ARTEMP.HIERARCHY = (SELECT TOP 1 HIERARCHY FROM #ARTEMP WHERE ORD_AREA_ID = WD.AREACODE_ID) ) )WT WHERE WD.WBS_ID = 10554077 AND ISNULL(WD.WEIGHTAGE,0) > 0 Baton Error Messages : Database connection failed. Please contact Network/Database Administrators. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:05:01:0531 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 441) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:05:04:2562 PM 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 Baton Error Messages : Database connection failed. Please contact Network/Database Administrators. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:05:31:8029 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : ExecuteSQL Server is busy. Please try again. Transaction (Process ID 441) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:05:54:9535 PM 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 : Database connection failed. Please contact Network/Database Administrators. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:06:03:4223 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:06:20:3283 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:06:45:3228 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:07:03:1976 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:07:29:1193 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:08:14:5769 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------ Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 393) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : ADMIN 20-Apr-2026 5:08:41:2330 PM Connection : wrench Command(s) : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Connection Timeout : 0 Queries : SELECT TASK_ID FROM WBS_DETAILS WHERE WBS_ID = 10554077 AND ACT_FINISH_DATE IS NOT NULL AND STATUS <> 4 Baton Error Messages : Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. Server is busy. Please try again. ------------------------------------------------------------------------------------------------------------------------------------------------------