SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 46274: Mid-tier runs out of memory

DetailsHotfixAboutRate It

The SAS® Pack Optimization mid-tier might generate a Java out of memory error similar to the one that follows:

[WebContainer : 120-6256] RROR [] com.sas.solutions.di.server - Exception thrown during the invocation of method getPurchaseOrders.
java.lang.OutOfMemoryError
	at com.sas.rio.RIOUtil.getColumnInfo(RIOUtil.java:817)
	at com.sas.rio.MVARowCache.init(MVARowCache.java:1878)
	at com.sas.rio.MVARowCache.(MVARowCache.java:209)
	at com.sas.rio.MVAResultSet.(MVAResultSet.java:389)
	at com.sas.rio.MVAStatement.executeQuery(MVAStatement.java:579)
	at com.sas.rio.MVAPreparedStatement.executeQuery(MVAPreparedStatement.java:104)

This error occurs because the list of purchase order plans is loaded into memory before being filtered by your permission scope. If you turn off filtering all plans will be loaded into memory, which might cause an out of memory condition.

There is no workaround for this issue.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Pack OptimizationMicrosoft Windows Server 2003 Datacenter Edition2.2_M13.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition2.2_M13.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition2.2_M13.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 for x642.2_M13.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 20082.2_M13.29.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x642.2_M13.29.2 TS2M39.3 TS1M0
64-bit Enabled AIX2.2_M13.29.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.