"ConnectionWrite (send()).]General network" it seems to be having trouble writing to the DB and from the error seems to be network related. I'd check the connectivity from your application server to your DB server. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701
>>> [email protected] 10/07/10 5:39 PM >>> 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
