Job 6DA495B2-7833-4F53-B032-0DE83AA48B88

Failed
Back to batch
Batch
5206979E-17B6-4103-A1BD-2367E683E9E3
Template
AssociateSummary
Recipient
ashok.kumar@kwglobal.com (Ashok Kumar)
User id
CCCB3F8C-085C-446A-A54F-74B80C726A8F
Status
Failed
Attempts
1
Claimed by
thr-47524 at 2026-08-02 03:34:13.374734
Created
2026-08-02 03:32:29.064594
Completed
2026-08-02 03:34:58.716848

Last error (at 2026-08-02 03:34:58.716848)

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-08-02 03:34:13.378732 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=ashok.kumar@kwglobal.com userId=CCCB3F8C-085C-446A-A54F-74B80C726A8F thr-47524
2026-08-02 03:34:13.382732 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='CCCB3F8C-085C-446A-A54F-74B80C726A8F', @Date='2026-08-01') thr-47524
2026-08-02 03:34:58.694857 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 45306ms; 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=57625AA8-4F11-4E64-A269-058..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Ashish Sharma, UserEmail=ashish.sharma@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 45306 thr-47524
2026-08-02 03:34:58.699851 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-01', @IsApp=1, @IsForLineManager=1, @LineManagerId='CCCB3F8C-085C-446A-A54F-74B80C726A8F', @IncludeEmployeeDetails=1) thr-47524
2026-08-02 03:34:58.709848 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-47524
2026-08-02 03:34:58.714846 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 45332 thr-47524