Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,728 questions
D365FSCM Demand forecasting using Azure ML service output parsing error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 74%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shubhadeep Bhowmick
0
Reputation points
Hi,
I have completed Demand forecasting setup in D365 and the pipeline is executing successfully and output files are getting stored in demplan-azureml/outputs folder.
But in Generate forecast in Azure Machine Learning service step it is showing error "Demand forecast cannot be generated in Azure Machine Learning service. The following error has occurred: The value could not be parsed."
From the detailed log it looks like the error is coming from D365 side.
Sample output file using demo data -
"usmf 1 D_Aloc D0004 000005 ",1459,148,16.6308458921961,-1,ARIMA
"usmf 1 D_Aloc D0004 000005 ",1460,148,16.6308458921961,0,
"usmf 1 D_Aloc D0004 000005 ",1461,148,16.6308458921961,0,
"usmf 1 D_Aloc D0004 000005 ",1462,148,16.6308458921961,0
detail log :
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.FormatException: The value could not be parsed.
at System.Numerics.BigNumber.ParseBigInteger(String value, NumberStyles style, NumberFormatInfo info)
at Microsoft.Dynamics.AX.DemandPlanning.Azure.Data.BaseReader.GetDecimal(Int32 i)
at Dynamics.AX.Application.ReqDemPlanAzureMlStrategy.prepareForecastLine(ReqDemPlanForecast _forecast, ReqDemPlanCreateForecastDataContract _dataContract, ISimpleDataReader _reader, ReqDemPlanDateConverter _dateConverter, List _enabledAttributes, ReqDemPlanAllocationKeyFilterTmp _allocationKeyFilterTable)
at Dynamics.AX.Application.ReqDemPlanAzureMlStrategy.importPredictions(ReqDemPlanCreateForecastDataContract _dataContract, ReqDemPlanAllocationKeyFilterTmp _allocationKeyFilterTable)
at Dynamics.AX.Application.ReqDemPlanAzureMlStrategy.generateAndImportPredictions(ReqDemPlanCreateForecastDataContract _dataContract, ReqDemPlanAllocationKeyFilterTmp _allocationKeyFilterTable)
--- End of inner exception stack trace ---
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
YutongTie-MSFT 48,586 Reputation points2023-10-17T01:38:08.23+00:00 @Shubhadeep Bhowmick Thanks for reaching out to us, based on the error message you provided, it seems like there is an issue with parsing the output file generated by the Demand forecasting setup in D365. The error message indicates that the value could not be parsed, which suggests that there might be an issue with the format of the output file.
I would recommend checking the format of the output file and ensuring that it matches the expected format. You can refer to the documentation for the Demand forecasting setup in D365 to understand the expected format of the output file.
If the format of the output file is correct, then you might want to check if there are any issues with the data being used for the Demand forecasting setup. It is possible that the data being used is not in the correct format or contains invalid values, which could cause issues with the Demand forecasting setup.
You can also try to reproduce the issue with a smaller dataset or with demo data to isolate the issue and identify the root cause.
I hope this helps.
Regards,
Yutong
-
YutongTie-MSFT 48,586 Reputation points
2023-10-17T20:27:11.1066667+00:00 @Shubhadeep Bhowmick Thanks for reaching out to us again, do you have a chance to check on my comment? Does it help?
Regards,
Yutong
-
Shubhadeep Bhowmick 0 Reputation points
2023-10-18T12:59:24.8866667+00:00 @YutongTie-MSFT Thanks for your response.
I have checked the output text file in Demplan-azure/outputs. It matches the expected output format.Is there any way to debug this ? As in Tier 1 dev environments I am not able to configure the Demand forecasting setup using AzureML service.
Attaching sample data output -
"abcd 8000 On_KEY 100 5 ",1476,168,0,-1,ARIMA
"abcd 8000 On_KEY 100 5 ",1477,168,0,0,
"abcd 8000 On_KEY 100 5 ",1478,168,0,0,
"abcd 8000 On_KEY 100 5 ",1479,168,0,0,
"abcd 8000 On_KEY 100 5 ",1480,168,0,0,
"abcd 8000 On_KEY 100 5 ",1481,168,0,0,
(although the spaces are showing as a rectangle, but it was similar in the
Demand Forecasting with Azure Machine Learning Series Webminar)
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 35%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Das Gupta, Abhijeet 100 Reputation points2023-12-07T11:37:27.7366667+00:00 The error is occurring because the model name is only listed in the first row whereas it should be listed in every row of output. Hope this helps!
Could you or @YutongTie-MSFT help me determine where I can find the detail logs in X++ when the forecast generation fails in X++?
Thank you
Sign in to comment