It shows errors "operator does not exist: integer = character varying" if PostgreSql database is used when clicking on a graph on Dashbuilder in BPMS 6

Issue

• Dashbuilder throws integer = character varying ERROR when PostgreSql database is used and user clicks on a process graph . Here is the snippet of the stack trace for reference.

...
Thread id=AJP-THREAD-POOL-411
...
Thread group=uq-ajp-thread-pool
Request URL=/dashbuilder/Controller?csrf=53057644
Request IP=10.10.10.10
...
Request header:user-agent=Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.116 Safari/537.36
Request header:referer=https://10.10.10.10/dashbuilder/Controller?csrf=98226897
Request header:cookie=JSESSIONID=4Dol8wnXC11V-vxhJYV1zkNw.wewrtt12; dashbuilderNavigationPoint=es-1jn-2; JSESSIONIDSSO=1wPDP3LjrWes+rEryTPpqkbC; region_left_web_2_0_cookie=1
Request param:csrf=53057644
Tx id=174338241
Tx Isolation=2
Tx Auto commit=false
Error id=1474497109052
...
Error stack trace=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:2157)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
    at org.jboss.dashboard.dataset.sql.SQLDataSet.load(SQLDataSet.java:116)
    at org.jboss.dashboard.dataset.sql.SQLDataSet._filterInDB(SQLDataSet.java:188)
    at org.jboss.dashboard.dataset.sql.SQLDataSet.filter(SQLDataSet.java:180)
    at org.jboss.dashboard.dataset.DataSetManagerImpl.filterDataSet(DataSetManagerImpl.java:67)
    at org.jboss.dashboard.dataset.DataSetManagerImpl$Proxy$_$$_WeldClientProxy.filterDataSet(DataSetManagerImpl$Proxy$_$$_WeldClientProxy.java)
    at org.jboss.dashboard.provider.DataProviderImpl.filterDataSet(DataProviderImpl.java:223)
    at org.jboss.dashboard.ui.Dashboard.filter(Dashboard.java:324)
    at org.jboss.dashboard.ui.Dashboard.filter(Dashboard.java:286)
    at org.jboss.dashboard.ui.Dashboard.filter(Dashboard.java:265)
    at org.jboss.dashboard.ui.components.chart.NVD3ChartViewer.actionApplyLink(NVD3ChartViewer.java:44)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.jboss.dashboard.ui.components.BeanHandler.handle(BeanHandler.java:152)
    at org.jboss.dashboard.ui.components.BeanDispatcher.handle(BeanDispatcher.java:133)
    at org.jboss.dashboard.ui.components.BeanDispatcher.performRequestHandling(BeanDispatcher.java:124)
    at org.jboss.dashboard.ui.components.BeanDispatcher.handleRequest(BeanDispatcher.java:46)
    at org.jboss.dashboard.ui.components.BeanDispatcher$Proxy$_$$_WeldClientProxy.handleRequest(BeanDispatcher$Proxy$_$$_WeldClientProxy.java)
    at org.jboss.dashboard.ui.panel.PanelDriver.panelActionFactory(PanelDriver.java:1237)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.jboss.dashboard.ui.panel.PanelDriver._execute(PanelDriver.java:817)
    at org.jboss.dashboard.ui.panel.PanelDriver.execute(PanelDriver.java:780)
    at org.jboss.dashboard.ui.panel.kpi.KPIDriver$Proxy$_$$_WeldClientProxy.execute(KPIDriver$Proxy$_$$_WeldClientProxy.java)
    at org.jboss.dashboard.ui.controller.requestChain.RequestDispatcher.processRequest(RequestDispatcher.java:93)
    at org.jboss.dashboard.ui.controller.requestChain.RequestDispatcher$Proxy$_$$_WeldClientProxy.processRequest(RequestDispatcher$Proxy$_$$_WeldClientProxy.java)
    at org.jboss.dashboard.ui.controller.RequestProcessor.run(RequestProcessor.java:68)
    at org.jboss.dashboard.ui.controller.RequestProcessor$Proxy$_$$_WeldClientProxy.run(RequestProcessor$Proxy$_$$_WeldClientProxy.java)
    at org.jboss.dashboard.ui.controller.ControllerServlet$1.txFragment(ControllerServlet.java:174)
    at org.jboss.dashboard.database.hibernate.HibernateTransaction.executeFragment(HibernateTransaction.java:252)
    at org.jboss.dashboard.database.hibernate.HibernateTxFragment.executeInitiator(HibernateTxFragment.java:179)
    at org.jboss.dashboard.database.hibernate.HibernateTxFragment.execute(HibernateTxFragment.java:167)
    at org.jboss.dashboard.ui.controller.ControllerServlet.processTheRequest(ControllerServlet.java:170)
    at org.jboss.dashboard.ui.controller.ControllerServlet.service(ControllerServlet.java:135)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512)
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
    at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:559)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
    at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:475)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:454)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2562)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
    at org.jboss.threads.JBossThread.run(JBossThread.java:122)
...

• The query responsible for throwing the above error was something like this.

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

How to solve this problem?