Hi Rami,
From the logs you can see that the AR Server is not able to
communicate to the database from time to time. AR System will retry to
set up the connection, and if it fails after a couple of times, it
will stop and you will have to restart the AR Server Service to get it
going again.

Is your AR Server installed on the same machine as the MS SQL server?
You did not answer that question.

You should really ask your dba if he shuts down the database for
backup or things like that from time to time, it looks like at 0600
and 1800 he does things like that.
He could also be able to check this in the Event Viewer on the machin
MS SQL runs at.
If it would be really neccesary for some reason to close the database,
you would first need to stop the AR Server Service and start it when
the database is available again.

Regards,

Michiel

Sun Jul 16 18:00:11 2006  390635 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:00:11 2006     [DBNETLIB][ConnectionRead
(recv()).]General network error. Check your network documentation.
(SQL Server 11)
Sun Jul 16 18:00:11 2006  390635 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:00:11 2006     [DBNETLIB][ConnectionRead
(recv()).]General network error. Check your network documentation.
(SQL Server 11)
Sun Jul 16 18:01:09 2006  390635 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:01:09 2006     [DBNETLIB][ConnectionWrite
(send()).]General network error. Check your network documentation.
(SQL Server 11)
Sun Jul 16 18:01:11 2006  390620 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:01:11 2006     [DBNETLIB][ConnectionWrite
(send()).]General network error. Check your network documentation.
(SQL Server 11)
Sun Jul 16 18:01:19 2006  390635 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:01:19 2006     [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied. (SQL Server
17)
Sun Jul 16 18:01:19 2006  390635 : Failure during SQL operation to the
database (ARERR 552)
Sun Jul 16 18:01:19 2006     [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied. (SQL Server
17)
Sun Jul 16 18:01:19 2006  390635 : SQL database is not available --
will retry connection (ARNOTE 590)
Sun Jul 16 18:01:19 2006  390635 : SQL database is not available --
will retry connection (ARNOTE 590)
Sun Jul 16 18:01:19 2006  390635 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)


On 7/25/06, Rami S Ayoub <[EMAIL PROTECTED]> wrote:
**



Hi Michiel



Find my comment below




Best regards,

Rami S Ayoub




---------------------------------------------------------------------------------------------------------------------------

Hi Rami,




1 - what is in your armonitor and arerror logs?


[Rami S Ayoub] Attached file




2 - what database (make and version) are you using


[Rami S Ayoub] SQL 2000




3 - what platform runs your database and what platform is ARSystem

installed on, is this the same box


[Rami S Ayoub] Windows 2003, 6.0.1




4 - what version and patch of AR System do you have installed


[Rami S Ayoub] Patch 1409



---------------------------------------------------------------------------------------------------------------------------


Michiel



On 7/25/06, Rami S Ayoub <[EMAIL PROTECTED]> wrote:

> Hi list...

>

> I have problem

>

> 1- The server loses connectivity with the Database.

> 2- The Database doesn't show that the server down

> 3- and also the service still up, but the server hang????????

> 4- It happens every day morning...

>

> Thanks

> Rami S Ayoub

>

>
_______________________________________________________________________________

> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

>



_______________________________________________________________________________

UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
 __20060125_______________________This posting was
submitted with HTML in it___


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Reply via email to