CODEWITHSUNDEEP
biztalkbiztalk2006r2
SqlRyan
SqlRyan

Reputation: 33914

Set up notifications when Biztalk send/receive ports stop or are disabled

We have a Biztalk 2006 R2 server, and from time to time, the receive ports will change to "Disabled" status for any one of a number of reasons - most commonly, server maintenance elsewhere on the network causes the file share they point to to become unavailable, so it stops the port. This causes trouble when transmissions we expect to happen every day no longer happen due to the stopped port, since it doesn't automatically start up again on its own.

Is there a native way to set up alerts when these ports stop, or do I need to write a job that queries the SQL Server directly and emails me when the port status changes in the database?

Upvotes: 4

Views: 2645

Answers (4)

Ashish Kapoor
Ashish Kapoor

Reputation: 51

You can create trigger on dbo.bts_sendport and [dbo].[adm_ReceiveLocation] on after update to get an alert once state changed

Upvotes: 1

WiredEarp
WiredEarp

Reputation: 413

Old thread, but in case its helpful to people still: Minotaur will not restart the ports, but will monitor you when they go down. Not sure about Helium and Bizmon. However, when a port is disabled, an event 'xxx port is shutting down' is written to the event log. If you just trap this event message using a script or code (I used C#) you can then add the failed port to a delay timer and attempt to restart it after a set interval. I do this and have it set so after X retries, it emails the administrator so he can manually check things.

Upvotes: 0

StuartLC
StuartLC

Reputation: 107247

If you have Systems Centre Operations Manager, you can download the BizTalk SCOM Pack. You can monitor receive ports under the Receive Ports State View.

There are also some other BizTalk monitoring tools - Bizmon, Minotaur and Helium. Steef Jan Wiggers evaluates them here

Upvotes: 1

Igal Serban
Igal Serban

Reputation: 10684

There is no native way. But there are examples in the SDK directory ( under biztalk) of vb scripts that starts receive location. You can schedule a job that will run every minute and will query the status of the receive location, and start it if necessary.

Upvotes: 1

Related Questions