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:
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)