Yeah, from a completely uninformed position, it sounds on the surface like a bug of some sort in SQL 2K5...like the service is announcing that it's started BEFORE the tables are accessible yet. It seems like the common thread is SQL 2K5...
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 09, 2008 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Users unable to log in ** Tomorrow I'm going to add SQL Server agent as a dependency to remedy, so that will give SQL server more time to come up, since SQL Server is a dependency on SQL Server agent. I'm running 7.1 no patch, and 2003 server with sql 2k5. 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: arslist@ARSLIST.ORG 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]> 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] On Behalf Of Rick Cook Sent: Monday, June 09, 2008 3:20 PM To: arslist@ARSLIST.ORG 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]> 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 ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: 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"