SUPPORT / SAMPLES & SAS NOTES
Problem Note 34673: An 'OutOfMemoryError' might be encountered if you execute large queries containing modeling formulas
 |  |  |  |  |
In SAS® Financial Management, if you submit a large query that contains modeling formulas, an OutOfMemory error might occur.
An error similar to the following might appear in the SAS ODCS Server log:
<ExecuteThread: '19' for queue: 'sas.solutions.odcs.webservices'> <<anonymous>> <BEA1-0857E8E7820A8CCE6B1A> <BEA-010051> <EJB Exception occurred during invocation from home: com.sas.solutions.odcs.ejb.ExcelService_ez6n0s_HomeImpl@778590 threw exception: javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: com.sas.solutions.odcs.client.ODCSRuntimeException: java.lang.OutOfMemoryError javax.ejb.TransactionRolledbackLocalException: EJB Exception: ; nested exception is: com.sas.solutions.odcs.client.ODCSRuntimeException: java.lang.OutOfMemoryError com.sas.solutions.odcs.client.ODCSRuntimeException: java.lang.OutOfMemoryError at com.sas.solutions.odcs.dispatcher.QueryManager.dispatch (QueryManager.java:256)
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft Windows 2000 Advanced Server | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 4.4 | 4.5 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||