Job EC43FDBD-1701-4A6E-94C3-41ABF4197E66

Failed
Back to batch
Batch
57205BC5-4894-45C8-8495-DF0B9AEB5FFA
Template
AssociateSummary
Recipient
Santosh.Kapal@kwglobal.com (Santosh Kapal)
User id
262BE705-F0BB-43B8-8A84-23BFFD105F2E
Status
Failed
Attempts
1
Claimed by
thr-6716 at 2026-10-05 03:02:14.792590
Created
2026-10-05 02:30:54.704536
Completed
2026-10-05 03:03:36.288408

Last error (at 2026-10-05 03:03:36.288408)

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-10-05 03:02:14.827593 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Santosh.Kapal@kwglobal.com userId=262BE705-F0BB-43B8-8A84-23BFFD105F2E thr-6716
2026-10-05 03:02:14.835590 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='262BE705-F0BB-43B8-8A84-23BFFD105F2E', @Date='2026-10-04') thr-6716
2026-10-05 03:03:35.738343 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 80893ms; 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} 80893 thr-6716
2026-10-05 03:03:35.862346 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-10-04', @IsApp=1, @IsForLineManager=1, @LineManagerId='262BE705-F0BB-43B8-8A84-23BFFD105F2E', @IncludeEmployeeDetails=1) thr-6716
2026-10-05 03:03:36.160775 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 40ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 40 thr-6716
2026-10-05 03:03:36.259407 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 81368 thr-6716