Problem Note 52005: An "Unable to execute query..." exception occurs when you attempt to approve prices in SAS® Regular Price Optimization
The following exception might occur when you attempt to approve prices in SAS Regular Price Optimization:
FATAL Worker-8 java.lang.StackTraceElement - java.sql.SQLException: Unable to execute query: Request failed due to an exception.
com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLException: Unable to execute query: Request failed due to an exception.
at com.sas.solutions.di.server.rpp.PromotionPlanReleaseHelper.getPrices(PromotionPlanReleaseHelper.java:545)
at com.sas.solutions.di.server.rpp.PromotionPlanReleaseHelper.getPrices(PromotionPlanReleaseHelper.java:276)
at com.sas.solutions.di.server.rpp.PricingServiceImpl.getPrices(PricingServiceImpl.java:69)
at com.sas.solutions.di.server.rpp.PricingServiceImpl.getPrices(PricingServiceImpl.java:49)
at com.sas.solutions.di.server.rpp.RPPServiceImpl.getPrices(RPPServiceImpl.java:987)
at com.sas.solutions.di.server.rpo.ProductLocationService.getProductPricesOnPromotion(ProductLocationService.java:522)
at com.sas.solutions.di.server.rpo.RPOPlanningService.getExternalPriceInfo(RPOPlanningService.java:7920)
at com.sas.solutions.di.server.rpo.RPOPlanningService.savePlanMemberSummaries(RPOPlanningService.java:659)
at com.sas.solutions.di.server.rpo.RPOPlanningService.saveRegularPricePlanEx(RPOPlanningService.java:310)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
...
This issue occurs when both SAS Regular Price Optimization and SAS® Promotion Optimization are implemented in a single environment.
There is no workaround for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M3 | 5.2_M4 | 9.3 TS1M2 | 9.3 TS1M2 |
Linux 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-01-14 09:03:37 |
Date Created: | 2014-01-09 08:47:40 |