topic Re: How to resolve insufficient memory error in SAS Studio Flow (Viya 4) in SAS Programming

How to resolve insufficient memory error in SAS Studio Flow (Viya 4)

mohammad_umair — Thu, 03 Apr 2025 06:12:21 GMT

Hi,

I am trying to load a manual upload into oracle table in SAS VIYA 4 environment.

The manual upload has 1048575 records and 148 columns.

I am getting insufficient memory error while executing this flow.

In the flow, i'm calling a .sas program which has data step and proc SQL with insert statement.

I tried increasing the maxTablemem value using proc cas, it works in the stand alone sas program, but the flow is failing.

Is there any way to increase memory size in the flow as well?

Re: How to resolve insufficient memory error in SAS Studio Flow (Viya 4)

LinusH — Thu, 03 Apr 2025 12:50:35 GMT

Is it the Oracle process or SAS compute exuction that fails?

Please share the log where the error occurs, and the statments used to load Oracle.

Re: How to resolve insufficient memory error in SAS Studio Flow (Viya 4)

mohammad_umair — Mon, 07 Apr 2025 05:49:53 GMT

Hi,

Attaching a screenshot of the error for your reference.

Re: How to resolve insufficient memory error in SAS Studio Flow (Viya 4)

LinusH — Mon, 07 Apr 2025 05:56:37 GMT

I wouldn't expect a memory error for an insert. And it seems to be the SAS session that fails. What is your MEMSIZE setting?
And BRANCH_MASER is not a view?If that's high enough, perhaps reach out to your system administrator to help trouble shoot the memory problem.
Maybe not related, consider bulk load for this type of operations, these are typically the fastest option. You can also explore the INSERTBUFF option (if you not already have done so, your LIBNAME statement could be helpful here).

Re: How to resolve insufficient memory error in SAS Studio Flow (Viya 4)

mohammad_umair — Mon, 07 Apr 2025 07:53:45 GMT

Hi,

Memsize is 2GB.

Branch_master is not a view.

Tried bulk loading but it is taking around 20 minutes.

Also, the error occurs in SAS Studio flow, not when I run the standalone program.

Will check with administrator regarding the memory.

Thanks.