[community-content]

Ok.. I created a promoted field. I have code to update it as follows…

[code:1:facfe57dbe]strFileName = WorkInProgressFlatFile(FILE.ReceivedFileName);
WorkInProgressFileImportSqlRequest.FileImport.File = strFileName;[/code:1:facfe57dbe]

If the file contains only one record all works fine. When there is more than one record in the file (ie message) I get the following error.

[code:1:facfe57dbe]The result set for the XPath expression ‘/*[local-name()=’RecordInsertRequest’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/*[local-name()=’FileImport’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/@*[local-name()=’File’ and namespace-uri()=”]’ contains more than a single node. [/code:1:facfe57dbe]

How do I get it to update all promoted fields? Or just the one its on? I want to set the promoted field to the file name it came in on so I can store it in the database.

Thanks.

[community-content]

Guys,

I am going insane!

Here is the problem:

1 – I read a binary file from an FTP directory using the FTP adapter, then
2 – I use a custom pipeline with a custom IDisassembler component (Disassemble, GetNext methods overriden)
to convert the binary message (batch of binary msgs) into several Xml BizTalk messages (IBaseMessage), during this stage
I promote the properties required by the messeging engine to recognize the messages
NOTE: I am able to see the messages are being passed successfully to the orchestration
3 – I use a map to convert the passed message from the pipeline into the orchestration
to the schema of an SP request (Generated by BizTalk to use the SQL Adapter)
4 – I send the result of the map, that is SQLMsg.procedureRequest to the send adapter (SQL) in order
to invoke an SP on the local SQL server 2005 instance
5 – I get the following error:

There was a failure executing the send pipeline:
\”Microsoft.BizTalk.DefaultPipelines.XMLTransmit, Microsoft.BizTalk.DefaultPipelines,
Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\” Source:
\”XML assembler\” Send Port: \”SendPort2\” URI: \”SQL://ES-SYS371/BatelcoPOC/\” Reason:
Root element is missing.

NO WAY, the map is supposed to construct the message, right?
This is really weird

ANy Help plz

[community-content]

Well tried a number of thing s and it still has the smae subscriber error.

How would I go about checking the subscription for the BTS values? It seems pretty straighforward. A receive port, a transformation, and a send port in the orchestration. THe Pipeline has a flat file assembly. Recieve port is XMLREceive and the SendPort uses the Pipeline.

Rookie here!

Thanks

[community-content]

I ran into this as well. There is a hotfix for the SQL adapter (KB 918316)that corrects this problem.

Regards

Tom

[community-content]

Hi

A simple question for you gurus out there.

I have run two simple messaging examples:
The first one was just a flat file coming into the recieve port, was disassembled in a custom pipeline then output to the send port as xml file. This output just the one file as it should.

I then built a simple orchestration that does exactly the same thing with just receive and send shape with appropriate configured ports. I then bound my configured ports to the physical ports I created for the first example. On adding my file to the recieve location the message is duplicated in the send location rather than just the once.

I remember seeing this on some tutorial, but I can’t remember what causes the duplication of the message.

In HAT I have 4 \”Completed\” processes in the following time order:

CustomRecievePipeline > XMLTransmit Send Pipeline > Orchestration > XMLTransmit Send Pipeline.

Any ideas?
Cheers

[community-content]

I gfixed this,

i downloaded SP3 from othe site
http://www.downloaddatabase.com/databasesoftware/microsoft-sql-server-2000-service-pack-3a.htm

Thanks
Rai

[community-content]

greg,

Thanks for yor response.

i downloaded SP3a from microsoft downloads, ya i tried SP4 also.

i am thingi will instal from CD, not tried yet.

Rai-

[community-content]

Here’s a good link about how to create a message and initialaze it. It help me allot.

[url]http://www.objectsharp.com/Blogs/matt/archive/2004/11/09/1009.aspx[/url]

On my side I have created a helper class to construct new empty and initialized message. By the way if you use SQL Server 2005, I suggest you use the \”xml\” new field type to store xml document.

[community-content]

hi,

thanks a lot for help

earlier i had a issue of storing a xml directly into a field in database.i am able to do it.

thanks for the help.

now later i want to use this xml message stored in database to insert an order in other system.

how should i query this xml message stored according to orderid using sql adapter of type receive.

i tried by writing a stored procedure and using sql adapter of type recv.the schema generated gives a error that one of types is not defined.as the message contains xml itself.

i was not able to select that data using xml elements,xmldata or xml auto as it contains an entire xml with namespace.

after getting this xml message in db as one field in schema, i want to contruct the message for schema to which xml in database corresponds.

then after constructing that message i will be able to process it further.

please help it is urgent.

[community-content]

Check your project properties and in the Deployment section make sure that the SQL Server computer name used to deploy is the one you expect (usually your local machine if you’re running BTS locally on a developer workstation).

[community-content]

Can’t deploy my BizTalk application to BizTalk DB directly from Visual Studio, I get the error

Error 1 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

Any help please,

[community-content]

Yes.
Create new app pool which runs under an account that has permissions on the \”BizTalkMgmtDb\”?

[community-content]

Hi,

I am trying to call a simple web service throuhg BizTalk but I am getting the following error:
\”Finding the document specification by message type \”http://TestWebService#HelloWorld\” failed. Verify the schema deployed properly.\”

Can anybody help. Is there a simple tutorial describing how to call a web service in Biztalk around? I googled it for hours but could not find anything usefull. I also did the tutorial that came with the biztalk 2006 but still did not help.

Thanks in advance.

[community-content]

I think SQL 2000 had SP3 and SP3a – not sure of the difference, but Biztalk requires SP3a.

Have you tried SP4

[community-content]

That solved a lot… thanks!

[Author]

Posts