Bug 1322397 - engine-setup is failing with 'relation "jidashboardmodel" does not exist'
Summary: engine-setup is failing with 'relation "jidashboardmodel" does not exist'
Keywords:
Status: CLOSED DUPLICATE of bug 1290040
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-reports
Version: 3.6.3
Hardware: All
OS: Linux
high
medium
Target Milestone: ovirt-3.6.5
: ---
Assignee: Yedidyah Bar David
QA Contact: Pavel Stehlik
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-03-30 12:34 UTC by Alexandros Gkesos
Modified: 2019-10-10 11:46 UTC (History)
9 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-04-04 09:17:35 UTC
oVirt Team: Reports
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Alexandros Gkesos 2016-03-30 12:34:47 UTC
Description of problem: In https://bugzilla.redhat.com/show_bug.cgi?id=1212306 there was a fix https://bugzilla.redhat.com/show_bug.cgi?id=1212306#c1 . If there is no table "jidashboardmodel" we create it. 

engine-setup with the fixed version is still failing for non-existent table


Version-Release number of selected component:

Mar 07 14:52:49 Installed: jasperreports-server-pro-5.5.0-10.el6ev.noarch
Mar 07 14:53:03 Installed: rhevm-reports-setup-3.5.8-1.el6ev.noarch
Mar 07 14:53:04 Installed: rhevm-reports-3.5.8-1.el6ev.noarch

-->

Mar 29 15:57:50 Updated: jasperreports-server-pro-6.0.1-5.el6ev.noarch
Mar 29 15:57:51 Updated: rhevm-reports-3.6.3-1.el6ev.noarch
Mar 29 15:57:52 Updated: rhevm-reports-setup-3.6.3-1.el6ev.noarch

for some reason, even if the engine-setup failed, we upgraded rhevm-reports.

How reproducible: Everytime

Steps to Reproduce:
1. Install 3.5.8 reports/dwh on separate server
2. yum update
3. engine-setup

Actual results:
failing here:

...
Resource name: applicationContext-themes-pro.xml
Resource name: applicationContext-virtual-data-source.xml
ERROR: relation "jidashboardmodel" does not exist
  Position: 4358
com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL 

(I will upload the sosreport in case the rest is needed)

Expected results:

Create the non-existent table and finish successfully

Additional info: RHEV-M and DWH/Reports are on different servers

Comment 7 Yedidyah Bar David 2016-04-04 09:17:35 UTC
Closing as duplicate of bug 1290040. If you think it's a different flow, please give more details, including exact flow and yum.log. Thanks.

*** This bug has been marked as a duplicate of bug 1290040 ***


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