Job 5E2E0C2D-BDB8-4AF4-BC9C-FD03CE517ACE

Failed
Back to batch
Batch
1450A83C-4C7C-4426-B353-AC1C6D16EAAF
Template
AssociateSummary
Recipient
pankaj.singh1@kwglobal.com (Pankaj Singh1)
User id
33B3A7A8-1EC1-4D23-A246-3303D909EF26
Status
Failed
Attempts
1
Claimed by
thr-11388 at 2026-09-21 02:52:08.437878
Created
2026-09-21 02:30:57.746698
Completed
2026-09-21 02:53:29.038070

Last error (at 2026-09-21 02:53:29.038070)

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-21 02:52:08.439879 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=pankaj.singh1@kwglobal.com userId=33B3A7A8-1EC1-4D23-A246-3303D909EF26 thr-11388
2026-09-21 02:52:08.452882 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='33B3A7A8-1EC1-4D23-A246-3303D909EF26', @Date='2026-09-20') thr-11388
2026-09-21 02:53:28.899509 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 9 row(s) in 80412ms; 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=1277DE16-0E0E-403B-AC16-3A1..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Arvind N, UserEmail=arvind.n@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 80412 thr-11388
2026-09-21 02:53:28.923478 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-09-20', @IsApp=1, @IsForLineManager=1, @LineManagerId='33B3A7A8-1EC1-4D23-A246-3303D909EF26', @IncludeEmployeeDetails=1) thr-11388
2026-09-21 02:53:28.940506 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-11388
2026-09-21 02:53:29.008065 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 80511 thr-11388