-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2023R1
-
Fix Version/s: CFA 2023R2
-
Component/s: Forecasting
-
Labels:None
-
VTask #:VTASK0510564
-
Root cause - Reason:Code defect
-
Source Code ID(s):
-
Root Cause:
CFA reported many store were missing forecast on business day 02/27, Greg fixed the issue manually by running the the server manager task again from Server Manager, Today CFA reported similar issue for 03/06.
I looked in the tbAudit table and I found an error that occurs on 02/12 which the day we generate the forecast for 02/27, and the same error occurred in 02/19 which the day we generate the Forecast for 03/06.
When I run the query I see that this error occurred only 7 times , the earliest was on 2022-10-23.
select top 100 * from tbAudit with (nolock)
where AuditCategoryID = 23 and AuditEventID = 191 and AuditTitle like '%AWSForecastStatusRestClient%'
order by 1 desc
Web Service Task Processing Error: url:https://api.cfascforecastprod.cfahome.com/v1/forecast/status/\{storenumber}/?fromDate={fromdate}&toDate={todate} childUrl:https://api.cfascforecastprod.cfahome.com/v1/forecast/demand/\{storenumber}/{forecastdate} webServiceImplementation:AWSForecastStatusRestClient error:could not execute native bulk manipulation query:update forecasting.forecast set ReadOnly = :isReadOnly where entityid = :entityId and businessday between :startDate and :endDate and ExternalGenerationDate is not null[SQL: update forecasting.forecast set ReadOnly = @p3 where entityid = @p0 and businessday between @p1 and @p2 and ExternalGenerationDate is not null] - at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() at Mx.Forecasting.Data.ForecastRepository.UpdateReadOnlyFlag(Int64 entityId, DateTime startDate, DateTime endDate, Boolean readOnly) at Mx.Services.TaskWebServiceClient.UpdateReadOnlyFlag(Int64 entityId, DateTime localTime, DateTime startDate) at Mx.Services.TaskWebServiceClient.ProcessForAwsForecastStatus(String url, String childUrl, String accessToken, String secretKey, String region, Int32 zoneId, String targetFolder, String fileName, Int32 forecastingNumOfDays, Int32 forecastingOffsetDays) at Mx.Services.TaskWebServiceClient.GetAndSaveResponse(String url, String childUrl, String accessToken, String secretKey, String region, String userName, String password, String webServiceImplementation, Int32 zoneId, String targetFolder, String fileName, Int32 forecastingNumOfDays, Int32 forecastingOffsetDays) at MMS.Tasks.MMSTasks.TaskWebService.ProcessTask()
- blocks
-
CFAMX-11540 Production Defects
-
- Open
-