Executing a Base SAS® procedure against an Oracle table results in "ERROR:The SAS System stopped processing this step because of insufficient memory"


Running a FREQ, RANK, REPORT, SORT, SUMMARY/MEANS, or TABULATE procedure against an Oracle table might result in the following error:

ERROR: The SAS System stopped processing this step because of insufficient memory

This problem occurs when your Oracle password is in the warning period.

There are two workarounds for this issue. One workaround is to use a password that is not in the warning period. Another workaround is to turn off SAS procedures that are enabled for in-database processing from generating SQL for in-database processing for Oracle, as shown here:

options SQLGENERATION=(NONE DBMS='TERADATA DB2 NETEZZA ASTER GREENPLM HADOOP SAPHANA IMPALA HAWQ POSTGRES REDSHIFT SQLSVR VERTICA');