Re: Simple timeout problem
From: larry franks (larryfr_at_online.microsoft.com)
Date: 09/21/04
- Next message: Proteus Duxbury: "Bad SQL Stored Proc Return Message"
- Previous message: Zach Jason: "Re: BAM interceptor licensing"
- In reply to: larry franks: "Re: Simple timeout problem"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 17:29:55 GMT
Brian, I haven't found anything specific on this error. Would it be
possible to run SQL profiler trace on this machine when the error occurs?
We'd want to limit the trace to just the BizTalkRuleEngineDB.
To run a trace go to SQL Profiler (under the SQL Server entry in the start
menu,) and do a new trace from the file menu.
Select the local SQL server and click ok.
In the properties that come up go to the events tab, add all events. Go to
the data columns tab and add all columns. Next go to the filters tab.
Stop here for a second and open SQL enterprise manager, go to databases,
select the master database and expand it. Highlight tables. Select the
sysdatabases table, right click and select "open table" and "return all
rows". In the window that comes up find the DBID for the
BizTalkRuleEngineDB.
Go back to the SQL Profiler and on the filters tab expand DatabaseID,
equals, and enter the DBID for the database.
Run the trace, reproduce the error and send me the trace file.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn
--------------------
| X-Tomcat-ID: 413963516
| References: <u3XksYUkEHA.1356@TK2MSFTNGP09.phx.gbl>
<sss7ELalEHA.3804@cpmsftngxa10.phx.gbl>
<uQC5R24lEHA.3340@TK2MSFTNGP14.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: larryfr@online.microsoft.com ("larry franks")
| Organization: Microsoft
| Date: Thu, 16 Sep 2004 14:20:57 GMT
| Subject: Re: Simple timeout problem
| X-Tomcat-NG: microsoft.public.biztalk.general
| Message-ID: <FZp6mh$mEHA.740@cpmsftngxa06.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| Lines: 127
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:19595
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Going to have to check a few things on this Brian. The event log errors
| are reporting a timeout condition trying to connect to the SQL database.
| Catalog of BizTalkRuleEngineDB on LOGOS01.
| From this thread I'm assuming LOGOS01 is the local machine, right? Since
| it's local I wouldn't expect the general network error condition.
|
| Larry Franks
|
| This posting is provided "AS IS" with no warranties,and confers no
rights.
| Subscribe at
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
| &SD=msdn
| --------------------
| | From: "Brian Taylor" <taylorb@newsgroups.nospam>
| | References: <u3XksYUkEHA.1356@TK2MSFTNGP09.phx.gbl>
| <sss7ELalEHA.3804@cpmsftngxa10.phx.gbl>
| | Subject: Re: Simple timeout problem
| | Date: Sat, 11 Sep 2004 09:26:13 +1000
| | Lines: 101
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <uQC5R24lEHA.3340@TK2MSFTNGP14.phx.gbl>
| | Newsgroups: microsoft.public.biztalk.general
| | NNTP-Posting-Host: cust0198.qld01.dataco.com.au 202.63.40.198
| | Path:
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
| .phx.gbl
| | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:19618
| | X-Tomcat-NG: microsoft.public.biztalk.general
| |
| | Hi Larry,
| |
| | Below is an example of two event log messages. I rebooted the server
and
| the
| | HAT timeout errors have stopped. Biztalk is still working so I am not
too
| | concerned. I think there is a resource problem with the server. It has
| 1.5GB
| | RAM and is currently running at 2GB. I thought if there was a simple
| setting
| | to extend the timeout that would elimate the error.
| |
| | Brian
| |
| | Event Type: Warning
| | Event Source: RuleEngineUpdateService
| | Event Category: None
| | Event ID: 0
| | Date: 11/09/2004
| | Time: 3:45:53 AM
| | User: N/A
| | Computer: LOGOS01
| | Description:
| | PubSubAdapter::OnTimer :
| Microsoft.RuleEngine.RuleStoreConnectionException:
| | Unable to connect to database "BizTalkRuleEngineDb" on server "LOGOS01"
| | using connection "Initial Catalog=BizTalkRuleEngineDb;Data
| | Source=LOGOS01;Integrated Security=SSPI;Pooling='false';".
| | System.Data.SqlClient.SqlException: General network error. Check your
| | network documentation.
| |
| | Event Type: Warning
| | Event Source: RuleEngineUpdateService
| | Event Category: None
| | Event ID: 0
| | Date: 10/09/2004
| | Time: 11:49:01 PM
| | User: N/A
| | Computer: LOGOS01
| | Description:
| | PubSubAdapter::OnTimer :
| Microsoft.RuleEngine.RuleStoreConnectionException:
| | Unable to connect to database "BizTalkRuleEngineDb" on server "LOGOS01"
| | using connection "Initial Catalog=BizTalkRuleEngineDb;Data
| | Source=LOGOS01;Integrated Security=SSPI;Pooling='false';".
| | System.Data.SqlClient.SqlException: Timeout expired. The timeout
period
| | elapsed prior to completion of the operation or the server is not
| | responding.
| | General network error. Check your network documentation.
| |
| |
| | For more information, see Help and Support Center at
| | http://go.microsoft.com/fwlink/events.asp.
| |
| |
| | For more information, see Help and Support Center at
| | http://go.microsoft.com/fwlink/events.asp.
| |
| |
| | ""larry franks"" <larryfr@online.microsoft.com> wrote in message
| | news:sss7ELalEHA.3804@cpmsftngxa10.phx.gbl...
| | > Can you post the errors you are seeing Brian? Are these showing up
in
| the
| | > event log or are these pop-up dialogs when you are in HAT and the
rules
| | > composer?
| | >
| | > Larry Franks
| | >
| | > This posting is provided "AS IS" with no warranties,and confers no
| rights.
| | > Subscribe at
| | >
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
| | > &SD=msdn
| | > --------------------
| | > | From: "Brian Taylor" <taylorb@newsgroups.nospam>
| | > | Subject: Simple timeout problem
| | > | Date: Fri, 3 Sep 2004 09:40:06 +1000
| | > | Lines: 11
| | > | X-Priority: 3
| | > | X-MSMail-Priority: Normal
| | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | > | X-RFC2646: Format=Flowed; Original
| | > | Message-ID: <u3XksYUkEHA.1356@TK2MSFTNGP09.phx.gbl>
| | > | Newsgroups: microsoft.public.biztalk.general
| | > | NNTP-Posting-Host: 203.47.134.193
| | > | Path:
| | >
|
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
| | > phx.gbl
| | > | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:19316
| | > | X-Tomcat-NG: microsoft.public.biztalk.general
| | > |
| | > | The event log is reporting a timeout error for the rules engine
access
| | > the
| | > | rules database on the local server (running BTS 2004). Is there a
| | > setting
| | > | for this somewhere?
| | > |
| | > | Also HAT is returning a timeout retrieving all the messages in the
| last
| | > | day - is there a setting for this timeout also?
| | > |
| | > | Thanks
| | > | Brian
| | > |
| | > |
| | > |
| | >
| |
| |
| |
|
|
- Next message: Proteus Duxbury: "Bad SQL Stored Proc Return Message"
- Previous message: Zach Jason: "Re: BAM interceptor licensing"
- In reply to: larry franks: "Re: Simple timeout problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
