action not understood error with wcf-sql adapter
hi all,
I am trying to insert a flat file to sql server 2008. I used wcf-sql adapter and flat file schema then mapped flat file schema to sql insert shema. Then i send the insert schema to sql port. But i get that error:
Error details: Microsoft.ServiceModel.Channels.Common.UnsupportedOperationException: The action "<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Operation Name="Insert" Action="TableOp/Insert/dbo/info" />
</BtsActionMapping>" was not understood.

I tried to change sql ports operation name to Insert in visual studio. But it didnt work. Please help?
October 2nd, 2009 11:21am

Thanks for your reply but i want to just insert the fields so i didn't write a procedure. I add insert action from sqlBinding window. When i tried to send an xml file, it worked. But, with flat file it didn't work. I add pipeline and flat file shcemas, also. Do I have to write a procedure? I don't know what is going on?
October 2nd, 2009 1:57pm

are you posting flatfile directly to adapter? i dont think adapter will support inserting flatfile , you need to disassemble the flatfile and map to the sql schema.
Free Windows Admin Tool Kit Click here and download it now
October 2nd, 2009 2:06pm

Yes i disassemble the flatfile and map to sql schema. When i view the message part of the error, the sql insert xml file looks ok,also.
October 2nd, 2009 2:15pm

ok are you using wcf-custom binding ? can you check the value of BTS.Operation  in context does it match with your setting?

this post may help you

http://blogs.msdn.com/biztalk_adapter_development/archive/2008/01/08/why-does-the-adapter-say-action-is-not-understood-even-though-i-am-using-the-binding-file-generated-by-the-consume-adapter-service-wizard.aspx
Free Windows Admin Tool Kit Click here and download it now
October 2nd, 2009 2:26pm

yes i read this article and i did it. But it didn't work. Now i fix the problem. I write only "TableOp/Insert/dbo/info" as action and it works. Thanks for your reply.
  • Marked as answer by zelish Friday, October 02, 2009 11:35 AM
October 2nd, 2009 2:35pm

I'm having the same issue, with no solution for the time being
zelish, what is the difference between the two action, the one which makes it work and the other?
because in your two posts you are using the same action
"TableOp/Insert/dbo/info"

Regards,
Stefan
http://www.itsconsulting.fr
Free Windows Admin Tool Kit Click here and download it now
December 21st, 2009 7:10pm

I got the same issue when call stored procedure "GetOrders". so I write "Procedure/dbo/GetOrders" instead

<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Operation Name="GetOrders" Action="Procedure/dbo/GetOrders" />
</BtsActionMapping>

That work fine!

January 10th, 2014 1:07pm

I got the same issue when call stored procedure "GetOrders". so I write "Procedure/dbo/GetOrders" instead

<BtsActionMapping xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Operation Name="GetOrders" Action="Procedure/dbo/GetOrders" />
</BtsActionMapping>

That work fine!

try Action="TypedProcedure/dbo/GetOrders"
Free Windows Admin Tool Kit Click here and download it now
January 12th, 2014 2:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics