(KPI, BAM) Create a new query executer

Hello everyone,

i am currently trying to execute the KPI example of the documentation:
http://documentation.bonitasoft.com/build-your-kpi-and-use-it-create-report-bonita-bpm-portal-0
Everything worked well, until i arrived at the step: “Access your Bonita business data via BonitaSQL QueryExecuter”

There you have to create a new query executer. The first step is:

  1. Select Tools then Options

I can’t find the Tools tab, maybe because of language problems because i have installed the german version.
Can anyone tell me where to find it?

Info:
Subscrption Pack Version 6.4.0: Performance

Kind regards,
Pascal

These steps needs to be performed in jaspersoft iReport. You will need to install the iReport and add the library to the iReport classpath

Hope this helps.

Ronak

Hi Pascal,

Instead of console-reporting jar which doesn’t exist anymore, please add in the classpath following files from directory lib :
BonitaBPMSubscription-6.4.0\workspace\tomcat\webapps\bonita\WEB-INF\lib

→ console-common-sp-6.4.0.jar
→ console-server-sp-6.4.0.jar

It should work fine now.

Best regards
LL

Thank you for your quick answer, but I have one last question:

The documentation says:
“With minimal knowledge of Java and SQL, you can build reports out of your business data. Best of all, JasperReports is embedded in Bonita BPM, thus allowing you to access your KPIs, business data, …”
Doesen’t this mean that i can access Jasper (iReport) in Bonita Studio (or Portal)? If so, do i have to use a connector? I saw that there is also a tutorial on jasper connectors, and i can’t quite see the relation between the kpi tutorial and the jasper connector tutorial.

Anyway, i am going to download and install jasper now.

Kind regards,
Pascal

Hello Pascal,
the quoted statement from the online documentation wanted to say that the reporting engine is embedded in Bonita BPM (allowing easier access to Bonita BPM data), and not the designer. You need to download and install iReport as a separate application.

Hello everybody,

thank you both for your help. But i encounter yet another problem. I created a report in iReport, and if I use the preview function of iReport, i can see that the report is containing the correct data.
Then i tried to import the report into Bonita Portal, which worked. The report was shown in the “Analytics” tab. When i tried to view the content of the report in portal, it was empty.

I think this is because i didn’t add the library to the iReport classpath.
The documentation says:

You will also need to add the library to the iReport classpath.

Select Tools then Options.
In the new window, go to iReport then Classpath.
Click on Add JAR.
Select the lib
console-reporting-XXX.jar

e.g. BonitaBPMSubscription-6.1.0/workspace/tomcat/webapps/bonita/WEB-INF/lib/console-reporting-6.1.0.jar

You are now ready to go.

The problem isn’t that i can’t find the wizzard to add a jar to the class path. The problem is that I can’t find the file “BonitaBPMSubscription-6.4.0/workspace/tomcat/webapps/bonita/WEB-INF/lib/console-reporting-6.4.0.jar” (I use Subscription Version 6.4.0)

I think this is the last problem i have. I this would be fixed, it should work.

Does anybody know the problem?

Kind regards,
Pascal

Hi Pascal,
You are right. Console-reporting-6.4.0.jar file does not exist in bonita wabapps. I would suggest that you open a case with our support team and they should be able to assist on this missing .jar file quickly.

Hello,
it still doesen’t work and i don’t know why. I included the two files as you said, but when i upload a report as a zip file containing xxx.jasper, nothing is displayed. When i upload a zip file containing xxx.jasper and connection.properties with the content:

dbUrl=jdbc:mysql://localhost:3306/BonitaReport
dbDriverClassName=com.mysql.jdbc.Driver
dbUser=root
dbPassword=m3tallica

there is an error message displayed saying: “The report engine encountered a problem trying to display the report. Please consult the logs for more information.”

I would like to access the log files. I know how to do it in the Studio but not in the portal.
I did the tutorial exactly like it says, but somehow it still doesen’t work.

I don’t exactly understand how it works. The data is stored in an external database, in my case a mysql database. I can see the content of the table it is being stored in. It looks exactly like in the tutorial. I filled i with some data by executing the process several times. When i open iReport, create the report, and display it in i report, the data from the mysql database is shown in the preview. But when i compile it and try to upload it like I stated above, there is this error. So the problem must have to do with the internal “report renderer” in Bonita Platform i think.

