SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 61166: %TKMI_JOB_RO etl_end_service generates "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP"

DetailsHotfixAboutRate It

The SAS® Promotion Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log file:

<YYYY-MM-DD HH:MM:SS,sss> [http-bio-<port>-exec-<n>-<n>] ERROR com.sas.solutions.di.server.spring.SpringServer - Exception thrown during the invocation of method etlEnd.

com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

at com.sas.solutions.di.tkmiserver.rpp.AbstractHelper.getScope(AbstractHelper.java:1912)

at com.sas.solutions.di.tkmiserver.rpp.RPPTkService.initCommonMetricsProcess(RPPTkService.java:1186)

at com.sas.solutions.di.tkmiserver.rpp.RPPTkService.initCommonMetricsProcess(RPPTkService.java:1162)

at com.sas.solutions.di.tkmiserver.data.DataServiceImpl.etlEnd(DataServiceImpl.java:6878)

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.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)

at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)

at com.sas.solutions.di.server.spring.SessionRemoteInvocationExecutor.invokeSuper(SessionRemoteInvocationExecutor.java:69)

at com.sas.solutions.di.server.spring.SpringServer$SpringPrivateInvoker.privateInvoke(SpringServer.java:144)

at com.sas.solutions.di.server.util.Interceptors.privateInvoke(Interceptors.java:167)

at com.sas.solutions.di.server.spring.SpringServer.invoke(SpringServer.java:176)

at com.sas.solutions.di.server.spring.SessionRemoteInvocationExecutor.invoke(SessionRemoteInvocationExecutor.java:46)

at com.sas.solutions.di.server.soap.SpringProvider.invokeMethod(SpringProvider.java:178)

at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:283)

at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)

at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)

at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)

at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)

at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)

at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)

at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

at com.sas.solutions.di.server.db.SQLHandler.executeQuery(SQLHandler.java:80)

at com.sas.solutions.di.tkmiserver.rpp.AbstractHelper.getScope(AbstractHelper.java:1712)

... 45 more

The workaround for this issue is to set DI_TRANS.RPP_PLAN.EVAL_OPT_REQ_CD to 0 for all promotion plans.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Promotion OptimizationMicrosoft® Windows® for x645.49.4 TS1M4
Linux for x645.49.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.