Read back a few months in the list - I posted about this bug several times beginning 14 April, and opened Issues with both BMC and Microsoft. Microsoft had issues with their own patch - it affected some of their VPN services on RRAS servers. It took Microsoft and BMC until July to actually figure out what was going wrong and develop changes. BMC had me test a special build of the 7.1 arserver that alleviated the startup problem, but they never released it into a patch; Microsoft provided instructions for installing a shim to fix it, but it was a fairly obtuse process that I only tested on one server. MS also released some security updates in September that _may_ have actually fixed the issue by overwriting some dlls from the KB2509553 code; they won't admit it. I had one 7.1 server that I could reliably reproduce the problem on from April to August by installing or uninstalling KB2509553, and after the September Microsoft updates I was unable to get it to fail.
As an aside, the effect of the patch was to block the initial connections that the armonitor-arserver make to the SQL Server (watch one sometime using select * from sys.dm_exec_connections order by connect_time desc ). When the SQL Server is running and ARS is not, you will see 4 or 5 local connections. When the ARS first starts up it will make roughly a dozen connections, for less than a minute, depending on how many RPC thread ports you have defined. Then it drops to only one external connection while the ARS starts up (and in my estimation, struggles for a while to get all of the java plugins loaded), until it finally finishes loading several minutes later and opens dozens of connections (my servers usually have from 40 connections on a test server to 108 on production). When the KB was blocking the arserver.exe, there were NO additional connections made to the SQL Server on startup. I first saw it while upgrading a server from 7.1 to 7.5 on the way to 7.6.03/04. I never saw it on any of my 7.6.04.01 servers - it may have been eliminated in 7.6.03 by accident and did not occur on the 7.6.04.01 server we were prepping in July for production in August, but I kept the security patch off all of my other servers until September. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Larry Barnes Sent: Thursday, November 10, 2011 3:17 PM To: [email protected] Subject: Re: Fresh ARS 7.5.0 install issues ** Here's a link to an article about installing apps via RDP. Was given to me by one of our server engineers. http://www.bidn.com/blogs/ShawnHarrison/ssis/2046/installing-applications-on-windows-server-through-rdp Larry B. Remedy, HP3000, & Level II Support The contents of this message, together with any attachments, are intended only for the use of the individual or entity to which they are addressed and may contain information that is legally privileged, confidential or otherwise exempt from disclosure. If you are not the intended recipient, you are prohibited from disseminating, distributing, or copying this message or any attachment. If you have received this message by mistake, please let the sender know by email reply and immediately delete this message, along with any attachments, from your system. Thank you. ________________________________ From: Larry Barnes Sent: Thursday, November 10, 2011 11:36 AM To: '[email protected]' Subject: RE: Fresh ARS 7.5.0 install issues Hello everyone that has replied with suggestions First a BIG thank you for them!!! Now for the solution: It appears that Remedy Support was correct, this time. I removed a MS patch, 2509553, then uninstalled ARS and rebuilt the ARSystem DB (using a script provided by our DBA). Then rebooted the app server and restarted the ARS install. It worked well!!! I had a few warnings but they are doable. I'm not sure why this MS patch would have been an issue but I will be asking BMC about that. Larry B. Remedy, HP3000, & Level II Support The contents of this message, together with any attachments, are intended only for the use of the individual or entity to which they are addressed and may contain information that is legally privileged, confidential or otherwise exempt from disclosure. If you are not the intended recipient, you are prohibited from disseminating, distributing, or copying this message or any attachment. If you have received this message by mistake, please let the sender know by email reply and immediately delete this message, along with any attachments, from your system. Thank you. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Thursday, November 10, 2011 8:54 AM To: [email protected] Subject: Re: Fresh ARS 7.5.0 install issues ** Larry, I would HIGHLY recommend trying to re-install the application in the default directory (c:\program files (x86)) and see if you still have the problems...I don't know the reason for MS putting 32 bit apps in the 32 bit folder...but I think it has something to do with how it handles the file (knowing that it's 32 bit because it's in that dir)...I don't know if moving it out of that dir 'does something'...but I suspect it might. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Larry Barnes Sent: Thursday, November 10, 2011 9:38 AM To: [email protected] Subject: Re: Fresh ARS 7.5.0 install issues ** Matt, Thanks for the tip; I asked our DB Admin and he verified that the TCP connections were enabled and confirmed we are using 1 IP address for this database. We do see records being created in the ARSystem db during the install so we don't believe that is the issue. As for the comments about 32 & 64 byte versions. We are attempting to install a 32 byte version on a 64 byte server; we want it to match what's on our production server. I did open a ticket with BMC and was VERY surprise by their unusual quick response. The want me to remove a MS patch (2509553) and try the install again. There was no mention why this might cause a problem so I'm researching that at this time. Stay tuned, Again, I appreciate your suggestions. I trying to learn the ins/outs of this application Larry B. Remedy, & HP3000 support The contents of this message, together with any attachments, are intended only for the use of the individual or entity to which they are addressed and may contain information that is legally privileged, confidential or otherwise exempt from disclosure. If you are not the intended recipient, you are prohibited from disseminating, distributing, or copying this message or any attachment. If you have received this message by mistake, please let the sender know by email reply and immediately delete this message, along with any attachments, from your system. Thank you. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Matt Reinfeldt Sent: Wednesday, November 09, 2011 7:09 PM To: [email protected] Subject: Re: Fresh ARS 7.5.0 install issues ** Larry, Really silly question here, but have you checked the SQL Server Configuration to ensure that TCP connections are enabled? And that you've gotten them set up for the right IP Address? I've seen this cause more headaches (especially when using cloned VMs, etc.) than anything else during installations. Normally, it's the first area I check when having issues. Good luck! Matt R. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Larry Barnes Sent: Wednesday, November 09, 2011 5:15 PM To: [email protected] Subject: Fresh ARS 7.5.0 install issues ** Ok, I've beat my head against a wall so much it hurts now! I'm trying to install a fresh copy of ARS 7.5.0 to a fresh ARSystem db shell. This is on a Windows 2003 server using SQL 2005. The database resides on a separate server from ARS. I've resolved all the issues except the below and I'm stumped on this one. Can't find anything online either so I'm looking for some pointers. I have done this install 4 or 5 times and never had this problem before. 1. It's attempting to start the following service and stalls for 40 minutes and then dies and the install then fails. BMC Remedy Action Request System Server <server-name> 1. Has anyone else seen this error? I got this from the System Events log "The BMC Remedy Action Request System Server <server-name> service terminated with service-specific error 1064 (0x428)" 1. Here's what it placed in the armonitor.cfg file: Monitor-directory: "D:\ARS" "D:\ARS\arserver.exe" -i "D:\ARS" -l "C:\Program Files (x86)\Common Files\AR System\Licenses\<server-name>" -m 1. This is from the armonitor log: Wed Nov 09 14:43:57 2011 (ARNOTE 0) Wed Nov 09 14:43:57 2011 Starting AR Monitor version 7.5.00 Build 200812291922. Wed Nov 09 14:43:57 2011 (ARNOTE 0) Wed Nov 09 14:43:57 2011 AR Monitor started. Wed Nov 09 14:43:57 2011 (ARNOTE 0) Wed Nov 09 14:43:57 2011 ARMonitor child process (pid:3888) started. "d:\ars\arserver.exe" Wed Nov 09 14:43:57 2011 (ARNOTE 0) Wed Nov 09 14:43:57 2011 Pausing for max 900 seconds or until server up. Wed Nov 09 14:43:58 2011 (ARNOTE 0) Wed Nov 09 14:43:58 2011 The Server process terminated. Wed Nov 09 14:43:58 2011 (ARNOTE 0) Wed Nov 09 14:43:58 2011 Attempting to terminate ARMonitor child process (pid:3888). "d:\ars\arserver.exe" Wed Nov 09 14:43:58 2011 Failure occurred during execl() (ARERR 33) Wed Nov 09 14:43:59 2011 (ARNOTE 0) Wed Nov 09 14:43:59 2011 ARMonitor child process (pid:3888) died with 128. "d:\ars\arserver.exe" Wed Nov 09 14:43:59 2011 AR System server terminated normally (ARERR 32) Wed Nov 09 14:43:59 2011 AR Monitor stopped. Wed Nov 09 14:43:59 2011 (ARNOTE 0) Wed Nov 09 14:43:59 2011 Unable to start arserver process. Bye... This is what it added to the ar.cfg file it created. Server-Name: <server-name>. Server-directory: D:\ARS\ARServer\Db Multiple-ARSystem-Servers: T Register-With-Portmapper: T TCD-Specific-Port: 0 Plugin-Port: Alternate-Approval-Reg: T Currency-Ratio-Client-Refresh-Interval: 60 Homepage-Form: Home Page Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 2 2 Private-RPC-Socket: 390635 2 2 Plugin-Path: D:\ARS Plugin-Path: D:\ARS\pluginsvr Plugin: ardbcconf.dll Plugin: reportplugin.dll Plugin: ServerAdmin.dll Plugin: FlashboardObject.dll Server-Plugin-Alias: ARSYS.ARF.REGISTRY ARSYS.ARF.REGISTRY <server-name>.thecreek.com:9999 Db-name: ARSystem Db-user: ARAdmin Sybase-Server-Name: <sql server name> SQL-Secure-Connection: F Cache-Mode: 1 Larry B. Remedy & HP3000 Support The contents of this message, together with any attachments, are intended only for the use of the individual or entity to which they are addressed and may contain information that is legally privileged, confidential or otherwise exempt from disclosure. If you are not the intended recipient, you are prohibited from disseminating, distributing, or copying this message or any attachment. If you have received this message by mistake, please let the sender know by email reply and immediately delete this message, along with any attachments, from your system. Thank you. _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.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"
