Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9234

spring boot jbpm starter not working with sql server 2016

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 7.26.0.Final
    • SpringBoot
    • None
    • NEW
    • NEW

    Description

      When 

      kie-server-spring-boot-starter is integrated with SQL server 2016, the start up fails.Please note sql server 2016 is XA compliant.

      ""2020-06-30 11:06:45,280 INFO : %PARSER_ERROR[l] HHH000206: hibernate.properties not found""2020-06-30 11:06:45,280 INFO : %PARSER_ERROR[l] HHH000206: hibernate.properties not found""2020-06-30 11:06:46,027 WARN : %PARSER_ERROR[l] ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR"javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_recover', database 'master', schema 'dbo'. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:756) at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:837) at me.snowdrop.boot.narayana.core.jdbc.DataSourceXAResourceRecoveryHelper.recover(DataSourceXAResourceRecoveryHelper.java:109) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:609) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:201) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:146) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:765) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:377)"20

       

       

       

      The same code works fine with SQL server 2019 which is XA compilant.

      Attachments

        Activity

          People

            kverlaen@redhat.com Kris Verlaenen
            shuchitaprasad shuchita prasad (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: