Bug 1471014

Summary: UI: "Unexpected error encountered" when Downloading report in text,csv and pdf format
Product: Red Hat CloudForms Management Engine Reporter: Niyaz Akhtar Ansari <nansari>
Component: UI - OPSAssignee: Yuri Rudman <yrudman>
Status: CLOSED CURRENTRELEASE QA Contact: Niyaz Akhtar Ansari <nansari>
Severity: high Docs Contact:
Priority: high    
Version: 5.8.0CC: cbucur, cmatthew, dajohnso, dclarizi, ealcaniz, ecrosby, fdewaley, hkataria, jclaretm, jhardy, krain, mfeifer, mpovolny, ncatling, nchugh, niroy, obarenbo, simaishi, vestival, yrudman
Target Milestone: GAKeywords: TestOnly, ZStream
Target Release: 5.9.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: ui:report
Fixed In Version: 5.9.0.1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1479994 1481743 1497244 (view as bug list) Environment:
Last Closed: 2018-03-06 14:35:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1479994, 1481743, 1497244    
Attachments:
Description Flags
screenshot none

Description Niyaz Akhtar Ansari 2017-07-14 09:22:50 UTC
Created attachment 1298219 [details]
screenshot

Description of problem:


Version-Release number of selected component (if applicable):
Version 5.8.1.2.20170712143358_461cde4 

How reproducible:
100%

Steps to Reproduce:
1.Go to Cloud Intel-> Reports-> All Reports
2.Select any default report and Queue
3.Select generated report and Download as Text, CSV, PDF

Actual results:
Unable to download report as Text, CSV, PDF format.
unexpected error encounter on ui.

 Error text:
Couldn't find MiqReportResult with 'id'=30 [WHERE ("miq_report_results"."miq_group_id" IS NOT NULL)] [report/send_report_data] 
Expected results:


Additional info:

Comment 8 CFME Bot 2017-08-04 13:53:35 UTC
New commit detected on ManageIQ/manageiq-ui-classic/master:
https://github.com/ManageIQ/manageiq-ui-classic/commit/9e3e8bc7c533b0f20b5b084faf24a852d4b4a63b

commit 9e3e8bc7c533b0f20b5b084faf24a852d4b4a63b
Author:     Yuri Rudman <yrudman>
AuthorDate: Thu Aug 3 16:55:29 2017 -0400
Commit:     Yuri Rudman <yrudman>
CommitDate: Thu Aug 3 16:55:29 2017 -0400

    Issue: connecting as admin user and executing download will set userid column in miq_report_result table to 'admin|2d7db0c5addb0eb91de3541c811ea02e|download' and this user does not belong to any group. Solution: Reverting back to previous logic.
    https://bugzilla.redhat.com/show_bug.cgi?id=1471014

 app/controllers/application_controller/report_downloads.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

Comment 13 Yuri Rudman 2017-08-15 15:16:57 UTC
*** Bug 1471732 has been marked as a duplicate of this bug. ***

Comment 17 Jared Deubel 2017-09-08 14:39:14 UTC
*** Bug 1489853 has been marked as a duplicate of this bug. ***

Comment 18 Harpreet Kataria 2017-09-21 20:59:12 UTC
*** Bug 1490102 has been marked as a duplicate of this bug. ***

Comment 19 Niyaz Akhtar Ansari 2017-10-11 12:30:26 UTC
No error when Downloading report in text,csv and pdf format.
It works fine,
Verified in Version 5.9.0.1.20171004215954_13427ce