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:
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
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 |
*
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.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2014-02-11 13:23:30 |
Date Created: | 2013-11-25 15:27:36 |