BizTalk Job: Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb Failing
Recently, I came across an issue, in which, the Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb job was failing with the following error:
Error:
Executed as user: ABC\UserName.
The name 'ServerName.ABC.com,portNumber.BizTalkMsgBoxDb.dbo.ops_OperateOnInstanceOnMasterMsgBox ' is not a valid identifier. [SQLSTATE 42000] (Error 203). The step failed.
After doing some troubleshooting using SQL Profiler, we saw that following command was getting executed at the SQL Server Side:
Exec 'ServerName.ABC.com,portNumber.BizTalkMsgBoxDb.dbo.ops_OperateOnInstanceOnMasterMsgBox 3 ID {ID }
On doing some further research, we came to know the issue was with using Fully Qualified Domain Name during the configuration of the Job.
Resolution
Go to the Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb job
Right Click and go to Properties
Go to steps
Go to OperateOnInstsOnMaster, and double click.
Edit the text “ exec ops_OperateOnInstancesOnMasterMsgBox 'ServerName,Port' ,'BizTalkMsgBoxDb' ”
Hope this helps..!!
Written by
Rasika Chaudhary
Reviewed By
Jainath V R
Microsoft GTSC India