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