Monday, September 17, 2007

I was helping a client upgrade their BizTalk Server 2004 machine from an evaluation version of the SAP Adapter to the paid version. We got an interesting error warning in the Application Event Log right after the upgrade:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 9/17/2007
Time: 2:09:03 PM
User: N/A
Computer: XXXXXX
Description:
SQL Server Scheduled Job 'MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb' (0xD3864F44666B084B85AE11128905F6AE) - Status: Failed - Invoked on: 2007-09-17 14:09:03 - Message: The job failed. The Job was invoked by Schedule 19 (Schedule). The last step to run was step 1 (Purge).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

This warning repeated every minute.

The problem was that when we installed the adapter, the job mentioned above had it's owner changed from the local BizTalk administrator to the "regular" BizTalk user. We changed the user to match all of the other BizTalk jobs in SQL, and no more warning messages.