|
Home > Archive > BizTalk Server General > July 2005 > Its not taking the decisions.
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 |
Its not taking the decisions.
|
|
| Luis Esteban Valencia 2005-07-22, 7:52 am |
| Hello. I did an orchestration its supposed to route all London Customers to
one folder and non Londo Customers should bot be dropped on that folder.
Anyway all the customers are being dropped in London Folder.
This is what I did.
1. Generated a schema from select * from customers in sql server.
2. Dragged a receive shape and port.
3. I created another schema with less fields than the original one. and
transformed the original message to this new one. Its supposed that the
files dropped on thefolder must be of this structure and they are not, they
are the same as before.
This is the generated schema.
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
attributeFormDefault="unqualified" elementFormDefault="qualified"
targetNamespace="http://SqlReceiveProject" version="1.0"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:annotation>
- <xs:appinfo>
<msbtssql:sqlScript value="select * from customers for xml auto, elements"
xmlns:msbtssql="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Customer">
- <xs:complexType>
- <xs:sequence>
<xs:element xmlns:q1="http://SqlReceiveProject" minOccurs="0"
maxOccurs="unbounded" name="customers" type="q1:customersType" />
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:complexType name="customersType">
- <xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element xmlns:q2="http://SqlReceiveProject" name="CustomerID"
type="q2:CustomerIDType" />
<xs:element xmlns:q3="http://SqlReceiveProject" name="CompanyName"
type="q3:CompanyNameType" />
<xs:element xmlns:q4="http://SqlReceiveProject" name="ContactName"
type="q4:ContactNameType" />
<xs:element xmlns:q5="http://SqlReceiveProject" name="ContactTitle"
type="q5:ContactTitleType" />
<xs:element xmlns:q6="http://SqlReceiveProject" name="Address"
type="q6:AddressType" />
<xs:element xmlns:q7="http://SqlReceiveProject" name="City"
type="q7:CityType" />
<xs:element xmlns:q8="http://SqlReceiveProject" name="Region"
type="q8:RegionType" />
<xs:element xmlns:q9="http://SqlReceiveProject" name="PostalCode"
type="q9:PostalCodeType" />
<xs:element xmlns:q10="http://SqlReceiveProject" name="Country"
type="q10:CountryType" />
<xs:element xmlns:q11="http://SqlReceiveProject" name="Phone"
type="q11:PhoneType" />
<xs:element xmlns:q12="http://SqlReceiveProject" name="Fax"
type="q12:FaxType" />
<xs:element xmlns:q13="http://SqlReceiveProject" name="ispolled"
type="q13:ispolledType" />
<xs:element xmlns:q14="http://SqlReceiveProject" name="age"
type="q14:ageType" />
</xs:choice>
</xs:complexType>
- <xs:complexType name="CustomerIDType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="CompanyNameType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="ContactNameType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="ContactTitleType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="AddressType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="CityType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="RegionType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="PostalCodeType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="CountryType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="PhoneType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="FaxType">
- <xs:simpleContent>
<xs:extension base="xs:string" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="ispolledType">
- <xs:simpleContent>
<xs:extension base="xs:boolean" />
</xs:simpleContent>
</xs:complexType>
- <xs:complexType name="ageType">
- <xs:simpleContent>
<xs:extension base="xs:int" />
</xs:simpleContent>
</xs:complexType>
</xs:schema>
This is the schema I created
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns="http://Demo. LocalInstanceAfterRetrievedFromCustomers
"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://Demo. LocalInstanceAfterRetrievedFromCustomers
"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:element name="Customer">
- <xs:annotation>
- <xs:appinfo>
- <b:properties xmlns:b="http://schemas.microsoft.com/BizTalk/2003">
<b:property distinguished="true" xpath="/*[local-name()='Customer' and
namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
cal-name()='Age' and namespace-uri()='']" />
<b:property distinguished="true" xpath="/*[local-name()='Customer' and
namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
cal-name()='CompanyName' and namespace-uri()='']" />
<b:property distinguished="true" xpath="/*[local-name()='Customer' and
namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
cal-name()='City' and namespace-uri()='']" />
<b:property distinguished="true" xpath="/*[local-name()='Customer' and
namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
cal-name()='Region' and namespace-uri()='']" />
<b:property distinguished="true" xpath="/*[local-name()='Customer' and
namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
cal-name()='PostalCode' and namespace-uri()='']" />
</b:properties>
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
<xs:element name="CustomerId" type="xs:string" />
<xs:element name="Age" type="xs:nonNegativeInteger" />
<xs:element name="FirstName" type="xs:string" />
<xs:element name="LastName" type="xs:string" />
<xs:element name="CompanyName" type="xs:string" />
<xs:element name="City" type="xs:string" />
<xs:element name="Region" type="xs:string" />
<xs:element name="PostalCode" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
| |
| Yossi Dahan 2005-07-23, 5:49 pm |
| Luis,
You did not fully describe you scenario - I assume you have a decision in
your orchestration to route the message to the correct send port.
what is the decision expression?
Try and trace the values the decision is using in an expression shapre
before the decision (or use HAT debugging if you like) and see that the
values are correct.
BTW - if this is the only reason you use an orchestration you could achieve
the same result using messaging only and contant-based routing.
Yossi Dahan
"Luis Esteban Valencia" <levalencia@avansoft.com> wrote in message
news:uoQudvrjFHA.3316@TK2MSFTNGP14.phx.gbl...
> Hello. I did an orchestration its supposed to route all London Customers
> to
> one folder and non Londo Customers should bot be dropped on that folder.
> Anyway all the customers are being dropped in London Folder.
>
> This is what I did.
> 1. Generated a schema from select * from customers in sql server.
> 2. Dragged a receive shape and port.
> 3. I created another schema with less fields than the original one. and
> transformed the original message to this new one. Its supposed that the
> files dropped on thefolder must be of this structure and they are not,
> they
> are the same as before.
>
> This is the generated schema.
>
> <?xml version="1.0" encoding="utf-16" ?>
> - <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> attributeFormDefault="unqualified" elementFormDefault="qualified"
> targetNamespace="http://SqlReceiveProject" version="1.0"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> - <xs:annotation>
> - <xs:appinfo>
> <msbtssql:sqlScript value="select * from customers for xml auto,
> elements"
> xmlns:msbtssql="http://schemas.microsoft.com/BizTalk/2003" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="Customer">
> - <xs:complexType>
> - <xs:sequence>
> <xs:element xmlns:q1="http://SqlReceiveProject" minOccurs="0"
> maxOccurs="unbounded" name="customers" type="q1:customersType" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> - <xs:complexType name="customersType">
> - <xs:choice minOccurs="0" maxOccurs="unbounded">
> <xs:element xmlns:q2="http://SqlReceiveProject" name="CustomerID"
> type="q2:CustomerIDType" />
> <xs:element xmlns:q3="http://SqlReceiveProject" name="CompanyName"
> type="q3:CompanyNameType" />
> <xs:element xmlns:q4="http://SqlReceiveProject" name="ContactName"
> type="q4:ContactNameType" />
> <xs:element xmlns:q5="http://SqlReceiveProject" name="ContactTitle"
> type="q5:ContactTitleType" />
> <xs:element xmlns:q6="http://SqlReceiveProject" name="Address"
> type="q6:AddressType" />
> <xs:element xmlns:q7="http://SqlReceiveProject" name="City"
> type="q7:CityType" />
> <xs:element xmlns:q8="http://SqlReceiveProject" name="Region"
> type="q8:RegionType" />
> <xs:element xmlns:q9="http://SqlReceiveProject" name="PostalCode"
> type="q9:PostalCodeType" />
> <xs:element xmlns:q10="http://SqlReceiveProject" name="Country"
> type="q10:CountryType" />
> <xs:element xmlns:q11="http://SqlReceiveProject" name="Phone"
> type="q11:PhoneType" />
> <xs:element xmlns:q12="http://SqlReceiveProject" name="Fax"
> type="q12:FaxType" />
> <xs:element xmlns:q13="http://SqlReceiveProject" name="ispolled"
> type="q13:ispolledType" />
> <xs:element xmlns:q14="http://SqlReceiveProject" name="age"
> type="q14:ageType" />
> </xs:choice>
> </xs:complexType>
> - <xs:complexType name="CustomerIDType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="CompanyNameType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="ContactNameType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="ContactTitleType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="AddressType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="CityType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="RegionType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="PostalCodeType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="CountryType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="PhoneType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="FaxType">
> - <xs:simpleContent>
> <xs:extension base="xs:string" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="ispolledType">
> - <xs:simpleContent>
> <xs:extension base="xs:boolean" />
> </xs:simpleContent>
> </xs:complexType>
> - <xs:complexType name="ageType">
> - <xs:simpleContent>
> <xs:extension base="xs:int" />
> </xs:simpleContent>
> </xs:complexType>
> </xs:schema>
>
>
> This is the schema I created
>
> <?xml version="1.0" encoding="utf-16" ?>
> - <xs:schema xmlns="http://Demo. LocalInstanceAfterRetrievedFromCustomers
"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://Demo. LocalInstanceAfterRetrievedFromCustomers
"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> - <xs:element name="Customer">
> - <xs:annotation>
> - <xs:appinfo>
> - <b:properties xmlns:b="http://schemas.microsoft.com/BizTalk/2003">
> <b:property distinguished="true" xpath="/*[local-name()='Customer' and
> namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
> cal-name()='Age' and namespace-uri()='']" />
> <b:property distinguished="true" xpath="/*[local-name()='Customer' and
> namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
> cal-name()='CompanyName' and namespace-uri()='']" />
> <b:property distinguished="true" xpath="/*[local-name()='Customer' and
> namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
> cal-name()='City' and namespace-uri()='']" />
> <b:property distinguished="true" xpath="/*[local-name()='Customer' and
> namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
> cal-name()='Region' and namespace-uri()='']" />
> <b:property distinguished="true" xpath="/*[local-name()='Customer' and
> namespace-uri()='http://Demo. LocalInstanceAfterRetrievedFromCustomers
']/*[lo
> cal-name()='PostalCode' and namespace-uri()='']" />
> </b:properties>
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> <xs:element name="CustomerId" type="xs:string" />
> <xs:element name="Age" type="xs:nonNegativeInteger" />
> <xs:element name="FirstName" type="xs:string" />
> <xs:element name="LastName" type="xs:string" />
> <xs:element name="CompanyName" type="xs:string" />
> <xs:element name="City" type="xs:string" />
> <xs:element name="Region" type="xs:string" />
> <xs:element name="PostalCode" type="xs:string" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
|
|
|
|
|