Forum Replies Created
-
Posts
-
The last probelm is caused by the Root element in your Receive_FlatFile_Body schema having a Child Order of Infix
You need to change this to Postfix.The previous error can be caused if the last record has no terminating \\r\\n (CRLF)
i’ve received this messages when correlation my Response Webport and my Receive port.
I have no idea what the messages means
greetings
Do you have a stored procedure that is passed some parameter, which is used to select the orders.
It may be you are passing the wrong parameter.
An easy way to find out is to modify your stored procedure and hard code a known good value:
[code:1:ee64251efc]CREATE PROCEDURE proc_GetCustomer
(@CustomerId char(5))
ASSELECT * FROM Customers
WHERE CustomerId= 27 FOR XML AUTO, XMLDATA
GO[/code:1:ee64251efc]Alternative you can Stop the Send port and use the the HAT to view the content of the SQL adapter request message
Interesting problem.
The map works in Biztalk Mapper test mode – apart from the minor security issue in the output validation step. Biztalk does not perform a validate after a transform at runtime
I also tested it using XslCompiledTransform in a C# program and it works.
I would report this as a bug.
One potential work around would be to implement the XslTransform pipeline component from the SDK and perform the transform in the send pipeline
I managed to solve it. If you are running under win2003 server BizTalk
uses the account – networkservice which needs to be added to the biz talk
isolated users group. I rebooted machine then it worked. There were errors in the event log to do with permissions for the db.Thanks
But no luck. Still getting single order.
Even the stored procedure returns 10 orders.
I have developed the application using following reference.http://www.codeproject.com/dotnet/usingsqladapter.asp
Regards
Jignesh DarjiHere is the XSLT Output:
<?xml version=\”1.0\” encoding=\”UTF-16\”?>
<xsl:stylesheet xmlns:xsl=\”http://www.w3.org/1999/XSL/Transform\” xmlns:msxsl=\”urn:schemas-microsoft-com:xslt\” xmlns:var=\”http://schemas.microsoft.com/BizTalk/2003/var\” exclude-result-prefixes=\”msxsl var s0\” version=\”1.0\” xmlns:ns0=\”http://MappingProblem.Schema2\” xmlns:s0=\”http://MappingProblem.Schema1\”>
<xsl:output omit-xml-declaration=\”no\” method=\”xml\” version=\”1.0\” doctype-public=\”-//Bibit//DTD Bibit PaymentService v1//EN\” doctype-system=\”http://dtd.bibit.com/paymentService_v1.dtd\” />
<xsl:template match=\”/\”>
<xsl:apply-templates select=\”/s0:Schema1\” />
</xsl:template>
<xsl:template match=\”/s0:Schema1\”>
<ns0:Schema2>
<FullName>
<xsl:value-of select=\”FirstName/text()\” />
</FullName>
</ns0:Schema2>
</xsl:template>
</xsl:stylesheet>Here is the output from Test Map:
<?xml version=\”1.0\” encoding=\”utf-8\”?>
<!DOCTYPE ns0:Schema2 PUBLIC \”-//Bibit//DTD Bibit PaymentService v1//EN\” \”http://dtd.bibit.com/paymentService_v1.dtd\”>
<ns0:Schema2 xmlns:ns0=\”http://MappingProblem.Schema2\”>
<FullName>FirstName_0</FullName>
</ns0:Schema2>The error I get is as follows:
Map2_output.xml: error btm1046: Output validation error: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.
The output from Test Map looks correct. The output I get when I run it in an Orchestration is as follows (note there is no Schema2 element):
<?xml version=\”1.0\” encoding=\”UTF-8\” standalone=\”no\”?>
<!DOCTYPE ns0:Schema2 PUBLIC \”-//Bibit//DTD Bibit PaymentService v1//EN\” \”http://dtd.bibit.com/paymentService_v1.dtd\”[]>
<FullName>FirstName_0</FullName>Thanks,
BrettYou should be able to get all the information you are looking for in my Convoy White Paper: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts_2004wp/html/956fd4cb-aacc-43ee-99b6-f6137a5a2914.asp
I also have several Convoy samples on this site.
Best of luck.
Honestly, I don’t use anything other then the tools provided by BizTalk.
For schema, the BizTalk Editor is really good for building them.
For maps, again the BizTalk Editor is great for most scenarios unless you have a lot of custom xslt stuff you want to do.
For the rest, your only option is really to use the editor.Microsoft has some good virtual labs on MSDN to help you learn the tools.
Best of luck.
Do you get any errors in the event log?
Do you happen to have tracking turned off or the tracking host not running?
I think you might have one of your outer scopes or Orchestration set to Atomic when it shouldn’t be. Did you look at the Solution inside the solution folder?
I’m not 100% if the sample will work in BizTalk 2006. It was built using 2004 and that Sharepoint adapter has changed a bit since then.
