Biztalk WCF-SQL发送端口 [英] Biztalk WCF-SQL send port

问题描述

 我在Biz talk wcf-SQL发送端口执行Map以执行发送端口以获取存储过程返回的响应。我在存储过程中有逻辑使用Left或substring函数。

  I am executing Map in Biz talk wcf-SQL send port to execute send port to get the response from stored procedure returns. I have logic in side the stored procedure to use Left or substring functions.

我试图手动执行该proc它工作正常以及我要处理的参数是什么...基于我的条件是进入左或子串逻辑。

I tried to execute that proc manually it is working fine and what ever the parameters i am to proc.. based on the my conditions that is entering into left or substring logic.

来自wcf-sql发送端口它会工作几天没有任何问题，之后它会启动如下所示的错误

from wcf-sql send port it will work for couple of days without any issues after that it starts error like below

当我收到错误并且我尝试使用相同的参数来执行proc而没有问题。当我关闭那个逻辑它会工作，并再次将转换它的逻辑（左或子串）它将工作几天或可能是1天罚款，然后开始
错误的发送端口级别。 

when i got error and i try to use the same parameters to execute the proc and no issues. when i turn off that logic it will work and again will turn that logic(left or substring) in proc it will work for couple of day or may be 1 day fine and then start erroing in send port level. 

我不明白为什么它会在发送端口出现问题。使用子字符串时wcf-sql的任何问题，或者在链接服务器对象调用的存储过程中留下什么问题？

i dont understanding why it giving issue in send port. any issue with wcf-sql when use substring or left in stored procedure with linked server object calling?

任何人都可以帮忙解决这个问题我们需要每隔一段时间发送一个端口？

can any one please help on this do we need to refersh send port every time of interval?

saiabu

推荐答案

您可以发布失败的查询吗？

Could you post the query that fails?

这篇关于Biztalk WCF-SQL发送端口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！