Error.log file includes
Mon Jul 05 18:10:30 2010 390600 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:30 2010 0xc0000005
Mon Jul 05 18:10:30 2010 390600 : AR System server terminated -- fatal error
encountered (ARNOTE 21)
Mon Jul 05 18:10:35 2010 390620 : Failure during SQL operation to the database
(ARERR 552)
Mon Jul 05 18:10:35 2010 [DBNETLIB][ConnectionWrite (send()).]General
network error. Check your network documentation. (SQL Server 11)
Mon Jul 05 18:10:36 2010 390635 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010
Timestamp: Mon Jul 05 2010 18:10:37.5460
Thread Id: 360
Version: 7.1.00 Build 200708221849 Aug 22 2007 19:56:34
ServerName: remedytest
Database: SQL -- SQL Server
Hardware: Intel Pentium
OS: Windows NT 5.2
RPC Id: 100
RPC Call: 61 (EXEC)
RPC Queue: 390635
Client: User Remedy Application Service from Unidentified Client (protocol
12) at IP address 10.0.4.39
Form:
Logging On:
Code: c0000005
Operation: read
Access Addr: 0x1758
Stack Begin:
Addr: 4E25218A
Addr: 4E252A91
Addr: 4E255F6C
Addr: 4E25603C
Addr: 4E2560EC
Addr: 0052DE22
Addr: 0052F36F
Addr: 0053E96D
Addr: 00531811
Addr: 2DF8AEE4
Stack End
Mon Jul 05 18:10:36 2010 390635 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Mon Jul 05 18:10:36 2010 0xc0000005
Mon Jul 05 18:10:36 2010 390635 : AR System server terminated -- fatal error
encountered (ARNOTE 21)
Mon Jul 05 18:10:41 2010 390603 : Failure during SQL operation to the database
(ARERR 552)
Thanks & Regards,
Rambabu Rudra
System Administrator
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Wednesday, July 07, 2010 2:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
In that case the ARS Server should be able to connect to the database server.
Do you see anything in the SQL Server logs at the time you start up the ARS
Server? Maybe a bad DB password or connection parameters specified in the
ar.conf file?
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ram Rudra
Sent: Tuesday, July 06, 2010 4:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
Using my SQL Management Studio I can able to access my database from the
ARServer. Port is 1433.
Thanks & Regards,
Rambabu Rudra
System Administrator
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Tuesday, July 06, 2010 11:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
Telnet is not a DB client.. Use the SQL Server client such as the query
analyzer. I know that 2005 onwards installs only the dll's, but if you install
the SQL Management Studio you will get the thick SQL Server client installed
along with it (and not just the libraries). Use this client to connect to the
DB and see if that works.
I understand that you can telnet to the DB server, that only establishes the
network connectivity. You still cannot say with 100% certainty that the DB
client can successfully connect to the DB unless you check its connectivity.
Just out of curiosity, what port are you using when checking with Telnet?
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ram Rudra
Sent: Tuesday, July 06, 2010 5:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
I have run the telnet and port query from ARServer to DB servers. I am able to
access them without any errors.
Also,
Can you tell me if any otherways to perform testing from ARServer to DB servers.
Thanks & Regards,
Rambabu Rudra
System Administrator
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Tuesday, July 06, 2010 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
If you try to connect to the DB from the SQL client on the DB server, it is
obviously going to connect if the DB is up and running. What's the point in
testing that?
Try connecting from the SQL client on the ARS Server.. Your connectivity
between the ARS Server to the DB server is in question so that is what you need
to test if it works or not..
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Rudra Rambabu
Sent: Tuesday, July 06, 2010 12:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
All the 3 Mirrored DB servers in the SQL Mirroring with an instance of
'ARSystem' and with the login ID of 'ARAdmin' are able to login and access the
database successfully from all teh DB Servers. if it is something related to
ARS app, how can we shot it.
Thanks
Ram Rudra
----- Original Message -----
From: "Joe D'Souza" <jdso...@shyle.net>
To: arslist@ARSLIST.ORG
Sent: Tuesday, July 6, 2010 2:41:17 AM
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
Something that I always try when I have a DB connect issue.. Try logging into
the DB using the DB client from the ARS Server machine.. If that fails too then
you have a bigger issue. If that does not fail, then the issue could be assumed
to be ARS related.
Give that a shot and see if you can connect to the DB from the ARS Server using
the DB client.
Joe
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Ram Rudra
Sent: Monday, July 05, 2010 9:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
If I say in an appropriate way,
"One ARServer has to point with two DB mirrored servers with a Unique DB name".
For Unique DB Name I have configured already the DB Aliasing name in the
Database configuration .
Thanks & Regards,
Rambabu Rudra
System Administrator
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell
Sent: Monday, July 05, 2010 6:46 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
Sorry Ram just re-read your original question and incorrectly thought you had
restored a database.
Are you attempting to point your arserver to two completely seperate databases
without a load balancer?
> Thanks for the reply Matt,
>
> Can you tell me how to do that?
>
> Thanks & Regards,
> Rambabu Rudra
> System Administrator
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell
> Sent: Monday, July 05, 2010 6:26 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARSystem Service Unable to Start after ARSystem DB Mirrored
>
> Have you reset the database owner?
>
> sp_dbowner 'aradmin'
>
> Matt
>
>> Hi All,
>>
>>
>>
>> I have mirrored my ARSystem Database with Server 'A' (Principle &
>> Primary
>> DB
>> server) and Server 'B' (Mirrored & synchronized server). Both server 'A'
>> and
>> Server 'B' has configured to DB Alias name which is pointing in the
>> ar.cfg
>> file to talk with Remedy APP server.
>>
>>
>>
>> Now the error is when I restart my ARServer service, it is unable to
>> start
>>
>>
>>
>> I am not sure how can I point both the Server 'A' and Server 'B'
>> Database
>> mirrored servers in the ar.cfg file.
>>
>>
>>
>> My Server details:-
>>
>> Windows 2003 enterprise with sp2 loaded with Remedy application
>>
>> SQL server 2005 enterprise with sp2 configured with ARSystem DB (Server
>> 'A'
>> and Server 'B' with ARSystem Database mirrored).
>>
>>
>>
>> The below is the available arerror.log file comments:-
>>
>>
>>
>> Mon Jul 05 16:03:59 2010 390600 : Failure during SQL operation to the
>> database (ARERR 552)
>>
>> Mon Jul 05 16:03:59 2010 Cannot open database "ARSystem" requested
>> by
>> the login. The login failed. (SQL Server 4060)
>>
>> Mon Jul 05 16:04:03 2010 BRIE : Cannot establish a network connection
>> to
>> the AR System server (Remedytest (0) : RPC: Program not registered)
>> ARERR
>> -
>> 90
>>
>> Mon Jul 05 16:04:03 2010 BRIE : AR System Application server terminated
>> --
>> fatal error encountered (ARAPPNOTE 4501)
>>
>> Mon Jul 05 16:04:14 2010 390600 : Failure during SQL operation to the
>> database (ARERR 552)
>>
>> Mon Jul 05 16:04:14 2010 Cannot open database "ARSystem" requested
>> by
>> the login. The login failed. (SQL Server 4060)
>>
>>
>>
>> Please help me in this regard and let me know if you need any more
>> information about the issue.
>>
>>
>>
>> Thanks & Regards,
>>
>> Rambabu Rudra
>>
>> System Administrator - Windows, Remedy
>>
>>
>>
>> GSS America InfoTech Ltd., (A SEI-CMMI Level 3 company)
>>
>> India Phone - 91 40 44556600 (Ext: 351)
>>
>> VOIP Phone - 1 847 879 4995 (Ext: 351)
>>
>> Mobile (C) +91 90520 42826
>> Email: * <mailto:rambabu.ru...@gssamerica.com>
>> rambabu.ru...@gssamerica.com
>>
>> Web: <http://www.gssamerica.com/> http://www.gssamerica.com
_______________________________________________________________________________
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"
