Mazz,
These are the messages I see on the server side related to the invalid
alert definition:
2011-08-19 13:08:44,744 ERROR
[org.rhq.enterprise.server.resource.ResourceManagerBean] Bulk named
query delete error for 'AlertCondition.deleteByResources' for [10772]:
org.hibernate.exception.ConstraintViolationException: could not execute
update query
2011-08-19 13:08:44,758 WARN [org.hibernate.util.JDBCExceptionReporter]
SQL Error: 0, SQLState: 23503
2011-08-19 13:08:44,758 ERROR [org.hibernate.util.JDBCExceptionReporter]
ERROR: update or delete on table "rhq_alert_definition" violates foreign
key constraint "rhq_alert_condition_alert_definition_id_fkey" on table
"rhq_alert_condition"
Detail: Key (id)=(10031) is still referenced from table
"rhq_alert_condition".
2011-08-19 13:08:44,758 ERROR
[org.rhq.enterprise.server.resource.ResourceManagerBean] Bulk named
query delete error for 'AlertDefinition.deleteByResources' for [10772]:
org.hibernate.exception.ConstraintViolationException: could not execute
update query
2011-08-19 13:08:44,778 INFO
[org.rhq.enterprise.server.scheduler.jobs.AsyncResourceDeleteJob] Async
resource deletion - 2 successful, 0 failed, took [304] ms
These are the types of messages I see for the global exception. These
happen whenever the UI tries to display recent alerts, either on the
Dashboard or the Summary tab for a particular resource. I also notice
that Reports -> Alert Definitions lists some alert definitions that are
no longer valid and if I click on their links I get a blank Inventory
tab. I tried squinting at the traceback below to find the associated
source, but I wasn't sure what to do when I got there. ;-)
Message :
Globally uncaught exception
Severity :
Error
Time :
Friday, August 19, 2011 1:30:28 PM Etc/GMT+4
Detail :
java.lang.NumberFormatException:For input string: "[From:Aug 18, 2011
3:09:56 PM, To:Aug 18, 2011 3:11:01 PM, MAX:33929.0],
extraInfo=[/seam-booking/debug.seam]"
--- STACK TRACE FOLLOWS ---
For input string: "[From:Aug 18, 2011 3:09:56 PM, To:Aug 18, 2011
3:11:01 PM, MAX:33929.0], extraInfo=[/seam-booking/debug.seam]"
at
Unknown.java_lang_NumberFormatException_$NumberFormatException__Ljava_lang_NumberFormatException_2Ljava_lang_String_2Ljava_lang_NumberFormatException_2(Unknown
source:0)
at
Unknown.java_lang_Number__1_1parseAndValidateDouble__Ljava_lang_String_2D(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_convert__Lorg_rhq_core_domain_alert_Alert_2Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_copyValues__Ljava_lang_Object_2Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_util_RPCDataSource_copyValues__Ljava_lang_Object_2ZLcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_util_RPCDataSource_$buildRecords__Lorg_rhq_enterprise_gui_coregui_client_util_RPCDataSource_2Ljava_util_Collection_2Z_3Lcom_smartgwt_client_widgets_grid_ListGridRecord_2(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$8_onTypesLoaded__Ljava_util_Map_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository_$getResourceTypes__Lorg_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository_2_3Ljava_lang_Integer_2Ljava_util_EnumSet_2Lorg_rhq_enterprise_gui_coregui_client_inventory_resource_type_ResourceTypeRepository$TypesLoadedCallback_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_$dataRetrieved__Lorg_rhq_enterprise_gui_coregui_client_alert_AlertDataSource_2Lorg_rhq_core_domain_util_PageList_2Lcom_smartgwt_client_data_DSResponse_2Lcom_smartgwt_client_data_DSRequest_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_dashboard_portlets_recent_alerts_AbstractRecentAlertsPortlet$AlertsPortletDataSource_dataRetrieved__Lorg_rhq_core_domain_util_PageList_2Lcom_smartgwt_client_data_DSResponse_2Lcom_smartgwt_client_data_DSRequest_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_$onSuccess__Lorg_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_2Lorg_rhq_core_domain_util_PageList_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_alert_AlertDataSource$7_onSuccess__Ljava_lang_Object_2V(Unknown
source:0)
at
Unknown.com_google_gwt_user_client_rpc_impl_RequestCallbackAdapter_$onResponseReceived__Lcom_google_gwt_user_client_rpc_impl_RequestCallbackAdapter_2Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_Response_2V(Unknown
source:0)
at
Unknown.org_rhq_enterprise_gui_coregui_client_util_rpc_TrackingRequestCallback_onResponseReceived__Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_Response_2V(Unknown
source:0)
at
Unknown.com_google_gwt_http_client_Request_$fireOnResponseReceived__Lcom_google_gwt_http_client_Request_2Lcom_google_gwt_http_client_RequestCallback_2V(Unknown
source:0)
at
Unknown.com_google_gwt_http_client_RequestBuilder$1_onReadyStateChange__Lcom_google_gwt_xhr_client_XMLHttpRequest_2V(Unknown
source:0)
at Unknown.anonymous(Unknown source:0)
at
Unknown.com_google_gwt_core_client_impl_Impl_entry0__Ljava_lang_Object_2Ljava_lang_Object_2Ljava_lang_Object_2Ljava_lang_Object_2(Unknown
source:0)
at Unknown.anonymous(Unknown source:0)
at Unknown.anonymous(Unknown source:0)
On 8/19/2011 6:14 AM, John Mazzitelli wrote:
> I assume this is my problem. I know I have some "bad"
alert
> data hanging around int he database--is there a way to purge it? Do I
> have to reset the database somehow?
Probably, unless you can do some sleuthing in your database and execute
some SQL to cleanse your bad data.
For reference, can you give more info on the global exception? What is
it? Is this on a page where you are viewing alert details? Or a
configuration editor? Any errors on the server side? Is this something
where we can add code to be less destructive (i.e. maybe just show a
blank value due to the bad data but still let you render the rest?)
_______________________________________________
rhq-devel mailing list
rhq-devel(a)lists.fedorahosted.org
https://fedorahosted.org/mailman/listinfo/rhq-devel