Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4650

Getting Error " Incorrect syntax near 'limit' " when starting Kie-Server.war

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.3.0.GA
    • 6.3.0.GA
    • Kie-Server

    • jboss-bpmsuite-6.3.0GA,

      Database : MS SQL server 2014

    • Hide

      1) Configure data source to MS SQL server 2014 (under standalone.xml)
      2) Change dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" /> in Persistance.xml
      3) Start jboss bpm suite and deploy Kie-Server.war

      Show
      1) Configure data source to MS SQL server 2014 (under standalone.xml) 2) Change dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" /> in Persistance.xml 3) Start jboss bpm suite and deploy Kie-Server.war

      I am getting error while deploying Kie-Server.war . The error is Caused by:
      com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'limit'.
      I have attached log file.

      Both business-central.war and dashbuilder.war started without any issues.

        1. server.log
          820 kB

              swiderski.maciej Maciej Swiderski (Inactive)
              sandesh.j Sandesh jayaprakash (Inactive)
              Karel Suta Karel Suta
              Karel Suta Karel Suta
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: