BizTalk Server General - Multiple subscriptions and submit direct adapter

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > October 2005 > Multiple subscriptions and submit direct adapter





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Multiple subscriptions and submit direct adapter
Vishy

2005-10-03, 6:01 pm

I'm currently facing a problem with multiple subscriptions
I've a SQL Port polling in data at regular interval now I want to fed
this data to orchestration once its in MsgBox DB as well as send a copy
out
When I configure Orchestration to use submit direct adapter to pick up
data directly from MsgBox Db; it doesn' work.
I checked the subscription viewer and it showed me that orchestration
is looking for message of particular schema (which i'm expecting) and
port id(probably the submit receive port id) now SQL adapter does not
submit message to MsgBox using submit direct port; it is not sent to my
orchestration
What is solution for this?

Thanks

Vishy

Tomas Restrepo \(MVP\)

2005-10-03, 6:01 pm

Vishy,

> I'm currently facing a problem with multiple subscriptions
> I've a SQL Port polling in data at regular interval now I want to fed
> this data to orchestration once its in MsgBox DB as well as send a copy
> out
> When I configure Orchestration to use submit direct adapter to pick up
> data directly from MsgBox Db; it doesn' work.
> I checked the subscription viewer and it showed me that orchestration
> is looking for message of particular schema (which i'm expecting) and
> port id(probably the submit receive port id) now SQL adapter does not
> submit message to MsgBox using submit direct port; it is not sent to my
> orchestration
> What is solution for this?


I'm not quite sure I'm understanding your scenario, but, normally, you bind
a receive in an orchestration to a physical receive port. The port can, in
turn, contain multiple receive locations (configured to multiple adapters if
you want) and it will still work.

However, if in your case what you have is two different receive ports (one
with a direct submit location and another with a sql location), then you'll
need to either collapse both ports to a single receive port, or switch the
orchestration to use direct binding.


--
Tomas Restrepo
tomasr@mvps.org
http://www.winterdom.com/


Vishy

2005-10-03, 6:01 pm

Thanks Thomas for reply
Let me simplify my problem
I need to fetch data from SQL server and feed it to more than one
orchestrations
how can I do that; without using file adapter?

thanks

Vishy

Vishy

2005-10-03, 6:01 pm

Using multiple locations in same port solved my problem
thanks for help

Vishy

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com