SUPPORT / SAMPLES & SAS NOTES
Problem Note 51700: Evaluation of a promotion that fails might incorrectly not contain a hyperlink with error details in the Promotion Details view
 |  |  |  |  |
In SAS® Promotion Optimization, an evaluation that fails might incorrectly not contain a hyperlink with error details in the Promotion Details view. This issue occurs in promotions that contain more than 1000 products. Even though no error message details are displayed in the Promotion Details view, errors similar to the following are generated in the MerchIntelGridSvr.log:
*
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.
2013-11-08 09:08:55,851 [RequestThread-130808] ERROR Execute - FATAL ERROR - Requested Operation FAILED
com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at com.sas.solutions.di.server.db.SQLHandler.execute(SQLHandler.java:117)
at com.sas.solutions.di.server.db.SQLHandler.execute(SQLHandler.java:124)
at com.sas.solutions.di.tkmiserver.rpp.eval.OptEvalHelper.getPartitionedProductSet(OptEvalHelper.java:82)
at com.sas.solutions.di.tkmiserver.rpp.ExecuteOptEval.run(ExecuteOptEval.java:108)
at com.sas.solutions.di.tkmiserver.rpp.Execute.execute(Execute.java:75)
at com.sas.solutions.di.tkmiserver.rpp.RPPTkService.optEval(RPPTkService.java:110)
at com.sas.solutions.di.tkmiserver.rpp.RPPTkService.optEval(RPPTkService.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sas.solutions.di.tkmiserver.dispatcher.JavaDispatcher.run(JavaDispatcher.java:122)
at com.sas.solutions.di.tkmiserver.dispatcher.RequestDispatcher.run(RequestDispatcher.java:50)
at com.sas.solutions.di.tkmiserver.request.RequestServiceImpl.doRunRequest(RequestServiceImpl.java:1040)
at com.sas.solutions.di.tkmiserver.request.RequestThread.doRun(RequestThread.java:177)
at com.sas.solutions.di.tkmiserver.request.RequestThread.run(RequestThread.java:139)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
...
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 Promotion Optimization | Linux for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 | ||