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

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

XMLWordPrintable

    • NEW
    • NEW

      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.

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

                Created:
                Updated:
                Resolved: