Job 193A0AE1-08A3-4BFE-B02C-A197B725A3F7

Failed
Back to batch
Batch
1719F4C6-A0AD-4B4F-B916-05AE9442930B
Template
AssociateSummary
Recipient
amit.patil@kwglobal.com (Amit Patil)
User id
06968F7C-F2A3-4680-AFE9-6BFB34CF15A3
Status
Failed
Attempts
1
Claimed by
thr-19984 at 2026-08-10 02:30:56.374918
Created
2026-08-10 02:30:56.148761
Completed
2026-08-10 02:32:27.981220

Last error (at 2026-08-10 02:32:27.981220)

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-10 02:30:56.388330 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=amit.patil@kwglobal.com userId=06968F7C-F2A3-4680-AFE9-6BFB34CF15A3 thr-19984
2026-08-10 02:30:56.442185 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='06968F7C-F2A3-4680-AFE9-6BFB34CF15A3', @Date='2026-08-09') thr-19984
2026-08-10 02:32:27.493623 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 37 row(s) in 91004ms; 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=425B10D6-3829-4204-9779-093..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Aditya Hajare, UserEmail=Aditya.Hajare@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 91004 thr-19984
2026-08-10 02:32:27.575620 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-08-09', @IsApp=1, @IsForLineManager=1, @LineManagerId='06968F7C-F2A3-4680-AFE9-6BFB34CF15A3', @IncludeEmployeeDetails=1) thr-19984
2026-08-10 02:32:27.860216 DataFetch Error <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] FAILED in 212ms: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 212 thr-19984
2026-08-10 02:32:27.973219 DataFetch Error Exception: ('22012', '[22012] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Divide by zero error encountered. (8134) (SQLExecDirectW)') 91485 thr-19984