Well, I could not reproduce the issue, in affect of where it is preventing
users from logging in. I did, however, add the following to the registry:
HKEY_LOCAL_MACHINE
SYSTEM
CURRENTCONTROLSET
SERVICES
BMC ACTION REQUEST SYSTEM SERVER
DEPENDONSERVICE
SQLSERVERAGENT
I then rebooted my server, and when it came up, cycled sql server agent to
validate that it cycled remedy too. So now, remedy has another dependency of
sql server agent, which gives it around 5 - 15 seconds after sql server says it
is up. Hopefully this will solve my issue, but I'm only having the issue around
once a month, not on the same day or on the same time either.
I just thought I'd post my attempted solution and see if it works, so anyone
else with the same issue can try it if they want to.
Thanks,
Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company
________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Jason Miller
Sent: Monday, June 09, 2008 3:41 PM
To: [email protected]
Subject: Re: Users unable to log in
** I too have noticed that our ARS 7.0.1 p6 tries to start before SQL 2005 is
ready. Both are on the same 2003 server.
Jason
On Mon, Jun 9, 2008 at 1:26 PM, Gary Opela (Corporate) <[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
**
The DB and ARServer are on the same server. I just found out that server was
rebooted at the same time.
I checked my dependencies and it shows that SQL Server is a dependency of AR
System, so the sql server should come up first and then arsystem should.
For some reason, arsystem looks like it's trying to start before sql server is
up clean.
Anyone have any ideas? Rick, I think you are right on the money with what the
issue is, the problem is why is remedy trying to load prior to the database?
Thanks,
Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[email protected]<mailto:[email protected]>] On Behalf Of Rick Cook
Sent: Monday, June 09, 2008 3:20 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: Users unable to log in
** Gary, this looks like it might be a connectivity issue between AR System and
the DB. This often happens when the DB is taken down for backups and then
brought back up without restarting AR System. Have you verified that this is
not the problem? If it all works again after bouncing AR System, that might be
the culprit.
Rick
On Mon, Jun 9, 2008 at 1:15 PM, Gary Opela (Corporate) <[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
**
This is the second time this has happened. I come in to work in the morning,
and no one can log in. I have to cycle remedy on the server to get it to work.
It is throwing a miscellaneous TLI error from the client, or from the MT, just
saying authentication failed.
Below is from the error logs:
Sun Jun 08 08:10:48 2008 390695 : Unable to extract minor version from Java VM
version string: 10.0-b19 (ARERR 9130)
Sun Jun 08 08:10:56 2008 : Action Request System(R) Server Version 7.1.00 Build
200708221849
(c) Copyright 1991-2007 BMC Software, Inc.
Sun Jun 08 08:10:56 2008 390600 : Failure during SQL operation to the database
(ARERR 552)
Sun Jun 08 08:10:56 2008 Cannot open database "ARSystem" requested by the
login. The login failed. (SQL Server 4060)
Sun Jun 08 08:10:57 2008 390695 : Unable to extract minor version from Java VM
version string: 10.0-b19 (ARERR 9130)
Sun Jun 08 08:11:11 2008 390600 : SQL database is now available (ARNOTE 592)
Sun Jun 08 08:11:11 2008 390600 : SQL database is not available -- will retry
connection (ARNOTE 590)
Sun Jun 08 08:11:11 2008 Cannot open database "ARSystem" requested by the
login. The login failed. (SQL Server 4060)
Sun Jun 08 08:43:36 2008 Dispatch : Cannot establish a network connection to
the AR System server (hqrem (0) : RPC: Program not registered) ARERR - 90
Sun Jun 08 08:43:36 2008 Dispatch : AR System Application server terminated --
fatal error encountered (ARAPPNOTE 4501)
Java information is as follows:
java version "1.6.0_05"
Java(TM) SE Runtime Environment (build 1.6.0_05-b13)
Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode, sharing)
I saw someone post they were getting the same error, about being unable to
extract minor version from java VM.
Basically, I'm randomly seeing the java error in my logs. But occasionally,
about five to eight seconds after that error, as you can see above, my
connection to the database is severed, and remedy cannot recover. It tries to
cycle itself, then it says that it comes up, but then it fails immediately, and
cannot recover until I manually cycle it when I come in.
Do you all think I need to go to a 1.5 java version, or do you think that
something else might be to blame?
Users with static passwords, as well as users using cross ref blank passwords
are affected, it does not care where their login password is stored.
Thanks,
Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company
__Platinum Sponsor: www.rmsportal.com<http://www.rmsportal.com> ARSlist: "Where
the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com<http://www.rmsportal.com> ARSlist: "Where
the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com<http://www.rmsportal.com> ARSlist: "Where
the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
