Created attachment 837254 [details] reports setup log Description of problem: During rhevm-reports installation, missing jiawsdatasource lead to failure of exporting adHoc part: $ grep -A5 ERROR: ovirt-engine-reports-setup-2013_12_16_00_53_10.log ERROR: relation "jiawsdatasource" does not exist Position: 4949 com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [...]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query 2013-12-15 14:07:22:EBUG::common_utils::493::root:: stderr = -- JasperServer: EhCacheImpl shutdown called. This normal shutdown operation. -- JasperServer: EhCacheImpl calling cleanerTimer.cancel(). This normal shutdown operation. -- Caused by: org.postgresql.util.PSQLException: ERROR: relation "jiawsdatasource" does not exist Position: 4949 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) -- 2013-12-15 14:07:22::ERROR::rhevm-reports-setup::614::root:: Exception caught, passing it along to main loop 2013-12-15 14:07:22::ERROR:ecorators::26::root:: Traceback (most recent call last): File "/usr/share/ovirt-engine-reports/decorators.py", line 21, in wrapped_f output = f() File "/usr/bin/rhevm-reports-setup", line 611, in exportAdHoc utils.execExternalCmd(cmd, True, "Failed while exporting ad hoc reports") File "/usr/share/ovirt-engine-reports/common_utils.py", line 497, in execExternalCmd -- 2013-12-15 14:07:22::ERROR::rhevm-reports-setup::1281::root:: Failed to complete the setup of the reports package! 2013-12-15 14:07:22:EBUG::rhevm-reports-setup::1282::root:: Traceback (most recent call last): File "/usr/bin/rhevm-reports-setup", line 1187, in main exportAdHoc() File "/usr/share/ovirt-engine-reports/decorators.py", line 27, in wrapped_f raise Exception(instance) Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Jasper have broken the export scripts in JRS 5.5 GA by changing the db schema. We need to save and use the old scripts from for the ad hoc export and use the new scripts for import. Yaniv
verified on is32.2: rhevm-reports-3.3.0-28.el6ev.noarch rhevm-dwh-3.3.0-28.el6ev.noarch jasperreports-server-pro-5.5.0-4.el6ev.noarch
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2014-0035.html