Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4603

[GSS] (6.4.z)dashbuilder issue "integer = character varying" when postgresql database is used.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 6.4.2
    • 6.3.4
    • BAM
    • CR1
    • 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

    Description

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

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. RHPAM-213 dashbuilder issue "integer = character varying" when postgresql database is used.

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              david.magallanes David Gutierrez
              rhn-support-mhussain Musharraf Hussain
              Juraj Soltes Juraj Soltes (Inactive)
              Juraj Soltes Juraj Soltes (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: