Forum Replies Created
-
Posts
-
Scenario 2 mentioned here will help you.
SendPort: Delivery Notification=Transmitted.
Delivery Notification – If a message fails to be delivered on a Port, the “
DeliveryFailureException” is generated. Note that “Delivery Notification” is NOT available for Binding property “Specify Now”.
There are two kinds of Exceptions handled in this orchestration.DeliveryFailureException- General Exception
A
DeliveryFailureException is raised by the Port, since the file path specified in the Dummy Port does not exist. The exception handler handles the exception by sending the message into theOfflineFolder. Notice that in this case, theDeliveryFailureException has been correctly raised.http://www.codeproject.com/…/A-developers-guide-to-handling-exceptions-in-BizTa
Thanks for your response !!! but i am still not sure what all the parameters need to be passed for this WS. whenever i am sending the request i am getting Faut responses only. i am not getting the proper responses from teh WS . i am passing all the required paramters required for the request but still fault response. Do we need to alter the schema for the request WS.
The conversion of Flat File to Xml is called disassembly. Mapping is the conversion of one Xml message to another
In order to produce your desired Xml output you will need to group records based key. I know of no way to do this using functoids.
It can be done simply with a custom Xslt using Muenchian grouping
TransId is varaible and I am doing the same right now i.e., I have a flat xml schema and I am mapping the flat file to this flat xml. . But I am stuck up in mapping this flat xml to real request and what functiods to use in order to map only certain elements needs to be repeatable…
This depends on whether the transid is fixed i.e. only ever 1 or 2.
If this number is variable then the FlatFile disassembler cannot group the records.And you will need disasemble to a flat Xml and then use a map to group transactions.
I strongly believe that the Stored Procedure is failing because of the datetime format issue for the RunToDate field.
Just check the format of the Datetime column.
Try to call the Stored procedure with the same parameters from SQL mgmt Studio. Once you get the right format….use a script functoid to convert your datetime to correct format and map it to the RunToDate element.
The map seems to be working fine…as you do get the XML for the mapped Stored Procedure.
Thank you. The type of the schema is and was xs:boolean. The diff between your code and mine is that I was returning Boolean and you're returning bool. I changed the script to yours and the error message is different but still not working. Error: 'Inner exception: Input string was not in a correct format.' In the stack trace it is trying to do a StringToNumber and I don't understand why. My message is this:
<ns0:uspUpdateBizTalkrunDates xmlns:ns0="schemas.microsoft.com/…/dbo">
<ns0:ProcessName>orchPractitionerSpecialties</ns0:ProcessName>
<ns0:RunToDate>2014-07-10T08:34:20</ns0:RunToDate>
<ns0:Successful>true</ns0:Successful>
</ns0:uspUpdateBizTalkrunDates>
types in the stored proc and schema respectively are:
ProcessName – VarChar(100) – xs:string
RunToDate – datetime – xs:dateTime
Successful – bit – xs:boolean
It is the send Shape that is throwing the error. any other suggestions? Thank you for your help!
Check this link…it might help you.
biztalkconnect.blogspot.no/…/biztalk-2013-installation-bug.html
Its a link to my blog ;)….. when I had same problem in January.
You can check the following:
1. How are you sending and receiving response?
2. Is the SendPort delivering the XML successfully to the Client?
3. Any Errors in Eventlog while delivery?
4. Since you will receive the response after 1 hour…..are you using correlations?
There could be many reasons for not receiving the response…..co-ordinating with the Client’s technical team is important.
There is no such looping limit.
I think its better to use the SendPort Retry interval/Retry count properties if you want to try and re-send it again.
You can set the datatype to xs:boolean for the element in the Schema.
And code as below:
public bool convertToBool(string param1)
{
if (param1.Equals("true")) return true;
return false;
}
