Failure : Method Name : ExecuteSQL	Server is busy. Please try again.
Transaction (Process ID 327) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Login :	ADMIN	22-Apr-2026 2:40:45:4895 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

Called Methods : 
<UpdateWBSPercentage start>	22-Apr-2026 2:40:13:2408 PM
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabase	15.6249 milliseconds.
GetData	15.6249 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
GetTokenValues	0 milliseconds.
ValidateToken	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
IsValidUser	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
GetNativeServerID	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
CheckIdleTimeExceeds	0 milliseconds.
ValidateModuleLicense	0 milliseconds.
GetConnectedService	0 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabaseOutTrans	0 milliseconds.
SQLOutOfTrans	15.62 milliseconds.
UpdateLastAccessTimeAndProcessStatus	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageLogin	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageWEI	0 milliseconds.
EntryHandler	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	15.622 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10561.3815 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10296.7938 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	156.2456 milliseconds.
OpenDatabase	0 milliseconds.
------------------------------------------------------------------------------------------------------------------------------------------------------



Failure : Method Name : ExecuteSQL	Server is busy. Please try again.
Transaction (Process ID 327) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Login :	ADMIN	22-Apr-2026 2:40:53:2394 PM

Connection :	wrench

Command(s) : UPDATE  WBS_DETAILS SET CONTRIBUTION_TO_PROJECT = CUST_WEIGHTAGE WHERE WBS_ID = 10554077	Connection Timeout : 0

Queries : 
UPDATE  WBS_DETAILS SET CONTRIBUTION_TO_PROJECT = CUST_WEIGHTAGE WHERE WBS_ID = 10554077

Baton Error Messages : 
Server is busy. Please try again.

Called Methods : 
<UpdateWBSPercentage start>	22-Apr-2026 2:40:13:2408 PM
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabase	15.6249 milliseconds.
GetData	15.6249 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
GetTokenValues	0 milliseconds.
ValidateToken	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
IsValidUser	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
GetNativeServerID	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
CheckIdleTimeExceeds	0 milliseconds.
ValidateModuleLicense	0 milliseconds.
GetConnectedService	0 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabaseOutTrans	0 milliseconds.
SQLOutOfTrans	15.62 milliseconds.
UpdateLastAccessTimeAndProcessStatus	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageLogin	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageWEI	0 milliseconds.
EntryHandler	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	15.622 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10561.3815 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10296.7938 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	156.2456 milliseconds.
OpenDatabase	0 milliseconds.
TransactionErrorLogger	0 milliseconds.
ExecuteSQL	11171.7878 milliseconds.
OpenDatabase	0 milliseconds.
------------------------------------------------------------------------------------------------------------------------------------------------------



Failure : Method Name : ExecuteSQL	Server is busy. Please try again.
Transaction (Process ID 327) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Login :	ADMIN	22-Apr-2026 2:41:05:6559 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 : 
Server is busy. Please try again.
Server is busy. Please try again.

Called Methods : 
<UpdateWBSPercentage start>	22-Apr-2026 2:40:13:2408 PM
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabase	15.6249 milliseconds.
GetData	15.6249 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
GetTokenValues	0 milliseconds.
ValidateToken	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
IsValidUser	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
GetNativeServerID	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
CheckIdleTimeExceeds	0 milliseconds.
ValidateModuleLicense	0 milliseconds.
GetConnectedService	0 milliseconds.
GetDate	0 milliseconds.
DecryptStringNew	0 milliseconds.
DecryptString	0 milliseconds.
OpenDatabaseOutTrans	0 milliseconds.
SQLOutOfTrans	15.62 milliseconds.
UpdateLastAccessTimeAndProcessStatus	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageLogin	15.62 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
ManageWEI	0 milliseconds.
EntryHandler	0 milliseconds.
OpenDatabase	0 milliseconds.
GetData	15.622 milliseconds.
OpenDatabase	0 milliseconds.
GetData	0 milliseconds.
GetFieldValue	0 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10561.3815 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	10296.7938 milliseconds.
OpenDatabase	0 milliseconds.
ExecuteSQL	156.2456 milliseconds.
OpenDatabase	0 milliseconds.
TransactionErrorLogger	0 milliseconds.
ExecuteSQL	11171.7878 milliseconds.
OpenDatabase	0 milliseconds.
TransactionErrorLogger	0 milliseconds.
ExecuteSQL	7734.3111 milliseconds.
CalculateCustomerWeightage	39967.3927 milliseconds.
OpenDatabase	0 milliseconds.
------------------------------------------------------------------------------------------------------------------------------------------------------