Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 1043530 - [REPORTS-SETUP] - upgrade from 3.2 failed to exportAdHoc - due to missing jiawsdatasource
[REPORTS-SETUP] - upgrade from 3.2 failed to exportAdHoc - due to missing jia...
Status: CLOSED ERRATA
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-reports (Show other bugs)
3.3.0
Unspecified Unspecified
urgent Severity urgent
: ---
: 3.3.0
Assigned To: Itamar Heim
Barak Dagan
integration
: Triaged
Depends On: 1045855 1046676
Blocks: 3.3rc1
  Show dependency treegraph
 
Reported: 2013-12-16 10:00 EST by Barak Dagan
Modified: 2014-01-21 09:57 EST (History)
8 users (show)

See Also:
Fixed In Version: is28 - rhevm-reports-3.3.0-26.el6ev.noarch.rpm
Doc Type: Bug Fix
Doc Text:
The reports database schema has been updated to be compatible with JasperServer 5.5, so now the import and export functionality operates correctly.
Story Points: ---
Clone Of:
Environment:
Last Closed: 2014-01-21 09:57:04 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
reports setup log (6.13 KB, application/x-compressed-tar)
2013-12-16 10:00 EST, Barak Dagan
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
oVirt gerrit 22548 None None None Never
oVirt gerrit 22549 None None None Never
Red Hat Product Errata RHBA-2014:0035 normal SHIPPED_LIVE rhevm-reports 3.3 bug fix and enhancement update 2014-01-21 14:53:30 EST

  None (edit)
Description Barak Dagan 2013-12-16 10:00:18 EST
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:
Comment 1 Yaniv Lavi 2013-12-16 10:27:00 EST
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
Comment 4 Barak Dagan 2014-01-16 11:31:22 EST
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
Comment 6 errata-xmlrpc 2014-01-21 09:57:04 EST
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

Note You need to log in before you can comment on or make changes to this bug.