You receive the "Table does not exist" error message during execution of the Microsoft Operations Manager Data Transformation Services package (842562)


The information in this article applies to:

  • Microsoft Operations Manager 2000

SYMPTOMS

While you are executing the Data Transformation Services (DTS) package from the Microsoft Operations Manager (MOM) Resource Kit, the package execution may not succeed, and you receive an error message that is similar to the following:
Table does not exist
This error may occur during the Copy MOMReplicationTimeStamp procedure. Additionally, the MOM Dts.log file may contain an error that is similar to the following:
Copy MOMReplicationTimeStamp: DTSStep_DTSDataPumpTask_1 failed on date time.

CAUSE

This problem typically occurs when the name of a database that is specified in the MOM DTS package contains one or more characters that are not valid. The database may be the source database or the destination database. For example, the name of the source database contains a blank space or a dash character.

RESOLUTION

To resolve this problem, do not use any special characters in the names of the source databases or the destination databases that are specified in the MOM DTS package.

The following file is available for download from the Microsoft Download Center:
DownloadDownload the MOM DTS package now.

The MOM DTS package includes the Microsoft Operations Manager SP1 Deployment Guide. We recommend that you follow the steps in the chapter that is titled Creating a MOM Data Warehouse for Long-term Reporting. This chapter suggests that you use the name MOM_DATA for the data database and that you use the name MOM_HOLDING for the holding databases. For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

STATUS

This behavior is by design.

MORE INFORMATION

The MOM DTS tool transfers data between the MOM database and a separate database that is offline. This separate database can be used for long-term data retention, for long-term trending, for additional reporting, and for keeping the MOM database well maintained.

For more information and to download the MOM Resource Kit, visit the following Microsoft Web site:

http://www.microsoft.com/mom/downloads/reskit/default.asp

Modification Type:MinorLast Reviewed:6/13/2005
Keywords:kbfile kbDownload kbprb KB842562 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.