Job A0870259-2E44-44D1-843F-9EE877121810

Failed
Back to batch
Batch
0AD0C7EF-6F50-4766-90D2-E92054E577DD
Template
AssociateSummary
Recipient
kumar.shashi@kwglobal.com (Kumar Shashi)
User id
0F3E6351-8E5F-4E17-A33C-A04A663B044A
Status
Failed
Attempts
1
Claimed by
thr-8316 at 2026-09-07 02:57:50.502407
Created
2026-09-07 02:30:21.310674
Completed
2026-09-07 02:59:59.813201

Last error (at 2026-09-07 02:59:59.813201)

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-07 02:57:50.518408 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=kumar.shashi@kwglobal.com userId=0F3E6351-8E5F-4E17-A33C-A04A663B044A thr-8316
2026-09-07 02:57:50.522408 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='0F3E6351-8E5F-4E17-A33C-A04A663B044A', @Date='2026-09-06') thr-8316
2026-09-07 02:59:59.604549 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 9 row(s) in 129078ms; 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=258A748A-DB59-42B9-AA03-0C1..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Ajay Kumar, UserEmail=ajay.kumar@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 129078 thr-8316
2026-09-07 02:59:59.618549 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-09-06', @IsApp=1, @IsForLineManager=1, @LineManagerId='0F3E6351-8E5F-4E17-A33C-A04A663B044A', @IncludeEmployeeDetails=1) thr-8316
2026-09-07 02:59:59.712199 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 63ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 63 thr-8316
2026-09-07 02:59:59.795200 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 129210 thr-8316