Hi Everyone,
I am trying to generate the reports using birt run time 3.7.1 in jbpm console 5.1 which is deployed on WebSphere 7. I have configured birt runitme location in WAS admin console pointing to -Dorg.jbpm.report.engine.dir=D:\birt-runtime\birt. Everything looks ok and I can pull up the reporting templates in JBPM Console also but i am not seeing the data , instead i get error shown below. the relevant stack trace is :
- Can not load the report query: 122. Errors occurred when generating the report document for the report element with ID 122. (Element ID:122)
Error.ReportQueryLoadingError2 ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query:
122. Errors occurred when generating the report document for the report element with ID 122. (Element ID:122)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:160)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1905)
While digging at the forums, I found that for Birt runtime 3.7.1 , I need to copy jdbc jar, (in this case db2jcc.jar) in BirtHome/WEB-INF/lib.
So I deployed birt.war on WAS 7 with db2jcc.jar in WEB-INF/lib and it still didnt work. I also copied the db2jcc.jar in D:\birt-runtime\birt\ReportEngine\lib and that didnt work either. What am I missing ?
BTW, I can pull the data in Eclipse - when i open the template in Designer View. All I had to do was add the jar using Jar Management Wizard and conifgure the data source. But the same thing is not working when I try to open the reports in Server enviornment.
Any pointers will be greatly appreciated.
Regards,
Anand