Problem Note 50862: "java.lang.StackTraceElement - Could not execute JDBC batch update..." might be generated
The following exception might be generated in SAS® Promotion Optimization when attempting to approve a promotion or run a business rule check on a promotion:
FATAL Worker-3 java.lang.StackTraceElement - Could not execute JDBC batch update
org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
at com.sas.solutions.di.server.db.PersistenceManager.endHiberateTxn(PersistenceManager.java:846)
at com.sas.solutions.di.server.db.PersistenceManager.commit(PersistenceManager.java:730)
at com.sas.solutions.di.server.util.Interceptors.privateInvoke(Interceptors.java:171)
at com.sas.solutions.di.server.spring.SpringServer.invoke(SpringServer.java:170)
at com.sas.solutions.di.server.spring.SessionRemoteInvocationExecutor.invoke(SessionRemoteInvocationExecutor.java:46)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:662)
at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:47)
at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)
at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)
at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:148)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy19.save(Unknown Source)
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.server.api.ServerProxy.invoke(ServerProxy.java:60)
at $Proxy20.save(Unknown Source)
at com.sas.solutions.di.studio.rpp.jobs.plan.UpdateSinglePromotionPlanJob.savePlan(UpdateSinglePromotionPlanJob.java:34)
at com.sas.solutions.di.studio.rpp.jobs.plan.UpdateSinglePromotionPlanJob.saveItems(UpdateSinglePromotionPlanJob.java:28)
at com.sas.solutions.di.studio.rpp.jobs.plan.UpdatePromotionPlanJob.execute(UpdatePromotionPlanJob.java:51)
at com.sas.solutions.di.commons.jobs.AbstractJob.internalExecute(AbstractJob.java:454)
at com.sas.solutions.di.commons.jobs.AbstractJob.run(AbstractJob.java:420)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "DI_DM"."RPP_PLAN_OPT_SETTING"."OPT_PARM_VALUE" (actual: 83, maximum: 20)
The exception is generated when a promotion contains a product whose product ID is greater than 20 characters.
Contact Technical Support for a workaround for this issue.
A fix for this issue is planned for a future software release.
Operating System and Release Information
SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M2 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
Linux for x64 | 5.2_M2 | 5.4 | 9.3 TS1M2 | 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: | 2018-02-28 12:02:04 |
Date Created: | 2013-08-26 15:30:20 |