org.springframework.transaction.CannotCreateTransactionException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • There are samples that demonstrate global startup actions in /public/bi-developers/Secure/ By default, none of the samples work because there are no values in the session (which would be injected by way of global action). To enable this, edit pentaho-solutions/system/sessionStartupActions.xml Find the section for the global startup actions and uncomment the SessionStartupAction bean (should be at the bottom). The actionPath will have to be updated, as it is not correct, make sure it is: /public/bi-developers/Secure/global-department-list.xaction Now start (or restart) your BI-SERVER. The system will actually fail to startup properly and will spew a few exceptions, and thanks to the way we are doing logging, the real exception is lost. I have added some extra debugging to my build so as to capture the real exception causing this to happen: org.springframework.transaction.CannotCreateTransactionException: Could not open JCR session for transaction; nested exception is javax.jcr.LoginException: Logi nModule ignored Credentials at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:160) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy27.getFile(Unknown Source) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:244) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:457) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getSolutionDocument(ActionSequenceJCRHelper.java:104) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getActionSequence(ActionSequenceJCRHelper.java:89) at org.pentaho.platform.engine.services.solution.SolutionEngine.createActionSequence(SolutionEngine.java:426) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:348) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:301) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:180) at org.pentaho.platform.engine.core.system.PentahoSystem.globalStartup(PentahoSystem.java:891) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:844) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:841) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:353) at org.pentaho.platform.engine.core.system.PentahoSystem.access$100(PentahoSystem.java:71) at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:841) at java.lang.Thread.run(Thread.java:722) Caused by: javax.jcr.LoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1493) at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory.getSession(CredentialsStrategySessionFactory.java:324) at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:120) ... 23 more Caused by: javax.security.auth.login.FailedLoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.security.authentication.LocalAuthContext.login(LocalAuthContext.java:87) at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1465) ... 25 more Exception in thread "Thread-35" java.lang.RuntimeException: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting fil e with path "/public/bi-developers/Secure/global-department-list.xaction" Reference number: 8ef5d81e-0c85-4563-99ae-800000cee96a at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:849) at java.lang.Thread.run(Thread.java:722) Caused by: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting file with path "/public/bi-developers/Secure/global- department-list.xaction" Reference number: 8ef5d81e-0c85-4563-99ae-800000cee96a at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:483) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getSolutionDocument(ActionSequenceJCRHelper.java:104) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getActionSequence(ActionSequenceJCRHelper.java:89) at org.pentaho.platform.engine.services.solution.SolutionEngine.createActionSequence(SolutionEngine.java:426) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:348) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:301) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:180) at org.pentaho.platform.engine.core.system.PentahoSystem.globalStartup(PentahoSystem.java:891) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:844) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:841) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:353) at org.pentaho.platform.engine.core.system.PentahoSystem.access$100(PentahoSystem.java:71) at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:841) ... 1 more From my personal experience, this is something which is going to affect plenty of customers and will have to be addressed ASAP.
    via by Michael D'Amour,
  • There are samples that demonstrate global startup actions in /public/bi-developers/Secure/ By default, none of the samples work because there are no values in the session (which would be injected by way of global action). To enable this, edit pentaho-solutions/system/sessionStartupActions.xml Find the section for the global startup actions and uncomment the SessionStartupAction bean (should be at the bottom). The actionPath will have to be updated, as it is not correct, make sure it is: /public/bi-developers/Secure/global-department-list.xaction Now start (or restart) your BI-SERVER. The system will actually fail to startup properly and will spew a few exceptions, and thanks to the way we are doing logging, the real exception is lost. I have added some extra debugging to my build so as to capture the real exception causing this to happen: org.springframework.transaction.CannotCreateTransactionException: Could not open JCR session for transaction; nested exception is javax.jcr.LoginException: Logi nModule ignored Credentials at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:160) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy27.getFile(Unknown Source) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:244) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:457) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getSolutionDocument(ActionSequenceJCRHelper.java:104) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getActionSequence(ActionSequenceJCRHelper.java:89) at org.pentaho.platform.engine.services.solution.SolutionEngine.createActionSequence(SolutionEngine.java:426) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:348) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:301) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:180) at org.pentaho.platform.engine.core.system.PentahoSystem.globalStartup(PentahoSystem.java:891) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:844) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:841) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:353) at org.pentaho.platform.engine.core.system.PentahoSystem.access$100(PentahoSystem.java:71) at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:841) at java.lang.Thread.run(Thread.java:722) Caused by: javax.jcr.LoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1493) at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory.getSession(CredentialsStrategySessionFactory.java:324) at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:120) ... 23 more Caused by: javax.security.auth.login.FailedLoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.security.authentication.LocalAuthContext.login(LocalAuthContext.java:87) at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1465) ... 25 more Exception in thread "Thread-35" java.lang.RuntimeException: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting fil e with path "/public/bi-developers/Secure/global-department-list.xaction" Reference number: 8ef5d81e-0c85-4563-99ae-800000cee96a at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:849) at java.lang.Thread.run(Thread.java:722) Caused by: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting file with path "/public/bi-developers/Secure/global- department-list.xaction" Reference number: 8ef5d81e-0c85-4563-99ae-800000cee96a at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:483) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getSolutionDocument(ActionSequenceJCRHelper.java:104) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getActionSequence(ActionSequenceJCRHelper.java:89) at org.pentaho.platform.engine.services.solution.SolutionEngine.createActionSequence(SolutionEngine.java:426) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:348) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:301) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:180) at org.pentaho.platform.engine.core.system.PentahoSystem.globalStartup(PentahoSystem.java:891) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:844) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:841) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:353) at org.pentaho.platform.engine.core.system.PentahoSystem.access$100(PentahoSystem.java:71) at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:841) ... 1 more From my personal experience, this is something which is going to affect plenty of customers and will have to be addressed ASAP.
    via by Michael D'Amour,
  • Jackrabbit ignored Credentials
    via Stack Overflow by user3381124
    ,
    • org.springframework.transaction.CannotCreateTransactionException: Could not open JCR session for transaction; nested exception is javax.jcr.LoginException: Logi nModule ignored Credentials at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:160) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy27.getFile(Unknown Source) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:244) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$21.call(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:457) at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFile(ExceptionLoggingDecorator.java:242) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getSolutionDocument(ActionSequenceJCRHelper.java:104) at org.pentaho.platform.engine.services.ActionSequenceJCRHelper.getActionSequence(ActionSequenceJCRHelper.java:89) at org.pentaho.platform.engine.services.solution.SolutionEngine.createActionSequence(SolutionEngine.java:426) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:348) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:301) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:180) at org.pentaho.platform.engine.core.system.PentahoSystem.globalStartup(PentahoSystem.java:891) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:844) at org.pentaho.platform.engine.core.system.PentahoSystem$2$1.call(PentahoSystem.java:841) at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:353) at org.pentaho.platform.engine.core.system.PentahoSystem.access$100(PentahoSystem.java:71) at org.pentaho.platform.engine.core.system.PentahoSystem$2.run(PentahoSystem.java:841) at java.lang.Thread.run(Thread.java:722) Caused by: javax.jcr.LoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1493) at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory.getSession(CredentialsStrategySessionFactory.java:324) at org.springframework.extensions.jcr.jackrabbit.LocalTransactionManager.doBegin(LocalTransactionManager.java:120) ... 23 more Caused by: javax.security.auth.login.FailedLoginException: LoginModule ignored Credentials at org.apache.jackrabbit.core.security.authentication.LocalAuthContext.login(LocalAuthContext.java:87) at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1465) ... 25 more
    No Bugmate found.