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
|
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
|
*
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.
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
This content is presented in an iframe, which your browser does not support.
To view the RateIT tab, click
here.
