Forum Replies Created
-
Posts
-
Hi everyone 🙂
I just want to know if anyone has encounterd a Problem while receiving messages on the HTTP-Adapter in BizTalk 2006 from a sending-System other than a BizTalk 2006.
While sending a message from our Biztalk 2006 System, to itself, no errors are encountered and the message is received properly by the System.
Sending a message from 2004 to 2006 we get and we [i:f900e0cc9a]only[/i:f900e0cc9a] get a \”.Net Runtime error\” displayed in the Application-Log at the BizTalk2006-System.IIS reports a Status code 500 back to the sender.
Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 0
Date: 22.03.2006
Time: 13:45:29
User: N/A
Computer: servername
Description:
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key – v2.0.50727.00000.The problem with the value mapping is the loop, so each field element is processed separately as you surmised in your other post.
The simplest answer using functoids is to use a scripting functoid with Inline XSLT. There is no input parameter, but the output is connected to the <name> element in the destination schema.
Here is an example of what the code will look like, however the <name> element and select xpath strings will be different depending on your input and output schemas.
[code:1:f57078d006]<name>
<xsl:value-of select=\"/Root/field[@name =’name’] \"/>, <xsl:value-of select=\"/Root/field[@name = ‘firstName’]\"/>
</name>[/code:1:f57078d006]The easiest way to do this is to use a map with a Logical Equals and Value Mapping Flattening functoid.
For every column in the output schema you will need a Logical Equals (LE) functoid and a Value Mapping (VM) functoid
Connect the column name attribute to each LE functoid then add a constant Input parameter to this functoid set the value to the column name.
Connect this LE functoid output to the VM functoid input.
Connect the Column element to the VM functoid
Connect the output of the VM functoid to the appropriate element on the output schema.
Repeat this process for each column on the output schema.The order of input parameters on the Value Mapping functoids is important.
The end effect is
If column/@name = \”COLUMN1\” then put column/text() in <column1>Hi Greg
Idea is to receive that XML file as described. When building schema for this xml only attribute for data is \”column name\” which is not usable. After column name comes data which I want to save to SQL server DB
example :
<column name=\”ACCESSORY\”>BR6</column>I am able to extract ACCESSORY but i am not able to extract the value of that column BR6
I have idea to use normal updategram with this file to save it into db. I think I have a mapping problem how to map ACCESSORY column’s data BR6 to certain column in update schema.
Does this help a bit?
\\R
Try thes sites
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_prog_email_ijqb.asp[/url][url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdk/htm/ebiz_sdk_samples_kcnd.asp[/url]
Thanks greg.forsythe. I will try to do what you have suggested. I hope it works.
In case if it didn’t, can you provide with websites that explain such things using diagrams because it is always easier this way.
Many Thanks
I am bit confused about what you are trying to do.
Are you receiving a flat file, xml file.
What type of database are you trying to add the data to – SQL, Oracle?How are you adding the data – updategram, stored procedure?
Can you provide more information about the end to end process.
What is an [Biztalk] Accelerator? I have failed to find the definition anywhere. When initiators (like Microsoft) attach special meaning to a term, they don’t even bother to define it and start using it…soon the \”in the know\” crowd spread the buzzword…and the cycles continues….
The easiest way is to make the CustomerEmail a distinguished field in the schema.
Then in the expression shape you can access this data like this:
strVar = message.CustomerEmail;Otherwise you can use the xpath function:
strVar = xpath(message, \”xpath string\”);To specify a destination email address on a dynamic port you set the port address Url:
portname(Microsoft.XLANGs.BaseTypes.Address) = \”mailto:\” + strVarMake sure you have Biztalk 2004 Sp1 installed.
The work around for this is dont use a scope shape, or atleast dont initialize any message in the scope shape.Also check if your direct binding is working prior to everything else.
Well, it really depends on what type of system you are integrating with and what options you have.
BizTalk offers many different ways to accomplish reliable messaging either through SOAP or Queue adapters or through a correlation response from a vendor.
In vendor solutions I have done in the past, the vendor sent a response message back for every message we sent them. We used an Orchestration with correlation to track the response messages.
Hope this helps.
