-
Bug
-
Resolution: Done
-
Blocker
-
None
-
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.