Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-10197: Error Appears When Refreshing the Report Services Database: Failure during computation. The item already exists.

Authentication Service ,  

16 May,18 at 08:23 PM

Problem:
  
When running the Report Services Sync, the rebuild of the database fails.  The error that appears in the General tab is:
   
Failure during computation
Reason: The item already exits
 
User-added image

Cause:
  
This can be caused by obsolete data that exists in the database of Report Services.

Resolution:

1) Confirm that obsolete data exists is the database by downloading that attached diagnostic_tool.sql and running the query on the report server database using the Microsoft SQL Server Management Studio.  If the query returns data, as seen in the image below, there is obsolete data in the database:
 
User-added image
  
2) Run the following SQL statement in SQL Server Management Studio directly to remove the obsolete data
 
exec RawData.RemoveDomain <domain id>
 
3) Force rebuild the Report Services Database using the Report Services Control Panel.
  
User-added image
Attachments:
diagnostic_tool.sql

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.

Related Articles

 articleKB-6056: How to report the group policy settings that are in effect for the local computer? articleKB-6041: How to show current license type in use by adclient articleKB-6040: How to change the license type in use after adclient successful joined to the AD? articleKB-6038: How to specify the license type to use when joining the server to AD using adjoin? articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-7555: Unable to login as root after upgrade to Centrify Suite 2016 (CDC 5.3.0) articleKB-3925: How to add Centrify parameter to a group policy articleKB-7066: Configuring Centrify Report Services for Large Active Directory Environments articleKB-1311: Collector unable to connect to SQL database