My Oracle Support Banner

ATO Stucks Forever (Doc ID 2592820.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Agile PLM Framework - Version 9.3.5.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavoir

ATO is stuck

Expected Behavior

ATO should be completed soon

Steps

The issue can be reproduced at will with the following steps:
1. Release ATO
2. ATO in Release status and Where Sent tab shows it is in Extracting progress, but never completes

Server Log

java.sql.SQLException: Transaction not active anymore. tx status = Rolled back. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 7202 seconds]
    at weblogic.jdbc.jts.Driver.getTransaction(Driver.java:556)
    at weblogic.jdbc.jts.Driver.connect(Driver.java:113)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:589)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538)
    at com.agile.util.sql.DefaultConnectionFactory.getConnFromDS(DefaultConnectionFactory.java:84)
    at com.agile.util.sql.DefaultConnectionFactory.getJDBCConnection(DefaultConnectionFactory.java:48)
    at com.agile.util.sql.ConnectionFactory.getConnection(ConnectionFactory.java:37)
    at com.agile.pc.cmserver.base.CMObjectCacheManager.createObjectCache(CMObjectCacheManager.java:1514)
    at com.agile.pc.cmserver.base.CMObjectCacheManager.getObjectCache(CMObjectCacheManager.java:227)
    at com.agile.pc.cmserver.base.ObjectAgent.getObjectCache(ObjectAgent.java:160)
    at com.agile.pc.cmserver.base.BaseServiceTable.marshalTable(BaseServiceTable.java:1193)
    at com.agile.pc.cmserver.base.BaseServiceTable.marshalTable(BaseServiceTable.java:1182)
    at com.agile.pc.cmserver.outbound.OutPackageService.marshalTable(OutPackageService.java:230)
    at com.agile.acs.PCExtractTask.tmpExtractionProcess(PCExtractTask.java:835)
    at com.agile.acs.PCExtractTask.run(PCExtractTask.java:458)
    at java.util.TimerThread.mainLoop(Timer.java:555)


ORA-01013: user requested cancel of current operation
java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1270)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:141)
    at com.agile.admin.metadata.BatchedPreparedStatement.executeQuery(BatchedPreparedStatement.java:635)
    at com.agile.common.server.dao.BaseDAO.executeQuery(BaseDAO.java:518)
    at com.agile.common.server.dao.ItemDAO.getBomCount(ItemDAO.java:601)
    at com.agile.common.server.bo.handler.ItemHandler.getBomCountForItems(ItemHandler.java:2397)
    at com.agile.common.server.bo.BOHome.getBomCountForItems(BOHome.java:714)
    at com.agile.extract.server.ExtractService.getItemObjectCount(ExtractService.java:2778)
    at com.agile.extract.server.ExtractService.getBomSize(ExtractService.java:2792)
    at com.agile.extract.server.ExtractService.isTreeTooLarge(ExtractService.java:2800)
    at com.agile.extract.server.AXMLService.processExport92(AXMLService.java:420)
    at com.agile.extract.server.ExtractService.processExport(ExtractService.java:388)
    at com.agile.extract.server.ExtractService.extract(ExtractService.java:338)
    at com.agile.acs.PCExtractTask$ExtractAction.run(PCExtractTask.java:2027)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    at weblogic.security.Security.runAs(Security.java:41)
    at com.agile.admin.vendor.weblogic.WeblogicServerAdapter.doAs(WeblogicServerAdapter.java:267)
    at com.agile.acs.PCExtractTask.tmpProcessWS(PCExtractTask.java:1387)
    at com.agile.acs.PCExtractTask.tmpExtractionProcess(PCExtractTask.java:774)
    at com.agile.acs.PCExtractTask.run(PCExtractTask.java:458)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)




Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.