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

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

    Details

    • Docs QE Status:
      NEW
    • QE Status:
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  davidredhat David Gutierrez
                  Reporter:
                  jhrcek Jan Hrcek
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: