Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-213

dashbuilder issue "integer = character varying" when postgresql database is used.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 6.x.x
    • 6.x.x
    • BAM
    • Hide
      • configure postgresql database with bpms 6.3.4 out-of-box installation
      • start server letting bpms generate all of the db schema
      • login to business central to create a simple hello world sort of process, for example, testPro. The process may only contain a start node+a script task+end node. build and deploy the process. start the process.
      • login to dashbuilder. select jbpm on the top menu, and select the process testPro. Click on the graph of the selected process.
        It should pop up an error box and show the error message 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

      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

      Show
      configure postgresql database with bpms 6.3.4 out-of-box installation start server letting bpms generate all of the db schema login to business central to create a simple hello world sort of process, for example, testPro. The process may only contain a start node+a script task+end node. build and deploy the process. start the process. login to dashbuilder. select jbpm on the top menu, and select the process testPro. Click on the graph of the selected process. It should pop up an error box and show the error message 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 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

      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
      ....

        1. postgresql.zip
          7 kB
        2. Screenshot from 2016-12-19 09-16-14.png
          Screenshot from 2016-12-19 09-16-14.png
          168 kB

              david.magallanes David Gutierrez
              rhn-support-ghu Gary Hu
              Jan Hrcek Jan Hrcek (Inactive)
              Jan Hrcek Jan Hrcek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: