When clicking the Dashbaord Incidents and Reports tab the web browser returns an error and the screen is blank
Originally Published: 2013-07-11
Article Number
Issue
Error in em.log: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
at org.hibernate.impl.AbstractQueryImpl.uniqueElement
Cause
Resolution
-- verify before deleting
select count(*) from s_table_columns where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from s_search_schedule where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from s_parameter_values where parameter_id IN (select parameter_id from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>));
select count(*) from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from r_sql_statement where report_definition_id IN (select report_definition_id from r_report_definition where owner_id = <owner_id>);
select count(*) from r_parameter_values where parameter_id IN( select parameter_id from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id>));
select count(*) from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id> );
select count(*) from r_report_schedule where report_id IN (select report_id from r_report where owner_id = <owner_id> );
select count(*) from r_favorite_report where user_id = (select local_user from u_owner where owner_id = <owner_id> );
select count(*) from r_report where owner_id = <owner_id> ;
select count(*) from r_report_definition where owner_id = <owner_id>;
select count(*) from s_search where owner_id = <owner_id>;
GO
--- below statements are to delete records from u_owner tables
delete from s_table_columns where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from s_search_schedule where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from s_parameter_values where parameter_id IN (select parameter_id from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>));
delete from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from r_sql_statement where report_definition_id IN (select report_definition_id from r_report_definition where owner_id = <owner_id>);
delete from r_parameter_values where parameter_id IN( select parameter_id from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id>));
delete from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id> );
delete from r_report_schedule where report_id IN (select report_id from r_report where owner_id = <owner_id> );
delete from r_favorite_report where user_id = ( select local_user from u_owner where owner_id = <owner_id> );
delete from r_report where owner_id = <owner_id>;
delete from r_report_definition where owner_id = <owner_id>;
delete from s_search where owner_id = <owner_id>;
-- delete records from owner table
delete from u_owner where owner_id = <owner_id>;
GO
select count(*) from s_table_columns where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from s_search_schedule where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from s_parameter_values where parameter_id IN (select parameter_id from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>));
select count(*) from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>);
select count(*) from r_sql_statement where report_definition_id IN (select report_definition_id from r_report_definition where owner_id = <owner_id>);
select count(*) from r_parameter_values where parameter_id IN( select parameter_id from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id>));
select count(*) from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id> );
select count(*) from r_report_schedule where report_id IN (select report_id from r_report where owner_id = <owner_id> );
select count(*) from r_favorite_report where user_id = (select local_user from u_owner where owner_id = <owner_id> );
select count(*) from r_report where owner_id = <owner_id> ;
select count(*) from r_report_definition where owner_id = <owner_id>;
select count(*) from s_search where owner_id = <owner_id>;
GO
--- below statements are to delete records from u_owner tables
delete from s_table_columns where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from s_search_schedule where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from s_parameter_values where parameter_id IN (select parameter_id from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>));
delete from s_parameters where search_id IN (select search_id from s_search where owner_id = <owner_id>);
delete from r_sql_statement where report_definition_id IN (select report_definition_id from r_report_definition where owner_id = <owner_id>);
delete from r_parameter_values where parameter_id IN( select parameter_id from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id>));
delete from r_parameters where report_id IN (select report_id from r_report where owner_id = <owner_id> );
delete from r_report_schedule where report_id IN (select report_id from r_report where owner_id = <owner_id> );
delete from r_favorite_report where user_id = ( select local_user from u_owner where owner_id = <owner_id> );
delete from r_report where owner_id = <owner_id>;
delete from r_report_definition where owner_id = <owner_id>;
delete from s_search where owner_id = <owner_id>;
-- delete records from owner table
delete from u_owner where owner_id = <owner_id>;
GO
Related Articles
RSA Authentication Agent 7.x and 8.x for Web for IIS WebID (IISWebAgentIF.dll) display a blank screen redirect Number of Views Select an Integration Path for Authentication Manager and Cloud Access Service Number of Views RSA Authentication Manager 8.x running on Hyper V enters maintenance mode. Failed to start file system check on /dev/dis..… Number of Views RSA SecurID Software Token for Microsoft Windows shows blank screen when asked to select a device where the token will be … Number of Views How to replace the RSA Authentication Manager self signed console certificate with a signed certificate from Microsoft Act… Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
