In CM1, when attempting to approve a page we receive the following error: “Failed transition due to server error.” We have restarted the Percussion services and still receive the same error. This is only occurring on a few pages. We are able to approve others without issues.
Found this information in our log files:
2013-04-24 09:27:02,388 ERROR [PSVelocityAssembler] Problem assembling output for item (name=“index.html”, id=61-101-314) with template: perc.widget.
javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:303)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
at com.percussion.services.contentmgr.impl.legacy.PSContentRepository.o00000(Unknown Source)
at com.percussion.services.contentmgr.impl.legacy.PSContentRepository.loadByGUID(Unknown Source)
at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy107.loadByGUID(Unknown Source)
at com.percussion.services.contentmgr.impl.PSContentMgr.findItemsByGUID(Unknown Source)
at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy108.findItemsByGUID(Unknown Source)
at com.percussion.services.assembly.data.PSAssemblyWorkItem.getNode(Unknown Source)
at com.percussion.pagemanagement.assembler.impl.PSAssemblyItemBridge.createRenderAsset(PSAssemblyItemBridge.java:291)
at com.percussion.pagemanagement.assembler.PSPageUtils.toAsset(PSPageUtils.java:1055)
at com.percussion.pagemanagement.assembler.PSPageUtils.toAssets(PSPageUtils.java:1048)
at com.percussion.pagemanagement.assembler.PSPageUtils.widgetContents(PSPageUtils.java:471)
at com.percussion.pagemanagement.assembler.PSPageUtils.widgetContents(PSPageUtils.java:335)
at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252)
at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:493)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:155)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:332)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212)
at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
at org.apache.velocity.Template.merge(Template.java:328)
at org.apache.velocity.Template.merge(Template.java:235)
at com.percussion.services.assembly.impl.plugin.PSVelocityAssembler.assembleSingle(Unknown Source)
at com.percussion.services.assembly.impl.plugin.PSAssemblerBase.doAssembleSingle(Unknown Source)
at com.percussion.services.assembly.impl.plugin.PSVelocityAssembler.doAssembleSingle(Unknown Source)
at com.percussion.services.assembly.impl.plugin.PSAssemblerBase$_b.o00000(Unknown Source)
at com.percussion.services.assembly.impl.plugin.PSAssemblerBase.assemble(Unknown Source)
at com.percussion.services.assembly.impl.PSAssemblyService.super(Unknown Source)
at com.percussion.services.assembly.impl.PSAssemblyService.assemble(Unknown Source)
at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy96.assemble(Unknown Source)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assemblyWidget(PSPageAssemblyContextFactory.java:449)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgets(PSPageAssemblyContextFactory.java:434)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgetRegion(PSPageAssemblyContextFactory.java:374)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory$PSWidgetRegionAssembler.assembleRegion(PSPageAssemblyContextFactory.java:295)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:175)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:139)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2013-04-24 09:27:02,404 ERROR [PSPageAssemblyContextFactory] While running the widget there was a major error:
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:672)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy96.assemble(Unknown Source)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assemblyWidget(PSPageAssemblyContextFactory.java:449)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgets(PSPageAssemblyContextFactory.java:434)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgetRegion(PSPageAssemblyContextFactory.java:374)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory$PSWidgetRegionAssembler.assembleRegion(PSPageAssemblyContextFactory.java:295)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:175)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:139)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2013-04-24 09:27:02,419 ERROR [PSPageAssemblyContextFactory] While running the widget there was a major error:
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:672)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy96.assemble(Unknown Source)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assemblyWidget(PSPageAssemblyContextFactory.java:449)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgets(PSPageAssemblyContextFactory.java:434)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgetRegion(PSPageAssemblyContextFactory.java:374)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory$PSWidgetRegionAssembler.assembleRegion(PSPageAssemblyContextFactory.java:295)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:175)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:139)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2013-04-24 09:27:02,435 ERROR [PSPageAssemblyContextFactory] While running the widget there was a major error:
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:672)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy96.assemble(Unknown Source)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assemblyWidget(PSPageAssemblyContextFactory.java:449)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgets(PSPageAssemblyContextFactory.java:434)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory.assembleWidgetRegion(PSPageAssemblyContextFactory.java:374)
at com.percussion.pagemanagement.assembler.PSPageAssemblyContextFactory$PSWidgetRegionAssembler.assembleRegion(PSPageAssemblyContextFactory.java:295)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:175)
at com.percussion.pagemanagement.assembler.impl.PSConcurrentRegionsAssembler$RegionResultsCallable.call(PSConcurrentRegionsAssembler.java:139)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Hi Jason,
This sounds like another symptom of a known issue where a database mismatch can prevent a page from having its workflow state altered, and certain local content cannot be edited. Are you able to open these troublesome pages for editing? If so, please follow the workaround outlined in this topic, which should correct the errors in the local content that’s preventing you from approving these pages:
https://community.percussion.com/t/can-not-approve-or-publish-a-specific-page-without-errors/1383
Hi Nathaniel,
We recreated each one of the assets and now we can publish the page without receiving the error. However, the status is stuck in Pending and the Last Published date is not updated even though it was successfully published. Do you know how we can get these fields working again?
Hi Jason,
One possible cause for the workflow states of your pages not to transition properly would be that the publish operations are completing with errors (possibly due to DTS connectivity problems).
To investigate this further, please navigate to the Admin: Publish section of CM1 and select the Reports tab, and then expand the Publish Log menu. Under the Status column, check and see if your recent publish operations are completing with failures. If they are, select View Details and please share with me the contents of the error.
If there are no errors, can you tell me if this problem appears to be isolated to only certain pages?