Unexpected HTTP response code when requesting URI 'http://localhost:60532/kie-server/services/rest/server/queries/definitions/allProcessInstancesWithVars/data?mapper=ProcessInstancesWithVariables&orderBy=&page=0&pageSize=10'! Error code: 500, message: JBWEB000065: HTTP Status 500 - org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: allProcessInstancesWithVars

JBWEB000065: HTTP Status 500 - org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: allProcessInstancesWithVars


JBWEB000309: type JBWEB000066: Exception report

JBWEB000068: message org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: allProcessInstancesWithVars

JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.

JBWEB000070: exception

org.jboss.resteasy.spi.UnhandledException: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: allProcessInstancesWithVars
 org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:367)
 org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:235)
 org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:211)
 org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:576)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:543)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:128)
 org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

JBWEB000071: root cause

org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: allProcessInstancesWithVars
 org.dashbuilder.dataset.DataSetManagerImpl.lookupDataSet(DataSetManagerImpl.java:155)
 org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:202)
 org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:170)
 org.kie.server.services.jbpm.QueryDataServiceBase.query(QueryDataServiceBase.java:110)
 org.kie.server.remote.rest.jbpm.QueryDataResource.runQuery(QueryDataResource.java:148)
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 java.lang.reflect.Method.invoke(Method.java:606)
 org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)
 org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
 org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
 org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
 org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:561)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:543)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:128)
 org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

JBWEB000071: root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'v.variableId' in 'on clause'
 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
 sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 java.lang.reflect.Constructor.newInstance(Constructor.java:526)
 com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
 com.mysql.jdbc.Util.getInstance(Util.java:360)
 com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
 com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
 com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
 com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
 com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
 com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
 com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
 org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:344)
 org.dashbuilder.dataprovider.sql.JDBCUtils.executeQuery(JDBCUtils.java:77)
 org.dashbuilder.dataprovider.sql.model.Select.fetchCount(Select.java:162)
 org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getRowCount(SQLDataSetProvider.java:424)
 org.dashbuilder.dataprovider.sql.SQLDataSetProvider._getDataSetMetadata(SQLDataSetProvider.java:335)
 org.dashbuilder.dataprovider.sql.SQLDataSetProvider$LookupProcessor.run(SQLDataSetProvider.java:609)
 org.dashbuilder.dataprovider.sql.SQLDataSetProvider._lookupDataSet(SQLDataSetProvider.java:429)
 org.dashbuilder.dataprovider.sql.SQLDataSetProvider.lookupDataSet(SQLDataSetProvider.java:234)
 org.dashbuilder.dataset.DataSetManagerImpl.lookupDataSet(DataSetManagerImpl.java:152)
 org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:202)
 org.jbpm.kie.services.impl.query.QueryServiceImpl.query(QueryServiceImpl.java:170)
 org.kie.server.services.jbpm.QueryDataServiceBase.query(QueryDataServiceBase.java:110)
 org.kie.server.remote.rest.jbpm.QueryDataResource.runQuery(QueryDataResource.java:148)
 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 java.lang.reflect.Method.invoke(Method.java:606)
 org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)
 org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
 org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
 org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
 org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:561)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:543)
 org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:128)
 org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
 org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:847)