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

spring boot jbpm starter not working with sql server 2016

    Details

    • Type: Bug
    • Status: Reopened (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 7.26.0.Final
    • Fix Version/s: None
    • Component/s: SpringBoot
    • Labels:
      None
    • Docs QE Status:
      NEW
    • QE Status:
      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                KrisVerlaenen Kris Verlaenen
                Reporter:
                shuchitaprasad shuchita prasad
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: