The dashbuilder runs into an issue when clicking on the pie chart of a selected process. The issue is not limited to any specific process. The issue only pops up when postgresql database is being used. I have tested mysql and h2 without such issue.
The stack trace looks like:
ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (http-127.0.0.1:8080-1) Error in load() SQLDataset. SQL = select processVersion, count(processinstanceid) as pcount
from processinstancelog
where processVersion is not null and (processname = ?) and 1 = 1 and (status = ?) and 1 = 1 and 1 = 1 and 1 = 1 group by processVersion: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 177
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) [postgresql-9.4-1201.jdbc4.jar:9.4]
at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:116) [dashboard-provider-sql-6.4.0.Final-redhat-13.jar:6.4.0.Final-redhat-13]
or
ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (http-127.0.0.1:8080-11) Error in load() SQLDataset. SQL = select ts.taskname, count(ts.taskid) taskid from BAMTaskSummary ts left join ProcessInstanceLog ps on (ts.processinstanceid=ps.processinstanceid) where (ps.processname = ?) and (ps.status = ?) and 1 = 1 and 1 = 1 and 1 = 1 and 1 = 1 and 1 = 1 and 1 = 1 and 1 = 1 and (ts.status = ?) group by ts.taskname: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 190
....
- clones
-
RHPAM-213 dashbuilder issue "integer = character varying" when postgresql database is used.
- Closed