Problem Note 56640: An "ORA-00936: missing expression..." error might occur in SAS® Pack Optimization
 |  |  |  |  |
The following error might occur when opening the Optimization Results tab in SAS Pack Optimization:
Error org.springframework.remoting.support.RemoteInvocationTraceInterceptor - Processing of HttpInvokerServiceExporter remote call resulted in
fatal exception: com.sas.solutions.di.server.dm.api.LocationService.getCustomAttributeValues
com.sas.solutions.di.server.db.api.PersistenceException: ORA-00936: missing expression
at com.sas.solutions.di.server.dm.AttributeServiceBase.getCustomAttributeValues(AttributeServiceBase.java:541)
at com.sas.solutions.di.server.dm.AttributeServiceBase.getCustomAttributeValues(AttributeServiceBase.java:436)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
......
The error occurs when there are no geography attributes loaded into the data mart.
Click 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 Pack Optimization | Microsoft Windows Server 2008 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 |
| Linux for x64 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#56640| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-02-28 13:25:33 |
| Date Created: | 2015-09-22 12:29:54 |