Problem Note 61212: A "java.sql.SQLException: ORA-01000: maximum open cursors exceeded" exception might occur when you open the Promotion List view
In SAS® Promotion Optimization, the following exception might occur after you open the Promotion List view:
FATAL Worker-2 java.lang.StackTraceElement - java.sql.SQLException: ORA-01000: maximum open cursors exceeded
com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at com.sas.solutions.di.server.rpp.PromotionPlanImpl.loadOptEvalLogCount(PromotionPlanImpl.java:3511)
at com.sas.solutions.di.server.rpp.PromotionPlanImpl.loadOptEvalLogCount(PromotionPlanImpl.java:3393)
at com.sas.solutions.di.server.rpp.PromotionPlanImpl.initialize(PromotionPlanImpl.java:3051)
at com.sas.solutions.di.server.rpp.NamedScopedValueImpl.initialize(NamedScopedValueImpl.java:759)
at com.sas.solutions.di.server.rpp.PromotionPlanImpl.getPromotionPlanImpls(PromotionPlanImpl.java:512)
at com.sas.solutions.di.server.rpp.PromotionPlanImpl.getPromotionPlans(PromotionPlanImpl.java:412)
at com.sas.solutions.di.server.rpp.RPPServiceImpl.getPromotionPlans(RPPServiceImpl.java:696)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
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)
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 | Microsoft® Windows® for x64 | 5.4 | | 9.4 TS1M4 | |
Linux for x64 | 5.4 | | 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2017-11-03 12:35:57 |
Date Created: | 2017-10-09 09:57:54 |