CODEWITHSUNDEEP
c#biztalkbiztalk-2016
Navaneet
Navaneet

Reputation: 1387

BizTalk WCF-SQL Receive location started polling in both server in Multi-Server environment

I have a BizTalk receive location which is WCF-SQL. I have scheduling in this receive location to run daily at 9 am to 9:30 am. Also i have Typed polling which checks for a table. This works fine in BizTalk single server. But in multi server environment(2 servers) I see that receive location is started polling in both server with around 30 seconds difference. Is this expected behaviour. In case SFTP adapter this is expected and we use clustered host instance to avoid it.

So is this expected in WCF-SQL port as well?

Upvotes: 1

Views: 569

Answers (1)

Dijkgraaf
Dijkgraaf

Reputation: 11527

Yes, this is expected behaviour for the WCF-SQL adapter, and as you noted, SFTP, also FTP(s), MSMQ and POP3. All of these adapters need to run on a host instance that is clustered in a multi-node environment to avoid duplicates.

See Considerations for Running Adapter Handlers within a Clustered Host , which unfortunately does not specify WCF-SQL, and the older article Clustering Receiving Hosts only mentions the older SQL adapter and also the old SAP adapter.

Upvotes: 3

Related Questions