Re: Remedy Startup
Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
Use a batch file to start the appropriate applications. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
Unfortunately this may not help. For some reason there can be a delay between when the SQL Server service announces that it is up and when it is ready to accept connections - if the Remedy server starts during this time it is unable to connect and quits. Armonitor will restart it but if this fails a number of times it will give up. You can set an environment variable called V_WAIT_BEFORE_STARTUP to delay the start of the server - see my other reply for details. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: 13 June 2012 14:09 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.milmailto:lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
My apologies. Didn't read carefully. You may want to set the dependency for ARS to a service that starts later, maybe something like 'spooler'. Just a thought. From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 9:15:29 AM Subject: Re: Remedy Startup If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
Again you didn't read :)I did that and it didn't help. Mark Walter's undocumented environment variable did work though :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:29 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** My apologies. Didn't read carefully. You may want to set the dependency for ARS to a service that starts later, maybe something like 'spooler'. Just a thought. From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 9:15:29 AM Subject: Re: Remedy Startup If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
Re: Remedy Startup
There are a number of KB entries that mention this - https://kb.bmc.com/infocenter/index?page=contentid=KA333064 - for example, but I agree it would be helpful if it was in the docs somewhere too. I've raised a documentation defect/RFE to request that this be added the AR manual somewhere. Regarding other gems - there are a couple of other variables, one that can control the polling interval used by armonitor when querying dependent services for example, but I can't ever recall ever seeing them used. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 14:28 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12
Re: Remedy Startup
That’s a pretty cool setting.. Don't even need to tweak the registry if you do not want to, to create service dependencies.. 1) Is that really not documented anywhere? When was it introduced? What does the V in the V_WAIT_BEFORE_STARTUP stand for? 2) While it’s a nice setting that would get you there perhaps 90% of the time, it would be even nicer if the design around this was something like, this variable to accept a string instead of a numeral, and this string be a stored procedure that returned an expected known value. This way would be a 100% method of knowing the SQL server is up and more importantly responding... Just my two cents.. Joe -Original Message- From: Longwing, LJ CTR MDA/IC Sent: Wednesday, June 13, 2012 9:28 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives
Re: Remedy Startup
Mark, Thank you again...you may have just added the KB into my 'toolset' again. I have long ago written off this resource as not useful to me on a daily basisI just went and searched on the search string I would have used to try and find this article, and the one you provided was the second item on the list. I may just need to look in there going forward :). I agree however that this should be in the official documentation because it's a config parameter that is available. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:45 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There are a number of KB entries that mention this - https://kb.bmc.com/infocenter/index?page=contentid=KA333064 - for example, but I agree it would be helpful if it was in the docs somewhere too. I've raised a documentation defect/RFE to request that this be added the AR manual somewhere. Regarding other gems - there are a couple of other variables, one that can control the polling interval used by armonitor when querying dependent services for example, but I can't ever recall ever seeing them used. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 14:28 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each
Re: Remedy Startup
You can also set a value in your ar.cfg file: Db-Connection-Retries = Number of times the AR System server tries to reestablish a lost connection to the database. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Wednesday, June 13, 2012 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Mark, Thank you again...you may have just added the KB into my 'toolset' again. I have long ago written off this resource as not useful to me on a daily basisI just went and searched on the search string I would have used to try and find this article, and the one you provided was the second item on the list. I may just need to look in there going forward :). I agree however that this should be in the official documentation because it's a config parameter that is available. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:45 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There are a number of KB entries that mention this - https://kb.bmc.com/infocenter/index?page=contentid=KA333064 - for example, but I agree it would be helpful if it was in the docs somewhere too. I've raised a documentation defect/RFE to request that this be added the AR manual somewhere. Regarding other gems - there are a couple of other variables, one that can control the polling interval used by armonitor when querying dependent services for example, but I can't ever recall ever seeing them used. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 14:28 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. -Original Message- On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02
Re: Remedy Startup
Hi Folks, A quick strings on the 7.6.04 Solaris version of armonitor reveals the following: V_WAIT_BEFORE_STARTUP V_WAIT_BEFORE_POLLING V_POLLING_INTERVAL V_NUM_POLLS V_POLLED_RPC_PROG V_SERVER_NAME V_USER_NAME V_PASSWORD V_LOGFILE_NAME V_EXECUTABLE Maybe V is enVirement? :-) Larry On Wed, Jun 13, 2012 at 9:52 AM, Joe Martin D'Souza jdso...@shyle.netwrote: That’s a pretty cool setting.. Don't even need to tweak the registry if you do not want to, to create service dependencies.. 1) Is that really not documented anywhere? When was it introduced? What does the V in the V_WAIT_BEFORE_STARTUP stand for? 2) While it’s a nice setting that would get you there perhaps 90% of the time, it would be even nicer if the design around this was something like, this variable to accept a string instead of a numeral, and this string be a stored procedure that returned an expected known value. This way would be a 100% method of knowing the SQL server is up and more importantly responding... Just my two cents.. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
According to the documentation, this defaults to 100, retries every 15 seconds, and only applies to an already started and connected remedy server to a db that goes away in the middle of operation...I did not see that this particular option applied to my situation :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, June 13, 2012 8:07 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup You can also set a value in your ar.cfg file: Db-Connection-Retries = Number of times the AR System server tries to reestablish a lost connection to the database. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Wednesday, June 13, 2012 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Mark, Thank you again...you may have just added the KB into my 'toolset' again. I have long ago written off this resource as not useful to me on a daily basisI just went and searched on the search string I would have used to try and find this article, and the one you provided was the second item on the list. I may just need to look in there going forward :). I agree however that this should be in the official documentation because it's a config parameter that is available. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:45 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There are a number of KB entries that mention this - https://kb.bmc.com/infocenter/index?page=contentid=KA333064 - for example, but I agree it would be helpful if it was in the docs somewhere too. I've raised a documentation defect/RFE to request that this be added the AR manual somewhere. Regarding other gems - there are a couple of other variables, one that can control the polling interval used by armonitor when querying dependent services for example, but I can't ever recall ever seeing them used. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 14:28 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. -Original Message
Re: Remedy Startup
Is there somewhere that variables like this are defined? These would seem to be good things to know?? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
I do not have access to it at the moment, but it may be worth checking the ar.h file if you have the API option installed on your AR Server.. This file is the heart and soul of the AR System API, and should have these defined in it.. Joe -Original Message- From: richard@bwc.state.oh.us Sent: Wednesday, June 13, 2012 10:28 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Is there somewhere that variables like this are defined? These would seem to be good things to know?? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
I'd set the ARS service to Automatic (Delayed). We have to do that here for a different reason (too much startup activity is causing the RDP host service to fail) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
That is only on option on Windows Server 2008 and beyond :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jon Slaven Sent: Wednesday, June 13, 2012 9:21 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup I'd set the ARS service to Automatic (Delayed). We have to do that here for a different reason (too much startup activity is causing the RDP host service to fail) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
Once the AR docs turn into a wiki on docs.bmc.com we'll be able to add comments. Not as good as these gems automatically being included by BMC but at least we can add them as we find them. I believe the idea is that the documentation team will be reviewing and updated as appropriate. That or if somebody already has a list of undocumented features as a starter maybe a BMC Communities document would be a good idea? Jason On Wed, Jun 13, 2012 at 6:28 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok Mark, first off, Thank you, that worked the miracle that I needed. Secondly, why isn't that documented anywhere? I have spent roughly 10-15 hours trying to 'fix' this particular problem reading every document I can find, scouring the web, utilizing countless resources to try and do exactly what you just gave me, all to no avail because this option isn't documented. If it had been it may have been an hour or two...but I certainly would have found this documented SOMEWHERE and applied the fix. Thirdly, what other 'gems' does BMC have hidden way in un-documented features that the average or advanced user of the system would find EXCEEDINGLY useful if they only knew it was an option Thank you again...you just pulled yet another thing off of my plate, and for that I'm truly appreciative...I can now move onto bigger and more important things :) -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Walters, Mark Sent: Wednesday, June 13, 2012 7:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup There's an environment variable that you can set to a numerical value - V_WAIT_BEFORE_STARTUP - that will be read by armonitor and it will wait that many seconds before it starts the server. For example, V_WAIT_BEFORE_STARTUP=300 would be a 5 minute delay. One thing to note though is that this delay will happen on every restart of the Remedy service, which can be a nuisance if you want to just bounce the service once it has been running for a while. The variable needs to be set at the system level so that the service can read it and I think a reboot is required when it is set/changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: 13 June 2012 13:58 To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist
Re: Remedy Startup
Maybe this kb is more applicable: https://kb.bmc.com/infocenter/index?page=contentid=KA333064 A search of remedy delay startup hits that as number 1. Axton Grams On Wed, Jun 13, 2012 at 8:15 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
If only google and other search engines were indexing the BMC knowledge base. One would probably find that solution relatively quickly. Axton Grams On Wed, Jun 13, 2012 at 8:42 PM, Axton axton.gr...@gmail.com wrote: Maybe this kb is more applicable: https://kb.bmc.com/infocenter/index?page=contentid=KA333064 A search of remedy delay startup hits that as number 1. Axton Grams On Wed, Jun 13, 2012 at 8:15 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.mil To: arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
The only thing i can think to do is.. Keep the startup of your ar server service manual.. And only when you can login to your SQL Management studio with ARAdmin login you can start the service.. but off course it will be manual thing... which is not always recommended but still worth a try to pin point the issue if not already done. Thanks, Viki From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, June 14, 2012 7:14 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** If only google and other search engines were indexing the BMC knowledge base. One would probably find that solution relatively quickly. Axton Grams On Wed, Jun 13, 2012 at 8:42 PM, Axton axton.gr...@gmail.commailto:axton.gr...@gmail.com wrote: Maybe this kb is more applicable: https://kb.bmc.com/infocenter/index?page=contentid=KA333064 A search of remedy delay startup hits that as number 1. Axton Grams On Wed, Jun 13, 2012 at 8:15 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.milmailto:lj.longwing@mda.mil wrote: If only it did. That particular article is essentially useless to me. It essentially says 'just set your dependencies and you should be good', but I have the dependencies set properly and I'm not goodthe issue that I'm specifically having is that one of their own products is incorrectly reporting as 'started' when it's not available (sql server). The article goes on to say that if you need your service to start 'later' in the process, then to just make it dependent on spooler or messenger. I have done that and STILL it doesn't start late enough in the process to allow SQL to actually become availableso no...that article doesn't give me everything I'm looking for unfortunately. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Avy Mann Sent: Wednesday, June 13, 2012 7:09 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** You want to delay the startup of the AR service. Here is an article that should give you everything you are looking for: http://support.microsoft.com/kb/193888 Enjoy! From: Longwing, LJ CTR MDA/IC lj.longwing@mda.milmailto:lj.longwing@mda.mil To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Wednesday, June 13, 2012 8:57:54 AM Subject: Re: Remedy Startup Andrew, You are correctSQL Server is reporting itself as online, when it's not fully available, and this is screwing up Remedy because it's trying to connect to a DB that's not yet available. I'm looking for a way to delay that startup -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Fremont Sent: Tuesday, June 12, 2012 3:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Remedy Startup ** It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.milmailto:lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_
Remedy Startup
Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Startup
It could be that the SQL service is not up yet by the time AR start. It happened on one of our dev machines after rebooting where both AR and SQL are installed. Andrew. On Tue, Jun 12, 2012 at 2:03 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Ok...my box is running Remedy and SQL Server both and on startup the Remedy service fails to start properly. The arerror.log shows an error about ARAdmin login failing twice, then the process dies. An immediate attempt to start the service functions fine. Checking the SQL Logs I see something along the lines of 12:00:00 Starting ARSystem 12:00:01 Attempted login from ARAdmin failed 12:00:02 Scanning ARSystem 12:00:06 Recovery of ARSystem complete That's not a copy of the log (because I can't get that to the internet)...but that's close to what it saysthis is only happening on one of my boxes, and I suspect that it's a memory related issue because when I check a functional box, I see everything except the login failed line, but it all happens within a second of each other...and my remedy doesn't have any problems starting. I have the Remedy service set to depend on the SQL service, but according to the internet (and my personal experience) the SQL Service reporting as 'up' does not mean that DB's are available. MS recommends that if you need to 'delay' the startup of a particular service that you should set it dependent on 'Spooler'...I've done this but it doesn't help...I need another 5-10 seconds delay with the attempted starting of Remedy serviceany recommendations? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are