Article - CS296365
AutoPilot processes fail with error "ORA-01652" / "ORA-01653" in Servigistics
Modified: 09-Sep-2024
Applies To
- Servigistics Service Parts Management 11.3.2 to 13.1.0.1
- Servigistics Service Parts Pricing 11.3.2 to 13.1.0.1
- Oracle Database
Description
- AutoPilot processes fail with errors like:
- ORA-01653: unable to extend table <table name> by <number> in tablespace <tablespace name>
- ORA-01652: unable to extend temp segment by <number> in tablespace <tablespace name>
- Multi-threaded Forecasting with Oracle Parallel set to 20 fails with error:
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01652: unable to extend temp segment by 1024 in tablespace TEMP
- SyncDB (Synchronize Database) fails with error:
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- GetHostData fails with error:
- ORA-01652: unable to extend temp segment by 128 in tablespace IPCS_DATA
- MEO Calculate Scenario fails with error:
- ORA-01652: unable to extend temp segment by 128 in tablespace IPCS_TEMP
- autopilot.log contains errors like:
ERROR com.svg.core.util.EventLog - Task Synchronize Database failed with message: StatementCallback; uncategorized SQLException for SQL [insert into IPCSTMP_G27723 select distinct pbf.PartID, pc.LocID from IPCS_PROV_BOM_FLAT pbf join IPCS_PROVISION p on pbf.ProvID=p.ProvID and p.Pr
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [insert into IPCSTMP_G27723 select distinct pbf.PartID, pc.LocID from IPCS_PROV_BOM_FLAT pbf join IPCS_PROVISION p on pbf.ProvID=p.ProvID and p.ProvStatusID > 2 and p.ProvStatusID != 99 join IPCS_PROV_PROD_ROLLOUT ppr on pbf.ProvID=ppr.ProvID and pbf.ProductID = ppr.ProductID join IPCS_PROV_COVG pc on pc.InstallSiteID=ppr.InstallSiteID and (pbf.InstallSiteID = pc.InstallSiteID or pbf.InstallSiteID = -1) and (pbf.ProductID=pc.ProductID or pc.ProductID = -1) and (pbf.PartID=pc.PartID or pc.PartID = -1) join IPCSTMP_G27714 sel on pc.LocID = sel.LocID where pbf.PartID <> -1 and not exists (select 1 from IPCSTMP_G27723 s where s.LocID=pc.LocID and s.PartID=pbf.PartID)]; SQL state [72000]; error code [1652]; ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
; nested exception is java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534)
at com.svg.core.process.syncdb.PreprocSelection.newValidPairsTable(PreprocSelection.java:238)
at com.svg.core.process.syncdb.PreprocSelection.process(PreprocSelection.java:23)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:34)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:95)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92)
at com.svg.core.process.syncdb.SyncConnector.doProcessSubTask(SyncConnector.java:225)
at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:26)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:34)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:95)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92)
at com.svg.core.task.SubTask.runConnector(SubTask.java:104)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:216)
at com.svg.core.task.SubTask.run(SubTask.java:86)
at sun.reflect.GeneratedMethodAccessor340.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy708.run(Unknown Source)
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:434)
at java.lang.Thread.run(Thread.java:748)
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [insert into IPCSTMP_G27723 select distinct pbf.PartID, pc.LocID from IPCS_PROV_BOM_FLAT pbf join IPCS_PROVISION p on pbf.ProvID=p.ProvID and p.ProvStatusID > 2 and p.ProvStatusID != 99 join IPCS_PROV_PROD_ROLLOUT ppr on pbf.ProvID=ppr.ProvID and pbf.ProductID = ppr.ProductID join IPCS_PROV_COVG pc on pc.InstallSiteID=ppr.InstallSiteID and (pbf.InstallSiteID = pc.InstallSiteID or pbf.InstallSiteID = -1) and (pbf.ProductID=pc.ProductID or pc.ProductID = -1) and (pbf.PartID=pc.PartID or pc.PartID = -1) join IPCSTMP_G27714 sel on pc.LocID = sel.LocID where pbf.PartID <> -1 and not exists (select 1 from IPCSTMP_G27723 s where s.LocID=pc.LocID and s.PartID=pbf.PartID)]; SQL state [72000]; error code [1652]; ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
; nested exception is java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:415)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534)
at com.svg.core.process.syncdb.PreprocSelection.newValidPairsTable(PreprocSelection.java:238)
at com.svg.core.process.syncdb.PreprocSelection.process(PreprocSelection.java:23)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:34)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:95)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92)
at com.svg.core.process.syncdb.SyncConnector.doProcessSubTask(SyncConnector.java:225)
at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:26)
at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:110)
at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:34)
at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:95)
at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:92)
at com.svg.core.task.SubTask.runConnector(SubTask.java:104)
at com.svg.core.task.AbstractTask.run(AbstractTask.java:216)
at com.svg.core.task.SubTask.run(SubTask.java:86)
at sun.reflect.GeneratedMethodAccessor340.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
at com.sun.proxy.$Proxy708.run(Unknown Source)
at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:434)
at java.lang.Thread.run(Thread.java:748)
at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ERROR: com.svg.core.database.StandardJdbcTemplate$UnknownDataAccessException: ORA-01652: unable to extend temp segment by 128 in tablespace IPCS_DATA
This is a printer-friendly version of Article 296365 and may be out of date. For the latest version click CS296365