Job E640D036-9CD9-4CCC-8F18-5684CB82D29E

Failed
Back to batch
Batch
3C3C15B3-39C8-4955-9AA6-D7799D572AEC
Template
AssociateSummary
Recipient
Veena.Mathew@kwglobal.com (Veena Mathew)
User id
59AC1101-F930-4A0A-B073-752E5EFE3368
Status
Failed
Attempts
1
Claimed by
thr-1572 at 2026-10-04 03:07:39.951537
Created
2026-10-04 02:30:07.093957
Completed
2026-10-04 03:09:04.317326

Last error (at 2026-10-04 03:09:04.317326)

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-04 03:07:39.970539 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=Veena.Mathew@kwglobal.com userId=59AC1101-F930-4A0A-B073-752E5EFE3368 thr-1572
2026-10-04 03:07:39.975540 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='59AC1101-F930-4A0A-B073-752E5EFE3368', @Date='2026-10-03') thr-1572
2026-10-04 03:09:04.224290 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 3 row(s) in 84243ms; 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=4891BAFD-B8C8-45E7-82B1-145..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Ankita Pal, UserEmail=Ankita.Pal@kwglobal.com, TotalTime=0h 0m, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=0h 0m} 84243 thr-1572
2026-10-04 03:09:04.229288 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-10-03', @IsApp=1, @IsForLineManager=1, @LineManagerId='59AC1101-F930-4A0A-B073-752E5EFE3368', @IncludeEmployeeDetails=1) thr-1572
2026-10-04 03:09:04.243289 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 7ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 7 thr-1572
2026-10-04 03:09:04.309290 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 84271 thr-1572