Bug 1279606
Summary: | multiple ERRORS of the form "[ActiveRecord::StatementInvalid]: PG::UndefinedTable: ERROR: missing FROM-clause entry for table "vms" " | ||
---|---|---|---|
Product: | Red Hat CloudForms Management Engine | Reporter: | Thomas Hennessy <thenness> |
Component: | Reporting | Assignee: | Joe Rafaniello <jrafanie> |
Status: | CLOSED DUPLICATE | QA Contact: | Dave Johnson <dajohnso> |
Severity: | medium | Docs Contact: | |
Priority: | unspecified | ||
Version: | 5.5.0 | CC: | jhardy, obarenbo |
Target Milestone: | GA | ||
Target Release: | 5.5.0 | ||
Hardware: | x86_64 | ||
OS: | Linux | ||
Whiteboard: | |||
Fixed In Version: | jocarter@redhat.com, mfeifer@redhat.com, jdeubel@redhat.com, | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2015-11-20 16:00:01 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Thomas Hennessy
2015-11-09 20:37:04 UTC
the first line in the provided log extract is the INFO log line detailing all of the information regarding the report id and the target of the report. Since it has never been clear to me which field has the report id and which field has the target id, I am providing a complete dump of the 123 standard reports that are in the testing system so that you can determine which report is responsible for this error. ===== 441000000000001;"VMs with Free Space > 50% by Department";"VMs with Volume Free Space > 50% by Department" 441000000000002;"VMs w/Free Space > 75% by Function";"VMs with Volume Free Space > 75% by Function" 441000000000003;"VMs w/Free Space > 75% by LOB";"VMs with Volume Free Space > 75% by Line of Business" 441000000000004;"VM Disk Usage";"VM Disk Usage" 441000000000005;"Hardware Information for VMs";"Hardware Information for VMs" 441000000000006;"Vendor and Type";"VM Vendor and Type" 441000000000007;"Vendor and Guest OS";"Vendor and Guest OS" 441000000000008;"VM Location and Size";"VM Location and Size" 441000000000009;"VM UUIDs";"VM Guest OS UUIDs" 441000000000010;"VMs with no UUID";"VMs with no UUID" 441000000000011;"VMs with Volume Free Space <= 20%";"VMs with Volume Free Space <= 20%" 441000000000012;"VMs with Volume Free Space >= 80%";"VMs with Volume Free Space >= 80%" 441000000000013;"VMs by MAC Address";"VMs by MAC Addresses" 441000000000014;"Unregistered VMs";"VMs on Datastore but not registered to a Host" 441000000000015;"Orphaned VMs";"VMs in EVM that have been deleted from VC" 441000000000016;"VMs Snapshot Summary";"VMs Snapshot Summary" 441000000000017;"User Accounts - Windows";"VM User Accounts for Windows" 441000000000018;"User Accounts - Linux";"VM User Accounts for Linux" 441000000000019;"Account Groups - Windows";"VM Account Groups for Windows" 441000000000020;"Account Groups - Linux";"VM Account Groups for Linux" 441000000000021;"Guest OS Information - any OS";"Guest OS Information - any OS" 441000000000022;"Guest OS Information - Windows";"Guest OS Information for Windows" 441000000000023;"Guest OS Information - Linux";"Guest OS Information for Linux" 441000000000024;"Guest OS Password Information - Windows";"Guest OS Password Information for Windows" 441000000000025;"Guest OS HKLM Registry Information";"Guest OS HKLM Registry Information" 441000000000026;"Hosts Summary";"Hosts - Summary by Version" 441000000000027;"Host Summary with VM info";"Host Summary with VM info" 441000000000028;"Virtual Infrastructure Platforms";"Virtual Infrastructure Platforms" 441000000000029;"Host - ESX Services";"ESX Services" 441000000000030;"Host - ESX Service Console Packages";"ESX Service Console Packages" 441000000000031;"Date brought under Management for Last Week";"Hosts: Date brought under Management for Last Week" 441000000000032;"Hardware Information";"Hardware information for Hosts" 441000000000033;"Host Summary for VMs";"Host Summary for VMs" 441000000000034;"Host Patches";"Hosts - Installed Patches" 441000000000035;"Host VM Relationships";"Host to VM Relationships" 441000000000036;"Host Storage Adapters";"Hosts - Storage Adapters Information" 441000000000037;"Host Network Information";"Hosts - Network Information" 441000000000038;"Host vLANs and vSwitches";"Hosts - vLANs and vSwitches" 441000000000039;"Providers Summary";"Providers Summary" 441000000000040;"Providers Hosts Relationships";"Providers Hosts Relationships" 441000000000041;"Providers VMs Relationships";"Providers VMs Relationships" 441000000000042;"Watermark Host Sockets per Provider";"Watermark Host Sockets per Provider" 441000000000043;"Watermark VMs per Provider";"Watermark VMs per Provider" 441000000000044;"Clusters Summary";"Clusters Summary" 441000000000045;"Cluster Hosts Affinity";"Cluster to Hosts Affinity" 441000000000046;"Cluster VMs Affinity with Power State";"Cluster tp VMs Affinity with Power State" 441000000000058;"Number of Nodes per CPU Cores";"Number of Nodes per CPU Cores" 441000000000047;"Cluster Resources";"Cluster Resources" 441000000000048;"Resource Pools Summary";"Resource Pools Summary" 441000000000049;"Datastores Summary";"Datastores Summary" 441000000000050;"Datastore Summary for VMs";"Datastore Summary for VMs" 441000000000051;"Datastore Summary for Hosts";"Datastore summary for Hosts" 441000000000052;"Datastore LUN Information";"Datastore LUN Information" 441000000000053;"Folder VMs Relationships";"Folder to VMs Relationships" 441000000000054;"Nodes By Capacity";"Nodes By Capacity" 441000000000055;"Nodes By CPU Usage";"Nodes By CPU Usage" 441000000000056;"Nodes By Memory Usage";"Nodes By Memory Usage" 441000000000057;"Recently Discovered Pods";"Recently Discovered Pods" 441000000000059;"Pods per Ready Status";"Pods per Ready Status" 441000000000060;"Summary - VMs migration ready";"Summary - VMs migration ready - no CD/DVD/Floppy connected" 441000000000061;"Summary - VMs NOT migration ready";"Summary - VMs NOT migration ready - CD/DVD/Floppy connected" 441000000000062;"Detailed - VMs migration ready";"Detailed - VMs migration ready - no CD/DVD/Floppy connected" 441000000000063;"Detailed - VMs NOT migration ready";"Detailed - VMs NOT migration ready - CD/DVD/Floppy connected" 441000000000064;"Registered VMs by Free Space";"Registered VMs by Free Space" 441000000000065;"Registered VMs with Free Space <35%";"Registered VMs with Free Space < 35%" 441000000000066;"Unregistered VMs Free Space <35%";"Unregistered VMs with Free Space < 35%" 441000000000067;"Online VMs (Powered On)";"Online VMs (Powered On)" 441000000000068;"VMs not Powered On";"VMs Not Powered On" 441000000000069;"Offline VMs Never Scanned";"Offline VMs Never Scanned" 441000000000070;"Offline VMs with Snapshot";"Offline VMs with Snapshots" 441000000000071;"VMs without VMware tools";"VMs without VMware tools after SmartState Analysis" 441000000000072;"VMs with old VMware tools";"VMs with old VMware tools" 441000000000073;"VMware Tools Versions";"VMware Tools Versions" 441000000000074;"VMs with EVM Snapshots";"VMs with EVM Snapshots" 441000000000075;"VMs with Consolidate Helper Snapshots";"VMs with Consolidate Helper Snapshots" 441000000000076;"EVM Server UserID Usage Report";"EVM Server UserID Usage Report" 441000000000077;"EVM Server UserIDs Never Used";"EVM Server UserIDs Never Used" 441000000000078;"Cluster - DRS migrations";"Cluster - DRS migrations" 441000000000079;"VC Snapshot Events by User";"Summary of VC Snapshot Events by User" 441000000000080;"VMs with Volume Free Space >= 75%";"VMs with Volume Free Space >= 75% (sorted by Datastore)" 441000000000081;"VMs with disk free space > 5GB";"VMs with disk free space > 5GB (sorted by disk free space)" 441000000000082;"VM Uptime - longest running";"VM Uptime (based on last boot, sorted by VM uptime)" 441000000000083;"VMs Powered Off registered to a Host";"VMs Powered Off but registered to Host (sorted by boot time)" 441000000000084;"VMs pending Retirement";"VMs that are pending Retirement" 441000000000085;"VMs that are Retired";"VMs that have been Retired (past retirement date)" 441000000000086;"VMs with invalid allocation of RAM";"VMs with invalid allocation of RAM (32-bit > 4GB allocated)" 441000000000087;"Summary of VM Create and Deletes";"Summary of VM Create and Deletes" 441000000000088;"VM Relationships";"VM Relationships" 441000000000089;"Folder to VMs Relationships";"Folder to VMs Relationships" 441000000000090;"Cluster Relationships";"Cluster Relationships" 441000000000091;"Operations VMs Powered On/Off for Last Week";"Operations VM Power On/Off Events for Last Week" 441000000000092;"Events for VM prod_webserver";"Summary of all VC Events for VM prod_webserver" 441000000000112;"Cluster memory trend 6 months";"Cluster memory trend based on past 6 months" 441000000000093;"Reconfigure Events by Department";"All Reconfigure Events for Department Classified VMs" 441000000000094;"VC Events initiated by username EVM86";"Virtual Center Events initiated by username EVM" 441000000000095;"Policy Events for Last Week";"Policy Events for Last Week" 441000000000096;"Policy Events2 for Last Week";"Policy Events2 for Last Week" 441000000000097;"Host CPU Usage per VM";"Host CPU Usage per VM" 441000000000098;"VM Performance - daily over last week";"VM Performance - daily averages for last week" 441000000000099;"VMs with Max Daily Mem > 50% (past mo.)";"VMs with Maximum Daily Memory Burst > 50% over past month" 441000000000100;"VMs with Avg Daily Mem < 50% (past mo.)";"VMs with Average Daily Memory Usage < 50% over last month" 441000000000101;"VMs with Avg Daily CPU > 85% (past mo.)";"VMs with Average Daily CPU Usage > 85% over last month" 441000000000102;"VMs with Max Daily CPU > 85% (past mo.)";"VMs with Maximum Daily CPU Usage > 85% over last month" 441000000000103;"VMs with Avg Daily Mem > 95% (past mo.)";"VMs with Average Daily Memory Usage > 95% over last month" 441000000000104;"All Departments with Performance";"All Departments with Performance for last week" 441000000000113;"Cluster CPU Trends (last week)";"Cluster CPU Utilization trends (last week)" 441000000000105;"Top CPU Consumers (weekly)";"Top CPU Consumers (weekly)" 441000000000106;"Top Memory Consumers (weekly)";"Top Memory Consumers (weekly)" 441000000000107;"Top Storage Consumers";"Top Storage Consumers" 441000000000108;"VM Resource Utilization";"VM Resource Utilization" 441000000000109;"Weekly Utilization Overview";"Weekly Utilization Overview" 441000000000110;"Cluster Memory and CPU Usage (7 days)";"Cluster Memory and CPU usage over last 7 days" 441000000000111;"Processes for prod VMs sort by CPU Time";"Processes for prod VMs sorted by CPU Time" 441000000000114;"Cluster I/O Trends (last week)";"Cluster I/O Utilization Trends (last week)" 441000000000115;"Cluster Memory Trends (last week)";"Cluster Memory Utilization Trends (last week)" 441000000000116;"Datastore Capacity Trend over 6 mos.";"Datastore Capacity Trend over the last 6 months" 441000000000117;"Host Peak CPU Used Trend over 6 mos.";"Host Peak CPU Used Trends over last 6 Months" 441000000000118;"Host Peak Memory Used Trends for 6 Mos.";"Host Peak Memory Used Trends over last 6 Months" 441000000000119;"Host CPU Trends (last week)";"Host CPU Utilization trends (last week)" 441000000000120;"Host I/O Trends (last week)";"Host I/O Utilization Trends (last week)" 441000000000121;"Host Memory Trends (last week)";"Host Memory Utilization Trends (last week)" 441000000000122;"Provisioning Activity - by Approver";"Provisioning Activity - by Approver" 441000000000127;"Hosts: Compare Template";"Host Compare Template" 441000000000123;"Provisioning Activity - by Datastore";"Provisioning Activity - by Datastore" 441000000000124;"Provisioning Activity - by Requester";"Provisioning Activity - by Requester" 441000000000125;"Provisioning Activity - by VM";"Provisioning Activity - by VM Approved Date" ===== *** This bug has been marked as a duplicate of bug 1279603 *** |