IBM Support

Global transaction timeout error when content packs of object models are loaded into the Common database

Troubleshooting


Problem

During startup of WebSphere Process Server or WebSphere Enterprise Service Bus (WebSphere ESB), a global transaction timeout error can occur as the content packs of object models are loaded into the Common database repository.

Symptom

The following exception is written in SystemOut.log:

ContentPackIn E com.ibm.ws.fabric.support.g11n.logging.DelegatingLog error Content import failed, rolling back to : 1

com.ibm.ws.repository.ocp.ContentImportException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.RollbackException: Global transaction timed out after 0 seconds
at com.ibm.ws.repository.ocp.model.SchemaOwlContent.install(SchemaOwlContent.java:73)
at com.ibm.ws.repository.ocp.ContentImportVisitor.visit(ContentImportVisitor.java:58)
at com.ibm.ws.repository.ocp.model.OntologyContent.accept(OntologyContent.java:70)
at com.ibm.ws.repository.ocp.model.NamespaceContent.accept(NamespaceContent.java:33)
at com.ibm.ws.repository.ocp.model.ProjectContent.accept(ProjectContent.java:38)
at com.ibm.ws.repository.ocp.model.GovernedContent.accept(GovernedContent.java:43)
at com.ibm.ws.repository.ocp.model.ContentPackage.accept(ContentPackage.java:44)
at com.ibm.ws.repository.ocp.ContentPackInstaller.installContentInStore(ContentPackInstaller.java:351)
at com.ibm.ws.repository.ocp.ContentPackInstaller.installInternal(ContentPackInstaller.java:153)
at com.ibm.ws.repository.ocp.ContentPackInstaller.install(ContentPackInstaller.java:84)
at com.ibm.ws.repository.ocp.bootstrap.InstallContentPacks.execute(InstallContentPacks.java:74)
at com.ibm.ws.repository.ocp.api.OcpSubsystem.installInternal(OcpSubsystem.java:57)
at com.ibm.ws.repository.ocp.api.OcpSubsystem.bootstrap(OcpSubsystem.java:38)
at com.ibm.ws.repository.impl.PopulateRepository.populateInternal(PopulateRepository.java:86)
at com.ibm.ws.repository.impl.PopulateRepository.access$000(PopulateRepository.java:34)
at com.ibm.ws.repository.impl.PopulateRepository$1.call(PopulateRepository.java:71)
at com.ibm.ws.repository.impl.PopulateRepository$1.call(PopulateRepository.java:70)
at com.ibm.ws.repository.impl.ThreadingUtils.runWithContextLoader(ThreadingUtils.java:31)
at com.ibm.ws.repository.impl.PopulateRepository.execute(PopulateRepository.java:67)
at com.ibm.ws.repository.osgi.RepositoryUtil.processContent(RepositoryUtil.java:646)
at com.ibm.ws.repository.osgi.RepositoryUtil.processCartridges(RepositoryUtil.java:629)
at com.ibm.ws.repository.osgi.RepositoryUtil.getBootstrappedRepositoryInternal(RepositoryUtil.java:605)
at com.ibm.ws.repository.osgi.RepositoryUtil.access$400(RepositoryUtil.java:48)
at com.ibm.ws.repository.osgi.RepositoryUtil$5.run(RepositoryUtil.java:583)
at com.ibm.ws.repository.osgi.RepositoryUtil$5.run(RepositoryUtil.java:582)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.repository.osgi.RepositoryUtil.getBootstrappedRepository(RepositoryUtil.java:581)
at com.ibm.ws.repository.osgi.RepositoryUtil.getBootstrappedRepositoryInternal(RepositoryUtil.java:568)
at com.ibm.ws.repository.osgi.RepositoryUtil.access$300(RepositoryUtil.java:48)
at com.ibm.ws.repository.osgi.RepositoryUtil$4.run(RepositoryUtil.java:550)
at com.ibm.ws.repository.osgi.RepositoryUtil$4.run(RepositoryUtil.java:549)
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ws.repository.osgi.RepositoryUtil.getBootstrappedRepository(RepositoryUtil.java:548)
at com.ibm.bpmspi.repository.RepositoryFactory.getRepository(RepositoryFactory.java:85)
at com.ibm.wbiserver.security.auth.repository.DBManagerImpl.setupJ2EE(DBManagerImpl.java:140)
at com.ibm.wbiserver.security.auth.repository.DBManagerImpl.<init>(DBManagerImpl.java:72)
at com.ibm.wbiserver.security.auth.repository.RolesDBManagerImpl.<init>(RolesDBManagerImpl.java:82)
at com.ibm.wbiserver.security.auth.repository.DBManagerFactory.getRolesDBManager(DBManagerFactory.java:58)
at com.ibm.wbiserver.security.auth.startup.SecurityComponentImpl.isBPMAdminRoleMapped(SecurityComponentImpl.java:101)
at com.ibm.wbiserver.security.auth.startup.SecurityComponentImpl.start(SecurityComponentImpl.java:58)
at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:977)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:673)
at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:191)
at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:977)
at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:673)
at com.ibm.ws.runtime.component.ServerImpl.start(ServerImpl.java:526)
at com.ibm.ws.runtime.WsServerImpl.bootServerContainer(WsServerImpl.java:192)
at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:140)
at com.ibm.ws.runtime.WsServerImpl.main(WsServerImpl.java:461)
at com.ibm.ws.runtime.WsServer.main(WsServer.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.ibm.wsspi.bootstrap.WSLauncher.launchMain(WSLauncher.java:183)
at com.ibm.wsspi.bootstrap.WSLauncher.main(WSLauncher.java:90)
at com.ibm.wsspi.bootstrap.WSLauncher.run(WSLauncher.java:72)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336)
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at com.ibm.wsspi.bootstrap.WSPreLauncher.launchEclipse(WSPreLauncher.java:336)
at com.ibm.wsspi.bootstrap.WSPreLauncher.main(WSPreLauncher.java:91)
Caused by: org.springframework.transaction.TransactionSystemException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.RollbackException: Global transaction timed out after 0 seconds
at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:259)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:123)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy4.applyChangesUnconditionally(Unknown Source)
at com.webify.wsf.triples.store.TripleStoreImpl.internalReplaceNamespace(TripleStoreImpl.java:846)
at com.webify.wsf.triples.store.TripleStoreImpl.replaceNamespace(TripleStoreImpl.java:224)
at com.webify.wsf.modelstore.impl.OwlAwareDelegate.replaceNamespace(OwlAwareDelegate.java:158)
at com.webify.wsf.modelstore.impl.OwlAwareDelegate.replaceNamespace(OwlAwareDelegate.java:173)
at com.webify.wsf.modelstore.impl.SimpleModelAccessImpl.replaceNamespace(SimpleModelAccessImpl.java:336)
at com.ibm.tyto.governance.UngovernedChangeSession.replaceSchemaNamespace(UngovernedChangeSession.java:59)
at com.ibm.ws.repository.ocp.model.SchemaOwlContent.install(SchemaOwlContent.java:70)
... 70 more
Caused by: com.ibm.wsspi.uow.UOWException: javax.transaction.RollbackException: Global transaction timed out after 0 seconds
at com.ibm.ws.uow.UOWManagerImpl.runUnderNewUOW(UOWManagerImpl.java:980)
at com.ibm.ws.uow.UOWManagerImpl.runUnderUOW(UOWManagerImpl.java:509)
at org.springframework.transaction.jta.WebSphereUowTransactionManager.execute(WebSphereUowTransactionManager.java:252)
... 81 more
Caused by: javax.transaction.RollbackException: Global transaction timed out after 0 seconds
at com.ibm.ws.uow.UOWManagerImpl.uowEnd(UOWManagerImpl.java:1018)
at com.ibm.ws.uow.UOWManagerImpl.runUnderNewUOW(UOWManagerImpl.java:975)
... 83 more

Cause

When WebSphere Process Server or WebSphere ESB V6.2 is first started, content packs of object models are loaded into the repository. The load requires numerous reads from and writes to the Common database. In environments that have a remote database or are under a heavy load, the interaction with the Common database can take longer than the default transaction timeout value of the server (120 seconds).

Note: The error message is incorrect; the default timeout value is 120 seconds, not 0.

Environment

WebSphere Process Server and WebSphere ESB V6.2

Diagnosing The Problem

Search the SystemOut.log file for the following exception message: com.ibm.ws.repository.ocp.ContentImportException: UOWManager transaction processing failed; nested exception is com.ibm.wsspi.uow.UOWException: javax.transaction.RollbackException: Global transaction timed out after 0 seconds

Resolving The Problem

To resolve the problem, increase the transaction timeout value for the server in which the exception occurs. Refer to the "Transaction service settings" topic in the WebSphere Application Server V6.1 Information Center for information about modifying the total transaction lifetime timeout value:
https://www.ibm.com/support/knowledgecenter/SS7JFU_7.0.0/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/udat_contranserv.html.

[{"Product":{"code":"SSQH9M","label":"WebSphere Process Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Security","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"},{"code":"PF012","label":"IBM i"}],"Version":"7.0;6.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21330852