Anand Awasthi [
http://community.jboss.org/people/anand.awasthi] created the discussion
"birt report data not showing up in jbpm console - can't load jdbc jar ?"
To view the discussion, visit:
http://community.jboss.org/message/639391#639391
--------------------------------------------------------------
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
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/639391#639391]
Start a new discussion in jBPM at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]