Bug 1379940

Summary: db:migrate failure : unexpected format of report attribute encountered
Product: Red Hat CloudForms Management Engine Reporter: Prasad Mukhedkar <pmukhedk>
Component: ApplianceAssignee: Gregg Tanzillo <gtanzill>
Status: CLOSED WONTFIX QA Contact: Jan Krocil <jkrocil>
Severity: high Docs Contact:
Priority: high    
Version: 5.6.0CC: abellott, cpelland, gtanzill, jhardy, obarenbo, pmukhedk, tachoi, yrudman
Target Milestone: GA   
Target Release: 5.7.0   
Hardware: x86_64   
OS: Linux   
Whiteboard: upgrade:migration
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-05-18 18:48:21 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:
Attachments:
Description Flags
Error_ruby run history from our lab none

Comment 5 tachoi 2016-10-10 02:58:32 UTC 
Imported customer db in our lab and did migrate. but all went well
CEE thought only difference would be minor version difference
- our lab ver: 5.6.0.13-1
- customer ver: 5.6.0.13-20160624114606_13a9153

Recommended customer to upgrade CFME to the latest version and try again.

However, customer reported back when they tried to use pg_dump/restore command rather than psql command, all went well without upgrading CFME code. Also they reported that there is a possibility that someone deleted customized report which is preventing migration in between those attempts.

Initially, customer reported that they followed https://access.redhat.com/articles/2327481 documentation for the upgrade task which is having pg_dump command but it seems like customer used psql command actually.
Comment 6 tachoi 2016-10-10 03:03:10 UTC 
For the deleting customized report, the possibility is very low as we did successfully import/migrate their db in our lab, if there was violated report, we would have seen it from our lab.
Comment 8 tachoi 2016-10-19 07:23:53 UTC 
Created attachment 1211995 [details]
Error_ruby run history from our lab