SUPPORT / SAMPLES & SAS NOTES
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)
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.4 | 9.4 TS1M4 | ||
| Linux for x64 | 5.4 | 9.4 TS1M4 | ||||