Freigeben über

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

  1. Go to the Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb job

  2. Right Click and go to Properties

  3. Go to steps

  4. Go to OperateOnInstsOnMaster, and double click.

  5. Edit the text “ exec ops_OperateOnInstancesOnMasterMsgBox 'ServerName,Port' ,'BizTalkMsgBoxDb' ”

Hope this helps..!!

 

Written by
Rasika Chaudhary

Reviewed By
Jainath V R

Microsoft GTSC India

Comments

  • Anonymous
    February 16, 2014
    I got the same issue. Thanks to your blog, I have resolved it.