I am seeing quite a few "PreLoginHandshake" errors on my ARERROR.log file. This
also seems to cause ARS to stop responding. Restarting the ARS service does not
solve issue. restarting the server does.
My DBAs are telling me that they do not see any issues with the database. I am
able to log into the DB via Mgmt Studio. I would like guidance on
troubleshooting this issue. Any help appreciated.
How can I check why I'm seeing the errors: Thu Oct 07 13:34:01 2010 390635 :
AR System server terminated -- fatal error encountered (ARNOTE 21)
>From Remedy docs:
ARERR 552
"Failure during SQL operation to the database.
An SQL database error occurred during an operation against the database. An
associated error message contains the full text of the error message from the
database. The error is often a message about running out of space in the
database log or data area. You can correct this by increasing the size of the
data area or by flushing or increasing the size of the log area."
Queue 390635: List Min20 Max20
I cannot find anything relevant to SQL Server 11 message.
Log:
Thu Oct 07 13:33:10 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:33:10 2010 [DBNETLIB][ConnectionWrite (send()).]General
network error. Check your network documentation. (SQL Server 11)
Thu Oct 07 13:33:46 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:33:46 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:34:01 2010 390635 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Thu Oct 07 13:34:01 2010
Timestamp: Thu Oct 07 2010 13:34:02.6780
Thread Id: 4980
Version: 7.1.00 Patch 007 200904160530 Apr 16 2009 06:46:41
ServerName: REMEDYSERVER123
Database: SQL -- SQL Server
Hardware: Intel Pentium
OS: Windows NT 5.2
RPC Id: 5582664
RPC Call: 5 (GLE)
RPC Queue: 390635
Client: User SSUPPORT from Remedy User (protocol 13) at IP address 1.2.3.4
Form: CTM:People
Logging On:
Code: c0000005
Operation: read
Access Addr: 00000000
Stack Begin:
Addr: 77BC6F76
Addr: 005326F7
Stack End
Thu Oct 07 13:34:01 2010 390635 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Thu Oct 07 13:34:01 2010 0xc0000005
Thu Oct 07 13:34:01 2010 390635 : AR System server terminated -- fatal error
encountered (ARNOTE 21)
Thu Oct 07 13:34:23 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:34:23 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:34:44 2010 CMDB Dispatcher : Timeout during database query --
consider using more specific search criteria to narrow the results, and retry
the operation (REMEDYSERVER123) ARERR - 94
Thu Oct 07 13:34:59 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:34:59 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:35:19 2010 Dispatch : Timeout during database query -- consider
using more specific search criteria to narrow the results, and retry the
operation (REMEDYSERVER123) ARERR - 94
Thu Oct 07 13:35:35 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:35:35 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:36:11 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:36:11 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:36:47 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:36:47 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:37:16 2010 BRIE : Timeout during data retrieval due to busy
server -- retry the operation (REMEDYSERVER123.dom.domain.net) ARERR - 93
Thu Oct 07 13:37:18 2010 AssignEng : Timeout during data retrieval due to busy
server -- retry the operation (REMEDYSERVER123.dom.domain.net) ARERR - 93
Thu Oct 07 13:37:24 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
Thu Oct 07 13:37:24 2010 [DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network documentation.
(SQL Server 11)
Thu Oct 07 13:38:00 2010 390635 : Failure during SQL operation to the database
(ARERR 552)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
