Error message when you try to re-publish a briefing book in ProClarity Professional: "An item with this name already exists"

Article translations Article translations
Article ID: 934076 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you try to re-publish a briefing book in ProClarity Desktop Professional or in ProClarity Web Professional, you receive the following error message:
An item with this name already exists.
Additionally, you may experience the following symptoms:
  • When you delete a book in Desktop Professional, you receive OLE exception 80040e21.
  • When you delete a My Views folder or item, you receive exception 80040e21 in the ProClarity Event Log.
  • When you delete or modify security roles in the Administrator Tool, you receive OLE exception 80040e21.

CAUSE

This issue may occur if the name of the computer that is running Microsoft SQL Server has changed. ProClarity Analytics Server uses a database in SQL Server to store information about the users, the queries, and the server configurations. If the name of the computer that is running SQL Server changes, SQL Server will corrupt internal information about the computer name.

RESOLUTION

Note To verify the internal information about the computer name, run the following SQL queries.
select @@servername
USE master; 
GO 
EXEC sp_helpserver

If the values that are returned by the queries are not identical, you are experiencing the issue that is mentioned in the "Symptoms" section. To resolve this issue, follow these steps:
  1. Run the following command to clear out existing server name information.
    sp_dropserver @server = '<serverName>'
  2. Run one of the following commands to add the correct name of the server.

    Note To find the correct local server name, click Start, right-click My Computer, and then click the Computer Name tab.
    sp_addserver '<machineName>\<instanceName>', local
    sp_addserver '<machineName>', @local= 'local'
  3. Restart the SQL service.
  4. Restart the IIS service on the computer that is running ProClarity Analytics Server.
  5. Restart ProClarity Professional, and then retest publishing.

Properties

Article ID: 934076 - Last Review: August 28, 2007 - Revision: 2.0
APPLIES TO
  • ProClarity Desktop Professional 6.1
  • ProClarity Web Professional 6.1
  • ProClarity Desktop Professional 6.2
  • ProClarity Web Professional 6.2
Keywords: 
kberrmsg kbtshoot kbexpertiseinter kbprb KB934076

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com