Forum Replies Created
-
Posts
-
Thanks Stephen! 💡
You point out about authentication trusted property of the biztalk host, and i really think that causes my problem. I just read the documentation and it seems that the default host that i uses, is an untrusted host by intallation setting default. So i beleive that i need to create a seperate host in this case.The Oracle Adapter uses a System DSN, but there’s only user name but no passwd setting in ODBC, the only place where i can set oracle passwd is at the tranportation properties of the send port. But here you have another choice to use a single sign-on user so theorically i don’t have to set a user name/passwd here.
Will let you know whether it works…
Hi everybody,
I did a mistake!
When I received the new license file, I only put it on the right folder, but I forgot to update it in the database do the utilities 😕
So now it’s ok
Achille C.
I have not worked much with ESS myself.
I think the Oracle DB Adapter using a System DSN with an embedded user name?
In any case, as I understand it BizTalk will never use the account you log in under. It will use the account that the host your use to receive your message. Now, you can have trusted and untrusted host. Trusted hosts will pass forward the SID of the user who submitted it.
Are you using a trusted host?
I have not worked with the SQL Adapter much. I do not know if what you are talking about is possible. The SQL Adapter is really there to return data to you.
The best resource available is the SQL White Paper by Todd Uhl.
You can get it here: http://msdn.microsoft.com/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp?frame=true&_r=1Hope this helps.
Sorry for the delay. I was on vacation.
This sounds like you might be missing a required pre-requisite. Maybe one of the SQL Xml or something related to that.
Is there anyway to keep track of the actually XML docs that flow through Biztalk? When I have a suspended orchestration or an orchestration that errors I would like to be able to view the actual messages that are being sent through Biztalk. When I fire up the HAT i can see the message flow and the error messages but I can’t actually see the messages being passed. I thought I remember reading that you could enable this but I can’t figure out how to actually accomplish this. I’ve enabled message tracking on my send ports but it doesn’t seem to have any effect.
Hi Toni,
thank you for your tips!
So, in my orchestration, I only have one Record possible, so I think that what wrote Stephen works well for my orchestration!
But maybe I would need your solution for another case 😉
Thank you very much for your help!
Regards
Achille C.Hi Achille,
please be aware that Stephen’s xpath will find RECORD’s everywhere in your document. This might be what you need, but that \”Operation1\”-Tag bothers me a bit. What if there is another operation with some other records? You would count them, too.
So it really all depends on the possible structure of the XML-File. An alternative approach, that uses a direct path to your data but avoids the namespace-issue, would be just to use local-name() and ignore the namespaces altogether, like:
/*[local-name()=’patient_omnisResponse’]/*[local-name()=’Operation1′]/*[local-name()=’PATIENT_OMNIS’ ]/*[local-name()=’Select’]/*[local-name()=’Record’]
TToni
Disclaimer: By no means I want to diminish the value of Stephen’s advice (I might need it very soon, too :wink:)
That’s exactly my problem, there’s nothing in the data to relate it, since I need to join the data without a condition. I am not dropping the files on the FTP, the other company is. This process runs every day. Do you think if i put a Fixed value for ID, for example value=1. So both the schemas will have promoted ID field with Value of 1 and correlate on that maybe……is there an OrchestrationInstanceID variable somewhere? Because in my process, I am waiting for a file on ftp, once I got the file, i select data from SQL Server and JOIN it with the data from FTP. It’s kinda like a step by step process, so I have nothing to link it with, although OrchestrationInstanceID would be ideal, if there’s such a thing…..
the format of the files is described here: http://www.biztalkgurus.com/forums/viewtopic.php?t=213
Thanks
Well, Convoys should really be correlated on data inside the message. That’s really what makes a Convoy a Convoy (i.e. multiple messages received that relate to each other). In my case, the ID field was “some id inside the message” that was the same for each message.
Example: convoy for all orders processed today could use Date or all orders from Iowa could use the State field.
Now, there are other ways to do it, but in your case I would try to find something inside the data to use. If you are using a Request – Response (like the 2nd sample in the SQL white paper I think) then you wouldn’t need a Convoy at all.
would it be viable to correlate by ReceivePortID? Since i am using a convoy, i am using same port with multiple receive locs….
You have two problems here.
Firstly Biztalk 2004 is not supported on SQL 2005, only SQL 2000.
Secondly, I don’t believe you can install the BRE in standalone mode with Biztalk 2004. You must install Biztalk as well.You might like to try Biztalk 2006 beta 2, this will use SQL 2005, but you will probably need the Standard Edition as a minimum.
I think with 2006 you can also install the BRE standalone.When using \”Add Generated Item\” wizard in Visual Studio 2003 and then doing \”Add Adapter\” to create messagetype/port for an Sql Server statement, it creates a new orchestaration and places the items there, which is pretty annoying. I had to cut/paste one by one into my main orchestration. Anyone else have had that problem and maybe know a way to fix it?
Thanks
