- This topic has 3 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
Hi All,
I’m facing nonstop warnings in eventviewer for every 30 sec due to WCF-SQL adapter while polling the data from SQL database.
Warning occurs when there’s no record or stored procedure return nothing. Below are the property set to WCF-SQL Adapter:
1) PollDataAvailableStatement returns count = 1
2) pollinginterval=30 sec
3) polling statement=stored procedure returns xml. (if no record found, returns nothing)
4) useambienttransaction=true
Note: PolleDataAvailableStatment will always returns 1.The adapter “WCF-Custom” raised an error message. Details “Microsoft.ServiceModel.Channels.Common.AdapterException: Invalid command sent to ExecuteXmlReader. The command must return an Xml result.. Endpoint Address – mssql://SAIT//SAT_CustomDB_DEV?InboundId=STCorpInv —> System.InvalidOperationException: Invalid command sent to ExecuteXmlReader. The command must return an Xml result.
at System.Data.SqlClient.SqlCommand.CompleteXmlReader(SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteXmlReader()
at Microsoft.Adapters.Sql.ExecutionHelper.ExecuteXmlReader(SqlCommand sqlCommand, Double totalSeconds)
at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.Polling_TryReceive(TimeoutHelper timeoutHelper, Message& wcfMessage)
at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.TryReceive(TimeSpan timeout, Message& message, IInboundReply& reply)
— End of inner exception stack trace —
at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.TryReceive(TimeSpan timeout, Message& message, IInboundReply& reply)
at Microsoft.ServiceModel.Channels.Common.Channels.AdapterInputChannel.TryReceive(TimeSpan timeout, Message& message)
at System.ServiceModel.Dispatcher.InputChannelBinder.TryReceive(TimeSpan timeout, RequestContext& requestContext)
at System.ServiceModel.Dispatcher.ErrorHandlingReceiver.TryReceive(TimeSpan timeout, RequestContext& requestContext)”.Can anyone please suggest me how to resolve this issue.Can anyone please suggest me how to resolve this issue.
Thanks in advance…
Regards,
Karthick%ufeff
-
If you trace sql profiler to trace the commands, you should see your polling statement being triggered,
and because empty was return, it give you this warning message.
My setting is different, i have ambienttransaction = false, pollwhiledatafound = false
the differences is, in my stored procedure I have this to making it "xml"
if [datarow count] > 0
begin
–xml generating statements
end
else
begin
select ' ' for xml path('')
end
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.