Hi,

I have an orchestration that first receives data from a stored procedure (Me
ssage1). I then take that data, transform it (Message2) & insert it into ano
ther database via a stored procedure. The stored procedure inserts the data 
from Message2 & returns a n
ew message (Message3) which contains an element called "IDNO" that is return
ed as a result of the stored procedure. I then want to take the "IDNO" value
 from Message3 and combine it with Message1 (since there are still many elem
ents contained in Message1
that I still need to insert into other database tables) and do a transform t
o create Message4 that inserts into my second database table.

My problem is that when I open the transform configuration wizard, I select 
Message1 for my first source transform, click the "Click here to add a new r
ow!" display message & add Message3 as my second source transform (which is 
my "IDNO" message returned
from my previous stored procedure).  I then add Message4 as my destination t
ransform.  When I hit OK, Biztalk launches my new transformation map.  My so
urce schema shows 2 message parts...InputMessagePart_0 and InputMessagePart_
0.  InputMessagePart_0 cont
ains all the expected data elements from my original Message1 but ImputMessa
gePart_1 just contains the element "ns1:" and does not contain the expected 
data from Message3.  Now, if I delete the transformation map & go back throu
gh the whole transform conf
iguration wizard process & add Message3 first & then Message1 for my source 
transform, when Biztalk opens the new tranformation map, Message3 will now s
how up as InputMessagePart_0 with all the expected data elements and InputMe
ssagePart_1 still just has
the "ns1:" element w/o the expected data from Message1. Why does InputMessag
ePart_1 never contain the data from the second transform source that I speci
fied when using the Transform Configuration Wizard?

Any help is greatly appreciated!!

[ Post a follow-up to this message ]

Mike,
This looks like a bug in the mapper file generation. This happens when both
the input messages you are choosing have same TargetNamespace. When working
with multiple input messages, the mapper creates an aggregate schema,
combining the input messages into a single enveloping schema and embeds
this schema inside the map file.  While generating this enveloping schema,
it does not create the <xs:import  > element for the messages other than
the first input message.   This only happens when the input message schamas
all  belong to the same TargetNamespace.

You can fix this easily by opening the .btm file in notepad and insert the
missing <xs:import> element (that should import the second schema) by
cloning the <xs:import> element that was generated for the first schema.
Your should then work properly.

Thanks...


--------------------[vbcol=seagreen] 
(Message1). I then take that data, transform it (Message2) & insert it into
another database via a stored procedure. The stored procedure inserts the
data from Message2 & returns a new message (Message3) which contains an
element called "IDNO" that is returned as a result of the stored procedure.
I then want to take the "IDNO" value from Message3 and combine it with
Message1 (since there are still many elements contained in Message1 that I
still need to insert into other database tables) and do a transform to
create Message4 that inserts into my second database table.[vbcol=seagreen] 
select Message1 for my first source transform, click the "Click here to add
a new row!" display message & add Message3 as my second source transform
(which is my "IDNO" message returned from my previous stored procedure).  I
then add Message4 as my destination transform.  When I hit OK, Biztalk
launches my new transformation map.  My source schema shows 2 message
parts...InputMessagePart_0 and InputMessagePart_0.  InputMessagePart_0
contains all the expected data elements from my original Message1 but
ImputMessagePart_1 just contains the element "ns1:" and does not contain
the expected data from Message3.  Now, if I delete the transformation map &
go back through the whole transform configuration wizard process & add
Message3 first & then Message1 for my source transform, when Biztalk opens
the new tranformation map, Message3 will now show up as InputMessagePart_0
with all the expected data elements and InputMessagePart_1 still just has
the "ns1:" element w/o the expected data from Message1. Why does
InputMessagePart_1 never contain the data from the second transform source
that I specified when using the Transform Configuration Wizard?[vbcol=seagreen] 

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

[ Post a follow-up to this message ]