topic Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables in SAS Software for Learning Community

SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

NataliaSummer — Tue, 04 Jul 2023 20:46:39 GMT

Hello there!

I am using Model Studio in SAS Viya for Learners and running into a weird error in the Data Node. Here is how to replicate:

Create a new project using Forecasting or Hierarchical Forecasting template.
Use pre-loaded PRODUCT_CLEAN data (even though I also tried with PRICE data).
Set ORDER_DATE as time variable
Set QUANTITY as dependent variables
Set PRODUCT_GROUP as BY-VAR (even though I also tried with other variables)
Run the Data Node

Below is the log I'm getting with the error.

Please suggest how to fix or a workaround. I'm preparing a workshop I'm teaching on Tuesday 7/11 and without by-group functionality in VFL I would have to use another tool 😣. Thank you!

The data node is beginning execution.
A lock is being acquired for execution.
The execution lock has been successfully acquired.
The input table for the project is "YVA285.PRODUCTS_CLEAN".
The by-variables are "Product_Group".
The input attributes table is "Analytics_Project_c845f4f5-0301-4c9b-add8-37aa6c388825._ATTRIBUTES".
The input time series table is being accumulated. 
An error occurred during execution: Error accumulating input data
The data node has completed execution in 0.707 seconds with the following status: "Failed".
The execution lock has been released.

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

sbxkoenk — Wed, 05 Jul 2023 07:20:26 GMT

Hello Natalia,

The error can be a result of lack of space on the CAS server.

The easiest way to view memory utilization rates is through the dashboard in SAS Environment Manager.
Look at "System Health"-widget >> Node Memory Usage.

Or follow instructions here :
SAS® Viya® 3.5 Administration
CAS Fundamentals
https://go.documentation.sas.com/doc/en/calcdc/3.5/casfun/titlepage.htm

Click on >> Memory

Kind regards,

Koen

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

NataliaSummer — Wed, 05 Jul 2023 13:50:25 GMT

Thank you so much Koen!

Yes, I checked this morning in the Viya for Learners Server, the Node Memory Usage is 10% and the BY-GROUP functionality is working!

Now, is there a way to "reserve" space on VFL or make sure I use the least amount possible? I am teaching a workshop with 30+ folks on Tuesday afternoon live (and everyone would be logged-in and actively using VLS) and I'm afraid it will be erroring-out...

Thanks for your advice!

Natalia

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

mitrov — Wed, 05 Jul 2023 14:12:49 GMT

Natalia,

Can you please open a tech support track? Tech support can guide you to gather the information we need to help you out.

Michele

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

NataliaSummer — Wed, 05 Jul 2023 14:50:37 GMT

Done, just submitted. TS number is 7613821010, would appreciate a soon follow-up, thanks Michele!

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

tom_grant — Thu, 06 Jul 2023 12:39:22 GMT

It works for me on Tenant 35 of Viya for Learners:

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

mitrov — Thu, 06 Jul 2023 14:12:18 GMT

If I understood correctly, it worked after resubmitting it the day after. Her question now is how to prevent the error from happening again during her class.

Re: SAS Model Studio: Forecasting Pipeline: Error in Data Node with By-Variables

sbxkoenk — Wed, 28 May 2025 11:20:36 GMT

Another customer was facing the same problem and referred to this topic in his query to me. In the end, it turned out it was not due to a (lack of) memory problem there ...but due to the fact that he had used an integer variable as a by-variable. That can't be done. The by-variables in the forecasting hierarchy should all be character variables (varchar e.g.).

Ciao,

Koen