Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

Error message after you install the Systems Management Server 2003 site database on Microsoft SQL Server 2005: Message ID : 619

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 923116 - Last Review: November 15, 2006 - Revision: 1.3

Error message after you install the Systems Management Server 2003 site database on Microsoft SQL Server 2005: "Message ID : 619"

View products that this article applies to.

SYMPTOMS

After you install the Microsoft Systems Management Server (SMS) 2003 site database on Microsoft SQL Server 2005, you may receive the following site server status error message:
Type Milestone
Severity: Warning
Message ID : 619
ProcessID: 722
Trhead ID: 6344
Component: SMS_STATUS_MANAGER

Microsoft SQL Server reported SQL message 102, severity 15: [42000][102][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'd'. : sp_InsStatusMessageAttribute
Additionally, new site status messages are not inserted into the site database. The Inboxes\Statmgr.box\Retry folder contains a backlog of .sql files.

The Statmgr.log file may contain the following entries:
*** exec sp_InsStatusMessageAttribute 63,14176,402,'CCP00013','date
time',14177,402,'sitecodecollection increment number','date
time',14178,402,'sitecodecollection increment number','datetime',14179,402,'sitecodecollection increment number','date
time',14180,402,'sitecodecollection increment number,'date
time',14181,402,'sitecodecollection increment number','date
--Entries omitted for space--
time',14236,402,'SMScollection ID',' date
time' SMS_STATUS_MANAGER date time 4144 (0x1030)

*** [42000][102][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'd'. : sp_InsStatusMessageAttribute SMS_STATUS_MANAGER date time 4144 (0x1030)
ERROR: Could not add a SQL command to the transaction. Most likely, there is a problem with the SQL server or our connection to it. The transaction will be rolled back. SMS_STATUS_MANAGER date time 4144 (0x1030)
Note To install the SMS 2003 site database on SQL Server 2005, you must have SMS 2003 Service Pack 2 installed.
Back to the top

RESOLUTION

To resolve this issue, apply the hotfix described in the following Microsoft Knowedge Base article:
925335   (http://kbalertz.com/Feedback.aspx?kbNumber=925335/ ) FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: "Incorrect syntax near 'X'"
Back to the top

WORKAROUND

You may experience an error when you try to install the database of the SMS 2003 site on SQL server 2005. To resolve this problem, the final action in the IF clause must be enclosed in a BEGIN/END statement. To do this, follow these steps:
  1. Open SQL Server Management Studio, expand Databases, expand System Databases, expand SMS Site Database, expand Programmability, and then expand Stored Procedures.
  2. Right-click sp_InsStatusMessageAttribute.
  3. Point to Script Stored Procedures, point to Alter to, and then click New Query Editor Window.
  4. Find the following section at the end of the procedure.
    IF (@NumRows < 63) GOTO done
     IF (SELECT RecordID FROM StatusMessageAttributes WHERE RecordID = @RecordID_63 
AND AttributeID = @AttributeID_63 AND AttributeValue = @AttributeValue_63) IS 
NULL
         INSERT INTO StatusMessageAttributes VALUES (@RecordID_63, @AttributeID_63, 
@AttributeValue_63, @Time_63)     done: END
GO
  5. Add a BEGIN/END statement to the INSERT section that resembles the following statement. 
    IF (@NumRows < 63) GOTO done
     IF (SELECT RecordID FROM StatusMessageAttributes WHERE RecordID = @RecordID_63 
AND AttributeID = @AttributeID_63 AND AttributeValue = @AttributeValue_63) IS 
NULL
         BEGIN INSERT INTO StatusMessageAttributes VALUES (@RecordID_63, 
@AttributeID_63, @AttributeValue_63, @Time_63)  END   done: END
GO
  6. Click Execute, and then close SQL Server Management Studio.
If there is a backlog of .sql files in the retry folder, SMS tries to process the oldest file every 10 minutes. After this stored procedure is modified, the backlog can be processed without restarting either SQL Server or SMS.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
  • Microsoft Systems Management Server 2003 Service Pack 2
Back to the top
Keywords: 
kberrmsg kbsmsadmin kbtshoot kbprb KB923116
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting