Re: SQL Adaptor - Timeout

I have changed the host 'Max. number of message engine threads per CPU.
to be 3 instead of 20 and I have the same error messages.
and I still have the same problem, would you guide me how to configure the
throttling to achieve my targe?

"Leonid Ganeline" wrote:

Hi Tareq,
SQL send port trying to repeat the SP several times then suspend the
message.
If this is a problem with high load try to using throttling to reduce the
load. Try to play with the numbers of retries.

The second variant: call SP from the Expression shape with C# wrapper. In
this case you have more handles to manage this case, but there is more code
development.

--

Regards,

Leonid Ganeline
BizTalk Developer,
Microsoft Certified Technology Specialist: BizTalk Server 2006
http://geekswithblogs.net/leonidganeline/

"Tareq Ali" <TareqAli@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EAEDE7EA-99F6-4323-A37D-632B6D938454@xxxxxxxxxxxxxxxx
I know it is a messleading error message, but the settings are find and the
evidence is that after the retry, the messages are passed sucessfully to
sql
server, and note that not all message produce those error message, some of
them due to heavy load on sql server.

"Benny Mathew" wrote:

Hi Tareq,
From the error it looks like BizTalk does not have access to the database
/
table, check the permissions and try again.
--


Benny Mathew
Seamless Integration Solutions
http://www.seamless.in



"Tareq Ali" <TareqAli@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0CA061E1-DAB7-4CE9-A26B-80DEBFBB0A63@xxxxxxxxxxxxxxxx
Hello,
I have developed a simple bizTalk application that read message and
call
SQL
Server stored procedures using SQL Server Adaptor.
I have large volume of message in a batch, I use envelope to split the
message and use map to construct XML shema which will be sent to the
SQL
Server.

Here are the errors I have got.
The adapter "SQL" raised an error message. Details
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.".
The adapter failed to transmit message going to send port "SendPort1"
with
URL "SQL://TAREQ-ALI/Execution/". It will be retransmitted after the
retry
interval specified for this Send Port. Details:"Timeout expired".
*****
The adapter "SQL" raised an error message. Details "Timeout expired".
---------------------------------------
I have changed the host 'Max. number of message engine threads per CPU.
to be 3 instead of 20 and I have the same error messages.
**************
I understand that SQL server is overload with my request and that is
not
good, I want to reduce the number or request so that my batch will not
take
my sql server down.





.

Relevant Pages

  • Re: Passing a null value as date to SQL
    ... When passing value to a SqlParameter then you have to use DBNull.Value. ... "amber" wrote in message ... > I'm using VB.NET and SQL Server. ... > I'm getting error messages not matter what I try. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlConnection.Open() Which ErrorCodes
    ... goes wrong during the connection phase. ... sys.messages system table for the message_id and text of SQL Server ... See the error messages topic in SQL Books Online. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Replication file sharing violation
    ... It appears from the error messages that you have not shut down an object ... that is accessing the database. ... accessing SQL Server CE is still running. ... > proceeding time will succeed also even if not in step mode. ...
    (microsoft.public.sqlserver.ce)
  • Re: documenation for .NET Data Provider for SQL Server errors
    ... > I was trying to find documenation for the error messages and the ... > provider for SQL Server. ... > The following is the message when the provider times out ...
    (microsoft.public.dotnet.framework.adonet)
  • Connectivity problem
    ... clients started receiving different error messages in the ... SQL Server Message 10054, Possible network error Write to ... Also checked ODBC settings all fine, ...
    (microsoft.public.sqlserver.server)
Loading