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

Process Dashboard > SQL errors on dataset lookup (DB2 9.7 only)

    XMLWordPrintable

Details

    • NEW
    • NEW

    Description

      Most of the new process dashboard tests are failing because of dataset lookup issue.
      This problem only affects DB2 9.7, the tests are passing fine on other DBs (including DB2 10.5).

      The following errors are taken from server.log (see attachment):

      09:42:21,250 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-30) SELECT * FROM PROCESSINSTANCELOG LIMIT 1
      09:42:21,251 ERROR [org.dashbuilder.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-30) Can't get metadata on specified data set: processesMonitoring: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: processesMonitoring
      ...
      Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=4.14.137

      Found this article about SQLCODE -104

      I'm not sure if there were any SQL provider-related changes recently. It might also turn out to be a database error (which would be weird in case of syntax error ??), but reporting this just to be sure.

      Attachments

        Activity

          People

            david.magallanes David Gutierrez
            jhrcek Jan Hrcek (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: