Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 817769

Summary: [ovirt-reports] - Dashboards are stuck loading (SQL_Query_Executor_context)
Product: [Retired] oVirt Reporter: David Botzer <dbotzer>
Component: ovirt-engine-reportsAssignee: Yaniv Lavi <ylavi>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: acathrow, bazulay, dyasny, iheim, mgoldboi, pstehlik, ykaul
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-19 00:41:11 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:
Attachments:
Description Flags
server.log none

Description David Botzer 2012-05-01 08:07:56 UTC
Created attachment 581311 [details]
server.log

Description of problem:
Only System-Dashboard is working correctly
The other two Dashboards - Datacenter & Cluster are stuck in loading process

Version-Release number of selected component (if applicable):
ovirt-engine-3.1.0_0001-6.el6ev.x86_64
ovirt-dwh-3.0.0-1.fc16.noarch

How reproducible:
Always

Steps to Reproduce:
1.Open Reports GUI - jasperserver-pro
2.Examine the Dashboards

Actual results:
Datacenter & Cluster Dashboards are stuck in loading process

Expected results:
Work correctly

Additional info:

org.owasp.esapi.errors.ValidationException:
SQL_Query_Executor_context:
Invalid input. Please conform to regex ^\s*((?i)select)\s+[^;]+$ with a
maximum length of 50000

server.log (jboss log)

Comment 1 David Botzer 2012-05-06 09:17:40 UTC
Changed to openjdk 1.7.0, on both Reports (J-Pro) Host & Engine (SI2.1)

The Dashboards are working fine using the Reports UI directly,
But still not working at all via Webadmin,

Engine.log gives - 
2012-05-06 12:05:22,208 ERROR [org.ovirt.engine.core.bll.SearchQuery] (http--0.0.0.0-8080-5) Query SearchQuery failed. Exception message is null

Comment 2 Itamar Heim 2012-12-19 00:41:11 UTC
Closing old bugs. If this issue is still relevant/important in current version, please re-open the bug.