Funny thing: When I open the example reports that are already in the portal, like case history and case average time, I see the process instances I just created with the exact time and date. So those reports seem to function. That is weird.

Kind regards,
Pascal

You will need to check the content you provided in the zipped file.
There should be different files such as :

  • reportxxx.jasper
  • reportxxx.jrxml
  • connection.properties
  • mysql-connector-java-xxx.jar

In your report properties inside Ireport, you need to change the option “when no data” to be set with “All Sections, No detail”. If I remember well by default it is “Blank page” that explains why you have blank page.

Finally, check you still have access to your mysql server. When playing with it I remember having missing files in the zip or not calling the right SLQ request onto the database.

Then, the logs are located under tomcat/logs/

Regards,
LL

Thank you for the answer, but it still doesen’t work somehow.
In addition to your statement, i changed the property “the language for the database query” of the report in iReport to “BONITASQL”, but i also tried it with “SQL”.

The changelog says that the table “PURCHASE_ORDER” can’t be found. In fact, the table is named “purchase_order”, in lower case, but it is set to be not case sensitive. In the databse and in iReport, i can use in the query “purchase_order” and “PURCHASE_ORDER”, so this can’t be the error.

2015-01-06 17:39:47 org.bonitasoft.JRBonitaCsvQueryExecuter
SCHWERWIEGEND: Error while calling the engine
org.bonitasoft.engine.exception.ExecutionException: USERNAME=admin | org.h2.jdbc.JdbcSQLException: Tabelle “PURCHASE_ORDER” nicht gefunden
Table “PURCHASE_ORDER” not found; SQL statement:
select * from purchase_order; [42102-170]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4774)
at org.h2.command.Parser.readTableFilter(Parser.java:1083)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1689)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1796)
at org.h2.command.Parser.parseSelectSub(Parser.java:1683)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1526)
at org.h2.command.Parser.parseSelect(Parser.java:1514)
at org.h2.command.Parser.parsePrepared(Parser.java:404)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:250)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:414)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:253)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:149)
at java.lang.Thread.run(Thread.java:745)

at com.bonitasoft.engine.api.impl.ReportingAPIExt.selectList(ReportingAPIExt.java:140)
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.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:367)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:336)
at com.bonitasoft.engine.transaction.JTATransactionServiceExt.executeInTransaction(JTATransactionServiceExt.java:55)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:343)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:285)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy27.selectList(Unknown Source)
at org.bonitasoft.JRBonitaCsvQueryExecuter.createDatasource(JRBonitaCsvQueryExecuter.java:91)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849)
at org.bonitasoft.reporting.servlet.ReportLoader.fillReport(ReportLoader.java:69)
at org.bonitasoft.reporting.servlet.RunReportServlet.service(RunReportServlet.java:178)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.checkExistingSessionOrFiltering(AuthenticationFilter.java:249)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.checkExistingSessionOrFilteringAndManageException(AuthenticationFilter.java:130)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.h2.jdbc.JdbcSQLException: Tabelle “PURCHASE_ORDER” nicht gefunden
Table “PURCHASE_ORDER” not found; SQL statement:
select * from purchase_order; [42102-170]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4774)
at org.h2.command.Parser.readTableFilter(Parser.java:1083)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1689)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1796)
at org.h2.command.Parser.parseSelectSub(Parser.java:1683)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1526)
at org.h2.command.Parser.parseSelect(Parser.java:1514)
at org.h2.command.Parser.parsePrepared(Parser.java:404)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:250)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:414)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:253)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:149)
at java.lang.Thread.run(Thread.java:745)

at org.h2.engine.SessionRemote.done(SessionRemote.java:568)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:65)
at org.h2.command.CommandRemote.(CommandRemote.java:45)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:440)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70)
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 bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy28.executeQuery(Unknown Source)
at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.executeQuery(ReportingServiceImpl.java:139)
at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.selectList(ReportingServiceImpl.java:125)
at com.bonitasoft.engine.api.impl.ReportingAPIExt.selectList(ReportingAPIExt.java:138)
… 58 more

