CODEWITHSUNDEEP
c#sql-serverbiztalk
james treinen
james treinen

Reputation: 43

Using WCF-Custom to process a tableop select query returns the original message.. not data

I've created a message with this syntax which was created by the schema.

Input Message Select

My orchestration takes the message in and passes it to a Request/Response send shape. The response results are then passed to a Send port. I created my Soap Action header using the configuration created by the generated file. The action header throws a warning, but there are no errors. When I check the response folder it contains the original input message as shown above. It acts like its not even hitting SQL Server. Does anyone have any insight on how to fix this. I've built an insert application also, and it works fine.

Upvotes: 0

Views: 58

Answers (1)

james treinen
james treinen

Reputation: 43

Stupid mistake. I assumed that a send/response was two operations. Select and SelectResponse. Once I changed the SoapActionHeader to: TableOp/Select/dbo/M351SR it worked. thanks for the help

Upvotes: 1

Related Questions