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 varyingERROR 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?
Environment
- Red Hat JBoss BPM Suite (BPMS)
- 6.1.x
- 6.3.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
