Forum Replies Created
-
AuthorPosts
-
Yes, we did restart the app and host instance. %u8c22%u8c22[:)]
We deleted the app, removed it from windows via add/remove programs, imported MSI and it Still did not work.
I should have said that I tried to move my schemas to my website and refer to them from the website. That did not work for me so I copied the schemas back to my project. I wonder if BT is trying to point to an old schema? Should i replace the schema again to make sure I am pointing to the correct one?
June 5, 2009 at 9:25 AM in reply to: SQL Adapter – returning only the first response….not returning all responses #22592Hi Dino,
Thanks for your response. Thats what I was seeing in the message when I debugged my orchestration and looked at the response message. I’m glad you confirmed that SQL adapter returns 3 XML docs so your suggestion of combining them in a pipeline makes sense.
This is only my second Biztalk Project so just would like to confirm couple of things regarding assembling the message in a custom pipeline:
Im using Solicit request-response SQL Adapter. Sould I replace Default XMLReceive pipeline with a Custom pipeline. Can you assemble the message parts in a single message in a receive pipeline? I thought that you can only disassemble files in a receive pipeline.
It will be very helpful to me to see an example.
Thanks Again!
Adnan
I exported a new one and it looks okay … but it still knocks my receive port pipeline out of commission. This wreaks havoc with the my other orchestrations using this receive location. Here is the file: And thank you for your help …
<?xml version=”1.0″ encoding=”utf-8″?>
<BindingInfo xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” Assembly=”Microsoft.BizTalk.Deployment, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″ Version=”3.5.1.0″ BindingStatus=”FullyBound” BoundEndpoints=”1″ TotalEndpoints=”1″>
<Timestamp>2009-06-05T08:57:05.5225895-05:00</Timestamp>
<ModuleRefCollection>
<ModuleRef Name=”My.Interface.Epak” Version=”2.0.0.0″ Culture=”neutral” PublicKeyToken=”c91624e33c501d09″ FullName=”My.Interface.Epak, Version=2.0.0.0, Culture=neutral, PublicKeyToken=c91625e68c501d09″>
<Services>
<Service Name=”My.Interface.Epak.EpakOrch” State=”Started” TrackingOption=”ServiceStartEnd MessageSendReceive OrchestrationEvents” Description=””>
<Ports>
<Port Name=”EpakReceivePort” Modifier=”2″ BindingOption=”1″>
<SendPortRef xsi:nil=”true” />
<DistributionListRef xsi:nil=”true” />
<ReceivePortRef Name=”HttpReceivePort” />
</Port>
</Ports>
<Roles />
<Host Name=”BizTalkServerApplication” NTGroupName=”MYDOMAIN\BizTalk Application Users” Type=”1″ Trusted=”false” />
</Service>
</Services>
<TrackedSchemas />
</ModuleRef>
</ModuleRefCollection>
<SendPortCollection />
<DistributionListCollection />
<ReceivePortCollection>
<ReceivePort Name=”HttpReceivePort” IsTwoWay=”false” BindingOption=”1″>
<Description xsi:nil=”true” />
<ReceiveLocations>
<ReceiveLocation Name=”HttpReceiveLocation”>
<Description xsi:nil=”true” />
<Address>/HttpReceive/BTSHTTPReceive.dll</Address>
<PublicAddress>http://localhost/HttpReceive</PublicAddress>
<Primary>true</Primary>
<ReceiveLocationServiceWindowEnabled>false</ReceiveLocationServiceWindowEnabled>
<ReceiveLocationFromTime>2000-01-01T05:00:00</ReceiveLocationFromTime>
<ReceiveLocationToTime>2000-01-01T04:59:59</ReceiveLocationToTime>
<ReceiveLocationStartDateEnabled>false</ReceiveLocationStartDateEnabled>
<ReceiveLocationStartDate>2007-05-17T00:00:00</ReceiveLocationStartDate>
<ReceiveLocationEndDateEnabled>false</ReceiveLocationEndDateEnabled>
<ReceiveLocationEndDate>2007-05-18T23:59:59</ReceiveLocationEndDate>
<ReceiveLocationTransportType Name=”HTTP” Capabilities=”387″ ConfigurationClsid=”1c56d157-0553-4345-8a1f-55d2d1a3ffb6″ />
<ReceiveLocationTransportTypeData><CustomProps><ReturnCorrelationHandle vt=”11″>-1</ReturnCorrelationHandle><ResponseContentType vt=”8″>text/xml</ResponseContentType><SuspendFailedRequests vt=”11″>0</SuspendFailedRequests><UseSSO vt=”11″>0</UseSSO><LoopBack vt=”11″>0</LoopBack></CustomProps></ReceiveLocationTransportTypeData>
<ReceivePipeline Name=”My.Interface.Common.Pipeline.MYApplicationPolicyPipeline” FullyQualifiedName=”My.Interface.Common.Pipeline.MyApplicationPolicyPipeline, My.Interface.Common.Pipeline, Version=2.0.0.0, Culture=neutral, PublicKeyToken=4a048e49556e5c16″ Type=”1″ TrackingOption=”ServiceStartEnd MessageSendReceive PipelineEvents” Description=”” />
<ReceivePipelineData xsi:nil=”true” />
<SendPipeline xsi:nil=”true” />
<SendPipelineData xsi:nil=”true” />
<Enable>true</Enable>
<ReceiveHandler Name=”BizTalkServerIsolatedHost” HostTrusted=”false”>
<TransportType Name=”HTTP” Capabilities=”387″ ConfigurationClsid=”1c56d157-0553-4345-8a1f-55d2d1a3ffb6″ />
</ReceiveHandler>
</ReceiveLocation>
</ReceiveLocations>
<SendPipelineData xsi:nil=”true” />
<Authentication>0</Authentication>
<Tracking>0</Tracking>
<Transforms />
<RouteFailedMessage>false</RouteFailedMessage>
<ApplicationName>MyWinsApplication</ApplicationName>
</ReceivePort>
</ReceivePortCollection>
<PartyCollection />
</BindingInfo>Any Thoughts?
If restarting wont help.
Do the following.
Remove the assembly from GAC.
Remove the assembly from Resources in your application inside Biztalk Admin Console.
The reason is Biztalk cant load your latest assebly and it still keeps reffering the old one.
Did you ever get this problem solved ?
We are experiencing the same issue.
Please let me know if you have a solution for this.
EDIT: Solved by adjusting TCP timeout settings
June 5, 2009 at 3:29 AM in reply to: SQL Adapter – returning only the first response….not returning all responses #22586If you want to do this without using loops in the orchestration, maybe because you want straight through messaging, you will need to process the message parts into a single message in a pipeline. You will need a 3 level xml structure rather than the default sql adapter 2 level structure, something like the xml below
<QuerySet><Query><QueryResult/></Query></QuerySet>
While the message parts are parts of a message, they are in fact seperate xml documents, and as such can not be accessed using standard message processing (maps, dot notation and the like).
I have done this with loops, and also found a useful blog, but I have lost the link that gave the example. I can try and post the example if it will be of use
Hi Thr
I am not much xpert to all this but one thing i know for sure that the map can be called using the XSLT code.
and that can be done by calling the dll of the map as one of the client was having that arch.
Unfortunately i dont know how to do that but 200% sure that is a way that exist.
Hi!
I might be missing an important point here or something but then I will stand corrected. As far as I can say, from reading your post, below is how you can proceed.
Check your binding-file. The Orchestration-declaration should look something like this (names changed and “…” replaced with important stuff ) with the receive port set.
<ModuleRef Name=”MyAssembly” Version=”…” Culture=”…” PublicKeyToken=”…” FullName=”…”>
<Services>
<Service Name=”MyOrchestration” State=”Started” TrackingOption=”…” Description=””>
<Ports>
<Port Name=”Rcv_Request” Modifier=”2″ BindingOption=”1″>
<SendPortRef xsi:nil=”true” />
<DistributionListRef xsi:nil=”true” />
<ReceivePortRef Name=”MyReceivePort” />
</Port>
</Ports>
<Roles />
<Host Name=”MyHost” NTGroupName=”MyADGroup” Type=”1″ Trusted=”true” />
</Service>
</Services>
<TrackedSchemas />
</ModuleRef>Your Receive port should also be in the bindings with pipeline set. Something lite this
<ReceivePortCollection>
<ReceivePort Name=”Rcv_Request” IsTwoWay=”…” BindingOption=”1″>
.
.
.
<TransmitPipeline Name=”MyPipeline” FullyQualifiedName=”…” Type=”…” TrackingOption=”…” Description=”” />If your bindings are faulty, just set everything up and export new ones.
Hope I answered your question.
//Niklas
Did you restart your application and application host instance(s) after deployment?
June 4, 2009 at 2:20 PM in reply to: Storing values in a variable for a biztalk transformation. #22581You could call your GetProductType(n) before you begin the transformation and store it in a helper message. Then in your map use a multi-part message as the source – it would consist of your source message and the helper message. Then simply map the helperMessage node containing the product type to your five other scripting functoids.
early termitation only seems to work when the last node of a record is cut off.
It gives a problem when the last node is optional and the node before the last node is cut off.
Then BizTalk does a strange thing and places all the characters of the next line in de last node.
help ! [:D]
June 4, 2009 at 4:36 AM in reply to: "Failed retrieving system" Errro while connecting to Oracle DB using oracle Adapter #22575Hi Tarang Did you get any further with this?
I will try it out!
-
AuthorPosts