Job 9CF04F69-3733-46CA-BAEB-D9D3323D74F6

Failed
Back to batch
Batch
D34FEE25-7EAE-4A01-8A0B-E3327134AB47
Template
AssociateSummary
Recipient
ashok.kumar@kwglobal.com (Ashok Kumar)
User id
CCCB3F8C-085C-446A-A54F-74B80C726A8F
Status
Failed
Attempts
1
Claimed by
thr-41992 at 2026-08-02 03:13:48.189915
Created
2026-08-02 03:12:27.426801
Completed
2026-08-02 03:15:04.158209

Last error (at 2026-08-02 03:15:04.158209)

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:13:48.191911 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=ashok.kumar@kwglobal.com userId=CCCB3F8C-085C-446A-A54F-74B80C726A8F thr-41992
2026-08-02 03:13:48.194914 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='CCCB3F8C-085C-446A-A54F-74B80C726A8F', @Date='2026-08-01') thr-41992
2026-08-02 03:15:04.078204 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 7 row(s) in 75867ms; 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} 75867 thr-41992
2026-08-02 03:15:04.088207 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-41992
2026-08-02 03:15:04.146210 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 51ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 51 thr-41992
2026-08-02 03:15:04.154205 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 75957 thr-41992