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  >

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

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

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


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