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

[mohammad_umair]

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?

[LinusH]

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.

[mohammad_umair]

Hi,

Attaching a screenshot of the error for your reference. 

[LinusH]

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).

[mohammad_umair]

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.