My Oracle Support Banner

RepositoryException And "Transaction is not active" Error When Importing a Spreadsheet File (Doc ID 2236375.1)

Last updated on FEBRUARY 28, 2017

Applies to:

Oracle Commerce Platform - Version 9.4 to 11.2 [Release 9 to 11]
Information in this document applies to any platform.

Symptoms

When there is a RepositoryException during import, future uses of the same thread will result in a transaction error.
 
RepositoryException
---------------------------

**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService --- atg.repository.RepositoryException: createItem() was called with an existing ID : '700001' for type 'errorMessages'. Use getItemForUpdate() instead.
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.adapter.version.VersionRepository.createItem(VersionRepository.java:1958)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.adapter.version.VersionRepository.createItem(VersionRepository.java:1203)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.adapter.secure.GenericSecuredMutableRepository.createItem(GenericSecuredMutableRepository.java:315)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.editor.service.RepositoryAssetServiceImpl.copyItemWithNewId(RepositoryAssetServiceImpl.java:1065)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.editor.service.RepositoryAssetServiceImpl.doAddAsset(RepositoryAssetServiceImpl.java:824)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.editor.service.AssetServiceImpl.addAsset(AssetServiceImpl.java:603)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.transfer.service.ImportEngine.importSingleAsset(ImportEngine.java:437)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.transfer.service.ImportEngine.importAssets(ImportEngine.java:265)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at atg.remote.assetmanager.transfer.service.TransferService.performImport(TransferService.java:599)
**** Error Thu Nov 17 09:49:49 CST 2016 1479397789698 /atg/dynamo/servlet/pipeline/RequestScopeManager/RequestScope-45/atg/remote/assetmanager/editor/service/RepositoryAssetService at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Here are some exampes of transaction errors:

2014-06-19 10:38:45,466 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/FlexUI].[MessageBrokerServlet]] (ajp-oses4129%2F161.169.111.37-20309-9) Servlet.service() for servlet MessageBrokerServlet threw exception
javax.ejb.EJBException: QUERY_EXCEPTION_MESSAGE: RQL query: id = ?0, Args:?0=prj2018054

at atg.repository.tojava.runtime.RJSupport.executeRqlStatementForOne(RJSupport.java:1132)
at atg.epub.project._ProjectHome_ReposImpl.findById(_ProjectHome_ReposImpl.java:71)
at atg.epub.servlet.VersioningLayerTools.isProjectAccessible(VersioningLayerTools.java:969)
at atg.epub.servlet.VersioningLayerTools.ensureProjectInSession(VersioningLayerTo ols.java:306)
at atg.epub.servlet.VersioningLayerTools.setProjectContext(VersioningLayerTools.java:217)
at atg.epub.servlet.ProjectServlet.prePassRequest(ProjectServlet.java:159)
....
Caused by: CONTAINER:atg.repository.RepositoryException; SOURCE:org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -5e5690db:c922:53a2931f:1201b36 status: ActionStatus.ABORT_ONLY >; - nested throwable:(javax.resource.ResourceException: Transaction is not active:tx=TransactionImple < ac, BasicAction: -5e5690db:c922:53a2931f:1201b36status: ActionStatus.ABORT_ONLY >)
at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:8347)
at atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:362)
at atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:465)
at atg.repository.RepositoryViewImpl.executeQuery(RepositoryViewImpl.java:368)
at atg.adapter.gsa.GSAView.executeQuery(GSAView.java:307)
at atg.adapter.secure.GenericSecuredRepositoryView.executeQuery(GenericSecuredRepositoryView.java:413)
at atg.repository.rql.RqlStatement.executeQuery(RqlStatement.java:227)
at atg.repository.tojava.runtime.RJSupport.executeRqlStatementForOne(RJSupport.java:1121)

 

 2014-06-19 10:38:57,671 ERROR [nucleusNamespace.atg.userprofiling.InternalDPSMessageSource] (ajp-oses4129%2F161.169.111.37-20309-9 requestURI=/atg/templates/page/html/includes/noop.jsp jsessionid=A476E99EB75778E881BE90EF150D557E.4129-ca3 remoteAddr=10.57.151.136 userid=iuser14800049)javax.jms.JMSException: A transaction-related exception occurred while trying to obtain a JMS Session from provider "local": javax.transaction.RollbackException:
[com.arjuna.ats.internal.jta.transaction.arjunacore.syncwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.syncwhenaborted] Can't register synchronization because the transaction is in aborted state

at atg.dms.patchbay.SessionManager.getSession(SessionManager.java:212)
at atg.dms.patchbay.Provider.getTopicSession(Provider.java:656)

at atg.dms.patchbay.OutputDestination.getPooledSession(OutputDestination.java:286)
at atg.dms.patchbay.OutputPort.getPooledSession(OutputPort.java:178)
at atg.dms.patchbay.ElementManager.createObjectMessage(ElementManager.java:804)
at atg.dms.patchbay.ElementManager.createObjectMessage(ElementManager.java:527)
at atg.nucleus.dms.DASMessageSource.fireObjectMessage(DASMessageSource.java:225)
at atg.nucleus.dms.DASMessageSource.fireObjectMessage(DASMessageSource.java:194)
at atg.userprofiling.dms.DPSMessageSource.firePageVisitMessage(DPSMessageSource.java:583)
at atg.userprofiling.dms.DPSMessageSource.firePageVisitMessage(DPSMessageSource.java:569)
at atg.userprofiling.PageEventTrigger.sendPageViewedEvent(PageEventTrigger.java:967)
at atg.userprofiling.PageEventTrigger.sendPageViewedEvent(PageEventTrigger.java:917)
at atg.userprofiling.PageEventTrigger.sendPageViewedEvent(PageEventTrigger.java:865)
at atg.userprofiling.PageEventTriggerPipelineServlet.service(PageEventTriggerPipelineServlet.java:188)
at atg.servlet.pipeline.PipelineableServletImpl.passRequest(PipelineableServletImpl.java:157)
at atg.multisite.SiteSessionEventTriggerPipelineServlet.service(SiteSessionEventTriggerPipelineServlet.java:161)

 

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
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.