|
Home > Archive > BizTalk Server General > March 2006 > error email address
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 |
error email address
|
|
|
| Hi everyone...
I have this problem....
With a stored procedure I capture an address email (I create a file xml that
contain this information). So I want to send to this email a text.
This is the file xml that I use:
<?xml version="1.0" encoding="utf-16" ?>
<xs:schema xmlns="http://createmail2"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
attributeFormDefault="unqualified" elementFormDefault="qualified"
targetNamespace="http://createmail2" version="1.0"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<msbtssql:sqlScript value="exec [_select_mail] @istat=" ""
xmlns:msbtssql="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
<xs:element name="requestistat">
<xs:complexType>
<xs:sequence>
<xs:element name="_select_mail">
<xs:complexType>
<xs:attribute name="istat" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="responseemail">
<xs:annotation>
<xs:appinfo>
<properties xmlns="http://schemas.microsoft.com/BizTalk/2003">
<property distinguished="true" xpath="/*[local-name()='responseemail'
and namespace-uri()='http://createmail2']/*[local-name()='_fatturatore' and
namespace-uri()='http://createmail2']/@*[local-name()='email' and
namespace-uri()='']" />
</properties>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element xmlns:q1="http://createmail2" minOccurs="0" maxOccurs="1"
name="_fatturatore" type="q1:_fatturatoreType" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:complexType name="_fatturatoreType">
<xs:attribute name="email" type="xs:string" />
</xs:complexType>
</xs:schema>
Well with an expression shape I do this thing:
Port_DP(Microsoft.XLANGs.BaseTypes.Address)="mailto:"+msgresponse._fatturatore.email;
I know that the file xml is correct, the error there is when I send the
email:
"The adapter failed on an attempt to transmit a message going to send port
with the address "mailto:". Details: "At least one recipient is required, but
none were found."
Thanks
Anja
| |
| Greg Forsythe 2006-03-17, 5:52 pm |
| Is it possible the stored procedure is not returning an email address.
Is the email address null in the database for some records.
You could try SELECT ISNULL(email, 'youremail@address') FROM ... in your
stored procedure.
Or check the returned email address inside the orchestration.
Greg
"Anja" <anjagrillo@infinito.it> wrote in message
news:27EABD96-3B08-4C66-B61C-5E065641942A@microsoft.com...
> Hi everyone...
> I have this problem....
> With a stored procedure I capture an address email (I create a file xml
> that
> contain this information). So I want to send to this email a text.
>
> This is the file xml that I use:
>
> <?xml version="1.0" encoding="utf-16" ?>
> <xs:schema xmlns="http://createmail2"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> attributeFormDefault="unqualified" elementFormDefault="qualified"
> targetNamespace="http://createmail2" version="1.0"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:annotation>
> <xs:appinfo>
> <msbtssql:sqlScript value="exec [_select_mail] @istat=" ""
> xmlns:msbtssql="http://schemas.microsoft.com/BizTalk/2003" />
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="requestistat">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="_select_mail">
> <xs:complexType>
> <xs:attribute name="istat" type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="responseemail">
> <xs:annotation>
> <xs:appinfo>
> <properties xmlns="http://schemas.microsoft.com/BizTalk/2003">
> <property distinguished="true" xpath="/*[local-name()='responseemail'
> and namespace-uri()='http://createmail2']/*[local-name()='_fatturatore'
> and
> namespace-uri()='http://createmail2']/@*[local-name()='email' and
> namespace-uri()='']" />
> </properties>
> </xs:appinfo>
> </xs:annotation>
> <xs:complexType>
> <xs:sequence>
> <xs:element xmlns:q1="http://createmail2" minOccurs="0" maxOccurs="1"
> name="_fatturatore" type="q1:_fatturatoreType" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:complexType name="_fatturatoreType">
> <xs:attribute name="email" type="xs:string" />
> </xs:complexType>
> </xs:schema>
>
> Well with an expression shape I do this thing:
>
> Port_DP(Microsoft.XLANGs.BaseTypes.Address)="mailto:"+msgresponse._fatturatore.email;
>
> I know that the file xml is correct, the error there is when I send the
> email:
> "The adapter failed on an attempt to transmit a message going to send port
> with the address "mailto:". Details: "At least one recipient is required,
> but
> none were found."
>
> Thanks
> Anja
| |
|
| No, it isn't this kind of problem... I verify that the stored procedure
return the correct email address.
Do you have any other idea???
Thanks
Anja
"Greg Forsythe" wrote:
> Is it possible the stored procedure is not returning an email address.
> Is the email address null in the database for some records.
>
> You could try SELECT ISNULL(email, 'youremail@address') FROM ... in your
> stored procedure.
> Or check the returned email address inside the orchestration.
>
> Greg
>
> "Anja" <anjagrillo@infinito.it> wrote in message
> news:27EABD96-3B08-4C66-B61C-5E065641942A@microsoft.com...
>
>
>
| |
| Greg Forsythe 2006-03-25, 11:37 am |
| Can you try this code:
Add a string variable to the orchestration
strVar = xpath(msgresponse,"/*[local-name()='responseemail' and
namespace-uri()='http://createmail2']/*[local-name()='_fatturatore' and
namespace-uri()='http://createmail2']/@*[local-name()='email' and
namespace-uri()='']" />");
Port_DP(Microsoft.XLANGs.BaseTypes.Address)="mailto:"+ strVar;
Greg
"Anja" <anjagrillo@infinito.it> wrote in message
news:4A489E12-7DE4-4BC4-A818-38DAA59F46B4@microsoft.com...[vbcol=seagreen]
> No, it isn't this kind of problem... I verify that the stored procedure
> return the correct email address.
>
> Do you have any other idea???
>
> Thanks
> Anja
>
> "Greg Forsythe" wrote:
>
|
|
|
|
|