Job 5666386E-C49F-46B0-866D-E86A95CDA67D

Failed
Back to batch
Batch
F30BC262-4E1C-4E47-A21E-2A8D265E1ED5
Template
AssociateSummary
Recipient
Santosh.Kapal@kwglobal.com (Santosh Kapal)
User id
262BE705-F0BB-43B8-8A84-23BFFD105F2E
Status
Failed
Attempts
1
Claimed by
thr-22596 at 2026-09-28 03:03:38.505123
Created
2026-09-28 02:31:01.306551
Completed
2026-09-28 03:04:31.115092

Last error (at 2026-09-28 03:04:31.115092)

DataFetch error: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)')

Stage 2 — Data

Not yet fetched.

Stage 3 — Rendered

Not yet rendered.

Stage 5 — Dispatched

Not yet dispatched.

Events

AtStageLevelMessagemsWorker
2026-09-28 03:03:38.513120 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Santosh.Kapal@kwglobal.com userId=262BE705-F0BB-43B8-8A84-23BFFD105F2E thr-22596
2026-09-28 03:03:38.516119 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='262BE705-F0BB-43B8-8A84-23BFFD105F2E', @Date='2026-09-27') thr-22596
2026-09-28 03:04:30.905503 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 8 row(s) in 52385ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttendanceBasedOnTracking,IsUserHavingShift,StartTime,FinishTime,MessageEnum,IsNoImpactEnabled]; first_row={UserId=74213EB9-C938-49D5-B4FE-88F..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Joel Ferrao, UserEmail=Joel.Ferrao@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 52385 thr-22596
2026-09-28 03:04:30.938507 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-09-27', @IsApp=1, @IsForLineManager=1, @LineManagerId='262BE705-F0BB-43B8-8A84-23BFFD105F2E', @IncludeEmployeeDetails=1) thr-22596
2026-09-28 03:04:30.978505 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 9ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 9 thr-22596
2026-09-28 03:04:31.078089 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 52468 thr-22596