Job 8C32665C-B65D-4436-8975-E415E5C938A9

Failed
Back to batch
Batch
BA35B8CD-AA80-49B1-834E-499523B79CE3
Template
AssociateSummary
Recipient
ashok.kumar@kwglobal.com (Ashok Kumar)
User id
CCCB3F8C-085C-446A-A54F-74B80C726A8F
Status
Failed
Attempts
1
Claimed by
thr-13396 at 2026-08-02 02:31:50.366950
Created
2026-08-02 02:30:26.976958
Completed
2026-08-02 02:33:07.088754

Last error (at 2026-08-02 02:33:07.088754)

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 02:31:50.395951 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=ashok.kumar@kwglobal.com userId=CCCB3F8C-085C-446A-A54F-74B80C726A8F thr-13396
2026-08-02 02:31:50.434953 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='CCCB3F8C-085C-446A-A54F-74B80C726A8F', @Date='2026-08-01') thr-13396
2026-08-02 02:33:06.974142 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 76519ms; 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} 76519 thr-13396
2026-08-02 02:33:06.979141 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-13396
2026-08-02 02:33:07.002141 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 15ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 15 thr-13396
2026-08-02 02:33:07.079758 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 76584 thr-13396