Error occurs when you run two separate Content Management Server 2002 Site Deployments (842088)

SYMPTOMS

When you run Site Deployment in Microsoft Content Management Server (MCMS) 2002 Service Pack 1 or later, you may receive the following error message in the resulting report:

import Report Report Information Package file: C:\PROGRA~1\MIB84C~1\Server\Temp\sdupload.sdo Generated on: 5/7/2004 3:08:49 PM Report generated by: WinNT://[user logong] Client Machine: MCMS-JAIME Client Version: 5.0.4484.0 Server URL: http://localhost:81/NR/System/Marshalling/ Server Version: 5.0.4484.0 Error Information An error has occurred that has interfered with the generation of this report. Please try the operation again, and contact your system administrator should this error persist. Error ID: -2147352567 Source File: Source Method: .Net SqlClient Data Provider Source Line: 0 Description: Invalid object name '##impNodesToDelete' Recommended Action:

Note The description line may change to point to any other object such as the impAEUser object or the impDeletetable object.

CAUSE

MCMS 2002 creates global temporary objects on the Microsoft SQL Server server. The global temporary objects always carry the same name regardless of the MCMS 2002 server that is running Site Deployment. Therefore, when you run two Site Deployments at the same time, the two deployments collide in the sense that the two Site Deployment applications try to manipulate the same temporary objects at the same time. This behavior causes the error message that is reported.

WORKAROUND

To work around this problem, use one of the following methods:

Only run one Site Deployment at a time if another MCMS 2002 server or other MCMC 2002 servers are pointing to the same SQL Server server.
Move each of your MCMS 2002 databases to separate SQL Server servers.