Job 5B1FF2F1-EB6F-41A0-A584-3436AE09916C

Failed
Back to batch
Batch
8834D56D-0EE3-4133-93F8-9F2BAC59258C
Template
AssociateSummary
Recipient
ashok.kumar@kwglobal.com (Ashok Kumar)
User id
CCCB3F8C-085C-446A-A54F-74B80C726A8F
Status
Failed
Attempts
1
Claimed by
thr-35224 at 2026-08-02 02:52:44.533544
Created
2026-08-02 02:51:26.372705
Completed
2026-08-02 02:54:02.920675

Last error (at 2026-08-02 02:54:02.920675)

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:52:44.547551 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=ashok.kumar@kwglobal.com userId=CCCB3F8C-085C-446A-A54F-74B80C726A8F thr-35224
2026-08-02 02:52:44.571553 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='CCCB3F8C-085C-446A-A54F-74B80C726A8F', @Date='2026-08-01') thr-35224
2026-08-02 02:54:02.830652 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 78253ms; 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} 78253 thr-35224
2026-08-02 02:54:02.842673 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-35224
2026-08-02 02:54:02.877683 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 6ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 6 thr-35224
2026-08-02 02:54:02.902683 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 78326 thr-35224