- This topic has 6 replies, 1 voice, and was last updated 9 years, 5 months ago by
.
-
Posts
-
-
Hello
I have a process that receives XML files from a directory c:\\test
It then passes the values into an SQL database.I accsess the SQL Server by and added SQL Adapter where I choose table – insert – and select all the columns (except the ID).
The first element of the XML document is <Header> and when I run the process I get this error message ……
\”
The adapter failed to transmit message going to send port \”SQL://myserver\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”Could not find stored procedure ‘Header’.\”
\”But I never selected ‘Stored Procedure’ when creating the SQL Adapter – I don’t understand it.
Any help greatly appreciated.
Regards
JMan -
Hello
Just to clarify – I am not calling a stored procedure – I am inserting into a table using an updategram. And – Yes I used the ‘add generated item’ wizard to create the updategram code. Howver it still says cannot find stored procedure … and the name of the sp being called is the name of the root element from the .xsd file … wierd.
Thnaks
JMan-
Hey that actually makes sense.
OK I have gone back into my project and added a new map. The source schema is my self created one and the destination schema is the auto generated one. I have mapped the values from the one to the other. Now how do I tell Biztalk to use that map?
Regards
JMan-
-
Did you use the Add Generated Items to add the schema to call the stored procedure?
You might want to check the SQL white paper is you have questions: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/90a5261b-a220-41bf-bf7f-fd759239242c.asp
-
Sounds like you are sending the wrong message to the SQL Adapter.
When you ‘Add Generated Item’ the SQL Adapter creates an updategram schema. You need to map your incoming message into this schema and send the new updategram message to the SQL Adapter.
There is no updategram code, just the schema. The SQLXML software is able to determine the action required from the updategram message structure and content.
-
There are a number of ways.
[list:c86f173b74]1. Add the map to the Receive Port as an inbound map. The receive port will publish an updategram message to the messagebox. You can use SQL send port with a filter to subscribe to this message.2. Add the map to the Send Port. The receive port will publish a source message to the messagebox. You can use SQL send port with a filter to subscribe to this message where it will be mapped.
3. Use an orchestration with a construct message shape and a transform message shape. The orchestration will receive a source message and send an updategram[/list:u:c86f173b74]
The best bet with a SQL send port is to use an orchestration.
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.