• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Birt EngineExeption while rendering report

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've developed couple of reports in Analytics Designer (former Birt) with DB Data Source (working fine). It's MySQL Server 2016. I deployed Birt Runtime OSGI 4.5.0 files under Apache Tomcat 9.0 webapps folder.

I put sqljdbc42.jar (ms jdbc connector) under:

$TOMCAT\webapps\birt\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_4.5.0.v201506092134\drivers
When I run test report everything works fine. When I try to run my report I get a lot of exeptions starting with this.



I'm stuck on this for a long time in work. Do you have any suggestions?
 
Saloon Keeper
Posts: 27752
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the JavaRanch, Gustav!

I suggest that you include the stack trace. All that message says is that "it doesn't work".
 
Gustav Gu
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Tim. This is the info I get when running the report.

 
Tim Holloway
Saloon Keeper
Posts: 27752
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If there are additional stack traces, they need to be looked at. The most I can tell from here is that apparently BIRT couldn't set up a database linkage. Beyond that, you'd have to ask in the forum where we ask BIRT questions, since I haven't worked with it in a long, long time.
 
Gustav Gu
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey Tim. I haven't found birt sub-forum here. I will appreciate if you gave me a suggestion where to repost this question.

Anyway I can't seem to find full expeption strack trace. But I have 2 log files:

this is log from webapps/$birtlogs/ (but looks different from previous one)
https://pastebin.com/Vf6T6wrA

and this is from $tomcat/logs
https://pastebin.com/tHzQWS64

it seem like there're files missing. Still I don't know how, cause I haven't changed the downloaded birt files.
 
Tim Holloway
Saloon Keeper
Posts: 27752
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think BIRT is handled in the "Other Java Products and Servers" forum. There used to be a list of the primary items covered in a forum, but I don't see it now.

Anyway, this item: /ThemesReportItems31.rptlibrary is something that (per the J2EE standard), is being searched for in the root of the webapp WAR file (or directory). So if I exploded "myapp.war", that would be "TOMCAT_HOME/webapps/myapp/ThemesReportItems31.rptlibrary".

The other item that kept showing up was "file:///C:/apache-tomcat-9.0.0.M21/bin/test.chart".  This one bothers me because firstly, it's generally not good practice to be dropping files into Tomcat's bin directory, and secondly, the bin directory is supposed to contain executable files, and a file named "test.chart" sounds more like a data file.
 
Gustav Gu
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Tim.

My boss told me to debug this issue and make it work But I'm very new to Java (I've done some tutorials, and I worked mainly with Talend and Birt which doesn't require a lot of programming/heavy debugging). It's a bit out of my filed since I was mainly using in php/mysql/html/css/js and such.

Anyway thanks again. I'll search for some java debug tutorials. Your info will sure come in handy.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic