RE: BizTalk 2006, clustered dbs, failover problems



Which, to be fair, is a good idea anyway - I would really recommend using two
way patterns whereever possible - so you can provide some feedback to the
sender of the message as to whether you intend to process that message or not.
--
Yossi Dahan
http://www.sabratech.co.uk/blogs/yossidahan


"Mike" wrote:

Thank you very much for your answer.

As a matter of fact, the messages come from a web service, using the WCF
adapter.
Unfortunately for me, it is a one-way service so I may have to rethink that
now.


Best regards,

/Mike


"Yossi Dahan" wrote:

The messaging engine does not keep the messages anywhere but the messagebox,
so if the database is not available it would be impossible for BizTalk to
start processing incoming messages so there's no way to "keep" them anywhere.

If you're using a two-way scenario, for example if you're using the SOAP or
HTTP adapters BizTalk will kindly (?) notify the caller it failed processing
the message.

The scenario might not be as clean for implementations such as the File
adapter, although I believe that without SQL the adapters won't pick up files
either.
--
Yossi Dahan
http://www.sabratech.co.uk/blogs/yossidahan


"Mike" wrote:

Hello everyone,

I have searched a solution to this problem but I couldn't find one so I
apologize if it has already been answered. Also, I am new to BizTalk.

I have a problem with lost messages occuring during SQL database failover.

My setup is as follows:

* BizTalk host running outside cluster.
* Two in-process hosts, running on separate machines.
* Mgmt, Tracking, MsgBox dbs are running on SQL 2005 inside cluster, in the
same group.

During failover, the host does not seem to receive any messages and I see a
lot of errors in the event log (6912, 6913, 5677, 5739, 5634), all indicating
problems accessing the database.

I realize that when the database is down it's impossible to access it, but
is there anything I can do to prevent me from losing incoming messages?


Best regards,

Mike

.



Relevant Pages

  • RE: Very odd behaviour of our receivehost (bts2006 R2)
    ... I know biztalk heavily relies on AD... ... It's not the isolated receive host, it's the 'normal' receive host that is ... receivehost after that and still this sometimes doesn't help, ... It's my impression that the adapters I installed (AX2009 biztalk adapter ...
    (microsoft.public.biztalk.general)
  • Re: Adapter Error on non-default host
    ... Mine had to do with some custom adapters dying _only_ when moved to the non-default BizTalk host. ... Mine worked fine on the 'old' web soap service generated. ... When your issue originally came up, did things work okay on the default host for the BizTalk group but not on other hosts in the group, or did it fail in all cases? ... since my issue only pops up when the adapter is associated with the non-default host. ...
    (microsoft.public.biztalk.general)
  • Re: New to Biztalk! Please help.
    ... (messages or file drops or RPC calls or web service calls... ... Biztalk can be easily configured to respond to these events. ... write an adapter that reads the db looking for new or updated records. ... When you are writing to your database, ...
    (microsoft.public.biztalk.general)
  • Re: Adapter Error on non-default host
    ... When your issue originally came up, did things work okay on the default host for the BizTalk group but not on other hosts in the group, or did it fail in all cases? ... since my issue only pops up when the adapter is associated with the non-default host. ... Well when I looked at the SoapreturnMsg I found that a second xml declaration was being added to the msg. ...
    (microsoft.public.biztalk.general)
  • Re: OutOfMemoryException in ReceiveLocation
    ... It depends on what you are doing with the records but if you can work with smaller chunks of data, BizTalk will perform better overall. ... I have a ReceivePort to read 80000 records from an oracle database ... Event Type: Error ... The adapter "DATABASE" raised an error message. ...
    (microsoft.public.biztalk.general)

Loading