Parameter: Listbox with Dynamic value from DataSet is empty on the production server.

Thun
edited February 11, 2022 in Analytics #1


I create a parameter with data set for using with Listbox. In my birt designer with jetty, it's showed correct data from database in Listbox. I, however, deploy rptdesign file to production server (Tomcat 8, Birt 4.8, OpenJDK 8) then showed empty data in Listbox. How can I fix this issue?

Comments

  • Thun
    edited May 9, 2020 #2
    Parameter Data Type: String
  • It may be that when you deploy the report, data is not available for the report. You can confirm this by running this report without any parameter from your server, if your report still fails most likely this is the issue. 
  • Thun
    edited May 13, 2020 #4
    I have already fixed this issue. I found a solution at https://stackoverflow.com/questions/34984308/birt-dynamic-list-parameter-remains-empty. Ethan wrote a trick to show error in Tomcat. By the way, I put "reportContext().getMessage()" command in "beforeOpen" event of DataSet that used by Parameter then look in Tomcat log. It will show some error messages about SQL Query.