2015-01-06 17:39:47 org.bonitasoft.reporting.servlet.RunReportServlet
WARNUNG: Report error
org.bonitasoft.reporting.exception.BonitaReportException: the template for File C:\BonitaBPMSubscription-6.4.0-Tomcat-7.0.55\bonita\client\tenants\1\work\reports\vgfhg\vgfhg.jasper could not be fill.
at org.bonitasoft.reporting.servlet.ReportLoader.fillReport(ReportLoader.java:71)
at org.bonitasoft.reporting.servlet.RunReportServlet.service(RunReportServlet.java:178)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.checkExistingSessionOrFiltering(AuthenticationFilter.java:249)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.checkExistingSessionOrFilteringAndManageException(AuthenticationFilter.java:130)
at org.bonitasoft.console.common.server.sso.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: net.sf.jasperreports.engine.JRException: Error while calling the engine
at org.bonitasoft.JRBonitaCsvQueryExecuter.createDatasource(JRBonitaCsvQueryExecuter.java:102)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849)
at org.bonitasoft.reporting.servlet.ReportLoader.fillReport(ReportLoader.java:69)
… 36 more
Caused by: org.bonitasoft.engine.exception.ExecutionException: USERNAME=admin | org.h2.jdbc.JdbcSQLException: Tabelle “PURCHASE_ORDER” nicht gefunden
Table “PURCHASE_ORDER” not found; SQL statement:
select * from purchase_order; [42102-170]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4774)
at org.h2.command.Parser.readTableFilter(Parser.java:1083)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1689)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1796)
at org.h2.command.Parser.parseSelectSub(Parser.java:1683)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1526)
at org.h2.command.Parser.parseSelect(Parser.java:1514)
at org.h2.command.Parser.parsePrepared(Parser.java:404)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:250)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:414)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:253)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:149)
at java.lang.Thread.run(Thread.java:745)

at com.bonitasoft.engine.api.impl.ReportingAPIExt.selectList(ReportingAPIExt.java:140)
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.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:367)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:336)
at com.bonitasoft.engine.transaction.JTATransactionServiceExt.executeInTransaction(JTATransactionServiceExt.java:55)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:343)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:285)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy27.selectList(Unknown Source)
at org.bonitasoft.JRBonitaCsvQueryExecuter.createDatasource(JRBonitaCsvQueryExecuter.java:91)
… 45 more
Caused by: org.h2.jdbc.JdbcSQLException: Tabelle “PURCHASE_ORDER” nicht gefunden
Table “PURCHASE_ORDER” not found; SQL statement:
select * from purchase_order; [42102-170]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4774)
at org.h2.command.Parser.readTableFilter(Parser.java:1083)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1689)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1796)
at org.h2.command.Parser.parseSelectSub(Parser.java:1683)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1526)
at org.h2.command.Parser.parseSelect(Parser.java:1514)
at org.h2.command.Parser.parsePrepared(Parser.java:404)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:250)
at org.h2.command.Parser.prepareCommand(Parser.java:217)
at org.h2.engine.Session.prepareLocal(Session.java:414)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:253)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:149)
at java.lang.Thread.run(Thread.java:745)

at org.h2.engine.SessionRemote.done(SessionRemote.java:568)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:65)
at org.h2.command.CommandRemote.(CommandRemote.java:45)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:440)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70)
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 bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy28.executeQuery(Unknown Source)
at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.executeQuery(ReportingServiceImpl.java:139)
at com.bonitasoft.engine.core.reporting.ReportingServiceImpl.selectList(ReportingServiceImpl.java:125)
at com.bonitasoft.engine.api.impl.ReportingAPIExt.selectList(ReportingAPIExt.java:138)
… 58 more

Sorry for all the questions, but it is important for me that this is working.

Kind regards,
Pascal

EDIT:
Also, there seems to be no explanation how to use the internal h2 database. But in the introduction it is mentioned. But there is only an explanation for using a mysql database.

hi all!

@petruch: have you managed to resolve the problem? I’m trying to run report using external data source. I’ve added connection.properties file and jar for postgres but I’m getting very simillar exception. I don’t understand why bonita is trying to execute my report’s select query using the h2 driver. Any ideas anyone?