CMDB - RE Job performanace issue
Hi List, We have one RE Job but its taking much more time to process the records than it should take... Its processing only 12 records per sec..instead it should process 60 records per seconds... CMDB Version- 7.6.04 All possible suggestions are appreciated -Harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CMDB 7.6.04 –RE Job performance issue
Hi List, We have one RE Job but its taking much more time to process the records than it should take... Its processing only 12 records per sec..instead it should process 60 records per seconds... All possible suggestions are appreciated -Harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WARNING: 7.6.X DDM AND ITSM
Guillaume With all the money and resources that BMC spent on DDM,they could have just paid Misi from RRR to make RRR|Chive prettier, i.e. essentially having a GUI and colorful reports so management **thinks** it's enterprise ready. Our customers have told us, and BMC, the same reference AtriumSSO. And I think there's an important point here - one I made to the poor BMC person who's coming to RUG and receiving a dressing down over support. If you try to be good at everything, you'll almost certainly fail. Stick to the core business and do it well. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
SSO with IIS and Tomcat - Anonymous and Windows Authentication
Hi, I have configured Remedy to use SSO using the instructions in AREA_SSO_ALL_v206MT_v209AREA zip file. Environment ARS 7.6.04 Windows 2008 64 bit IIS 7.5 Tomcat 6 I’ve updated the server.xml file in the apache conf directory to include tomcatAuthentication=false In IIS I have disabled Anonymous Authentication and enabled Windows Authentication. For users who are included in the AD they can successfully login with SSO. But users who only have a local Remedy account and don’t exist in AD will get an authentication error. Remedy attempts to automatically authenticate the users with their AD details, but as they don’t exist in Remedy using their AD details they get the authentication issue. I was expecting that if SSO failed the Remedy login page would be displayed. I’ve read that in IIS both Anonymous and Windows Authentication should be enabled, but if I enable Anonymous authentication the login page is always displayed to the users stopping SSO from working. The Mid Tier logs capture the following, so with Anonymous Authentication enabled the Remote User name is not returned. 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SERVLET) : GoatServlet: url=http://serverxxx/arsys/home 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SERVLET) : cookie=G=2c571170edfbf9c6:-2a327bea:1379d3ab208:-7fff; JSESSIONID=1055C3140E821C1E676A8C933D7031FF; P=0; st=5400; lt=60; GKW= %7B14%3A%7Bn%3A%22LASTID%22%2Ct%3A6%2Cv%3Anull%7D%2C15%3A%7Bn%3A %22LASTCOUNT%22%2Ct%3A7%2Cv%3A0%7D%7D; P=1 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SERVLET) : GoatServlet: No session or new session 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SESSION) : Login: establishing Session 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SESSION) : SSO ERROR: RemoteUser name is null or empty. Using default login page 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SESSION) : Login: Custom authenticator failed. Trying default authenticator 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SESSION) : DefaultAuthenticator: Credentials requested 13-Jun-2012 10:54:49 - FINE (com.remedy.log.SESSION) : DefaultAuthenticator.redirectToLogin: url=/arsys/home Is there a way to configure IIS to allow users in AD to authenticate using SSO and the Remedy login page to be displayed for users who don’t exist in AD? Thanks Phil ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
SSO with IIS and Tomcat - Anonymous and Windows Authentication
Phil I’ve read that in IIS both Anonymous and Windows Authentication should be enabled, but if I enable Anonymous authentication the login page is always displayed to the users stopping SSO from working. I'm pleased the JSS documentation was of assistance :-) Unfortunately, this advice isn't relevant to the community code. IIS front ends are a limited. Additional effort is required to secure it and build a solution meeting your requirements. This is why we've developed our own IWA adapter, a fully featured Kerberos/NTLMv2 solution for maximum interoperability. We recommend it to all AD integrations because IIS offers nothing to the majority of IWA installations. And then you have other issues, such as what happens when a user doesn't exist in ITSM? Most users don't want to see a login screen - it promotes a call to the help desk. And if they call the help desk, what are they going to say? It's much better to have incidents automatically raised against the actual error (no account, account locked, NTLM/Kerberos failure, etc) so the incident is both known to the support desk and routed to the correct team . The community code is good for small installations, proof of concepts, etc. It's not something suitable for an enterprise environment. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
blank webpage after clicking on KB article.
Hi All, Users are getting blank web page after clicking on KB Articles. The KMS Config does not have any connectivity errors with AR Server or Hummingbird. Environment: Windows 2003 AR Server 7.1 RKM 7.2 with patch 005 Mid-tier 7.5 Please suggest Thanks Rambabu Rudra Sr Systems Engineer - ITSM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Configuring a Solaris 10 server to run as an Escalation server – Pointers Needed
Good Morning Listers, *The Problem:* We have lots of escalation traffic running on our system, which causes our current Windows Escalation server to be over-taxed. To the best of my knowledge, there is no way to run escalations on more than one server at any given time. *Solution Attempted:* So, we are in the process of standing up and configuring a new AR server on Solaris 10, hoping that this will have more horsepower to handle the large traffic. But we are having some issues. First off, we are not seeing the increase in processing time that we had hoped for. We are also seeing various errors show up whenever escalations fire workflow that touches the CTM:People form. It’s important to note that these do not show in the arerror.log, but rather they appear in the Putty session that was used to start the AR Server process. Examples of errors are as follows: Error signaling server server name Message number : 91 Message : RPC call failed Appended : RPC: Unable to receive; An event requires attention Status Struct : Message type : ERROR Error signaling server server name Status List : 1 items in thread Status List : 1 items Message number : 90 main Message : Cannot establish a network connection to the AR System server Appended : server name: RPC: Success Message : RPC call failed java.lang.NoClassDefFoundError: http://localhost:8080/rkm/fromRemedy/jsp?reset=remedyUsers Message type : ERROR There are other issues as well, such as the ARDBC Plugin appearing to load repeatedly every 10 minutes or so, after the AR Server starts. We have tried increasing and decreasing the List and Fast threads. The Escalations that we are testing are running on dedicated pools, and we have added the necessary threads to support those pools. The server does not show that it is being maxed out on memory or CPUs. *Bottom Line: * I think we just do not have this Solaris box configured correctly for Remedy. Perhaps we are approaching this with a “Windows” mentality and missing some key steps. So, my question is; is there anyone out there that is knowledgeable in configuring AR Servers on Solaris, and/or has seen these issues before. I could really use some pointers here as I am trying to guide the customer in the right direction, with my limited experience/knowledge in UNIX environments. *Here are our specs:* ARS 7.1 p11 ITSM 7.0 DB Oracle10 running on Solaris 10 All AR Servers are running on Windows Server 2003, (with the exception of the new Escalation server which is running on Solaris 10) We have a dedicated AR Server for Administrator functions and a dedicated server for Escalations. Thanking all you Solaris Gurus in Advance, Ron ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
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
Web Services Error
AR Suite 7.6.04sp1 Win 2008r3 64bit MSSQL 2012 64bit I am trying to establish a connection to a wsdl on a non-AR site but I keep receiving an error concerning certificate issues. sun.security.validatorexception:pkik path building failed: I have obtained a signed certificate for the site and can access the wsdl from a browser on my AR Server without receiving any certification errors but both the Atrium Web Services Registry Console and Developer Tool return the above error (the registry returns a longer error : Error opening connection to URL https://dctrack2/axis2/services/TicketingService?wsdl; ! Cause:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target) I have also registered the certificate in my Java keystore on both the AR server and my machine where Developer Studio is running. Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:image001.png@01CD493A.CF82D080]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 - mobile 972.899.2366 - office 972.899.2898 - fax ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
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 7.6.04 Logon Audit Data
Hi, As for the Historical License Usage form, with supposedly should keep track of each session, I still am of the opinion that it is faulty. And as LJ said, it does not track Read-license-users. And it definitely does not track Application licenses. The best way is to use the User-logging functionality, either File-based or Form-based. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Rahul, You can turn on license tracking in the Admin Console for 'Server Information'...and optionally turn on tracking for read licenses as well. This will record data for every login and logout of every user and can be used in server groups effectively. You can alternately turn on user logging to either form or file, which does effectively the same thing, but does it in log format. Either option has availability of tools to evaluate the data collected and can present various information and recommendations. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of rahul bose Sent: Monday, June 11, 2012 12:54 PM To: arslist@ARSLIST.ORG Subject: Remedy 7.6.04 Logon Audit Data ** Is there a way table in the backend which can capture or keep a track the Individual Logon and Logout to remedy ? -- Your's Sincerely Rahul Bose _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 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
Re: Development question
Hi, If you walk your table, and then perform a service-call to the details-records one at a time. Whatever happens inside that service-call (a push-fields to the details-record in this case), will be committed to the database before the service-call exits. This will then enable you to do a COLSUM(), or some such thing, on your details-records after your table-walk has been completed. The drawback is that the details-updates will be committed to the database even though a later update should fail with an error... Another drawback is that Doug Mueller has told me that if it works like that, it is a bug, and should be fixed. But I have seen no evidence of this being addressed in the 3 service packs released so far... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Can't use active links. The parameter can be changed from another form using a push and active links won't be triggered. Thanks! El miércoles, 13 de junio de 2012, Joel Sender escribió: ** Jose, You might try it in stages; **1. **An active link pushes the new Invoice value to all the detail entries **2. **A filter recalculates each detail’s value(s) **3. **A second active link (higher exec order) recalculates (or triggers filters to recalc) Invoice values from the detail entries. HTH, *Joel*** Joel Senderjdsen...@earthlink.net javascript:_e({}, 'cvml', 'jdsen...@earthlink.net');310.829.5552 ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG');] *On Behalf Of *Jose Huerta *Sent:* Monday, June 11, 2012 5:27 AM *To:* arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG'); *Subject:* Development question ** ** ** Hi listers, ** ** I have a question for developers. I've got a solution, but I want to know if there is a better option, since it doesn't satisfy me 100%. ** ** Here's the case (It's not really my case, but a simplified version of it): ** ** I have one form: AAA:Invoices. This form has a table field that shows related requests on AAA:DetailLines. ** ** So each invoice in AAA:Invoices is related to several Detail Lines in AAA:DetailLines. ** ** I have a field in AAA:Invoices that is a parameter used to compute the value of the detail lines. I call it: InvoiceParameter. I have a filter that when InvoiceParameter is changed, it propagates it to all related detail lines. When those lines are modified, they automatically (with filters) recalculate their value. ** ** I also have a total value field at AAA:Invoices that it is the sum of the detail lines. I want to keep it updated, so I thinked some options, but concurrency makes the result going wrong. ** ** Summarizing the case: The objective is that when modifying the field InvoiceParameter at an Invoice, it propagates to the detail lines, recalculating its value, and returns to the invoice with the total as the sum of all detail lines. ** ** If I do it with a filter, the contents of the table at AAA:Invoice is not updated until the end of the transaction. So I can't see the new values. And If I use parameter sending, only one of the detail lines, do actually change the value, the rest are lost, (beacuse concurrency). ** ** Using the override phase at PUSH actions, it overrides the ARS action, but not the SQL sending, that is sent at the end. ** ** ** ** My solution is to have a filter at AAA:Invoice that propagates the InvoiceParameter to the detail lines. Then the detail lines compute the result and make a PUSH to the Invoice marking a flag field (so no concurrency error is possible). Then an escalation executes at every minute on marked invoices, that computes the total. ** ** I hate using escalations for complex computations. Do you know any other way to achieve my objective without escalations? Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares
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 at
Re: Migration from Solaris/Oracle to Windows/MSSQL
Hi, Do a fresh install, import the definitions (maybe using Migrator). But use RRR|Chive instead to move the data. It is faster and more robust in this regard, and is designed to handle a high volume of records. Documentation, no login required: https://www.rrr.se/c/doc/rrrchive/?arslist Download and configuration: https://www.rrr.se/cgi/rrrchive/main?arslist Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, We're currently in the process of moving a Solaris/Oracle (11g) based system to a Windows/MSSQL (2012) environment. While using Migrator should absolutely work, the fastest way would be to just import the Oracle DB into the new MSSQL DB and we'd prefer that. The problem here is, that there are two providers in MSSQL to import data from Oracle databases and both don't manage to import all data completely and correctly. The .net Framework Data Provider for Oracle doesn't copy views, but manages to import all data, but the views would be required for the AR server to function correctly. The Microsoft OLE DB Provider for Oracle does copy views as well, but doesn't set the correct data types when creating tables and thus fails to import data after some time. The question is: has anyone performed a migration from Oracle to MSSQL by just importing the database to the MSSQL server? Or should we just stick with the Migrator for this matter? Regards Jan Hartung ___ 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
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: Development question
Very happy until reading your last sentence :) I can't provide a development based on a bug. If someday BMC solves it, then my development will crash. Thanks! Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Jun 13, 2012 at 3:46 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, If you walk your table, and then perform a service-call to the details-records one at a time. Whatever happens inside that service-call (a push-fields to the details-record in this case), will be committed to the database before the service-call exits. This will then enable you to do a COLSUM(), or some such thing, on your details-records after your table-walk has been completed. The drawback is that the details-updates will be committed to the database even though a later update should fail with an error... Another drawback is that Doug Mueller has told me that if it works like that, it is a bug, and should be fixed. But I have seen no evidence of this being addressed in the 3 service packs released so far... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Can't use active links. The parameter can be changed from another form using a push and active links won't be triggered. Thanks! El miércoles, 13 de junio de 2012, Joel Sender escribió: ** Jose, You might try it in stages; **1. **An active link pushes the new Invoice value to all the detail entries **2. **A filter recalculates each detail’s value(s) **3. **A second active link (higher exec order) recalculates (or triggers filters to recalc) Invoice values from the detail entries. HTH, *Joel*** Joel Senderjdsen...@earthlink.net javascript:_e({}, 'cvml', 'jdsen...@earthlink.net');310.829.5552 ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG ');] *On Behalf Of *Jose Huerta *Sent:* Monday, June 11, 2012 5:27 AM *To:* arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG'); *Subject:* Development question ** ** ** Hi listers, ** ** I have a question for developers. I've got a solution, but I want to know if there is a better option, since it doesn't satisfy me 100%. ** ** Here's the case (It's not really my case, but a simplified version of it): ** ** I have one form: AAA:Invoices. This form has a table field that shows related requests on AAA:DetailLines. ** ** So each invoice in AAA:Invoices is related to several Detail Lines in AAA:DetailLines. ** ** I have a field in AAA:Invoices that is a parameter used to compute the value of the detail lines. I call it: InvoiceParameter. I have a filter that when InvoiceParameter is changed, it propagates it to all related detail lines. When those lines are modified, they automatically (with filters) recalculate their value. ** ** I also have a total value field at AAA:Invoices that it is the sum of the detail lines. I want to keep it updated, so I thinked some options, but concurrency makes the result going wrong. ** ** Summarizing the case: The objective is that when modifying the field InvoiceParameter at an Invoice, it propagates to the detail lines, recalculating its value, and returns to the invoice with the total as the sum of all detail lines. ** ** If I do it with a filter, the contents of the table at AAA:Invoice is not updated until the end of the transaction. So I can't see the new values. And If I use parameter sending, only one of the detail lines, do actually change the value, the rest are lost, (beacuse concurrency). ** ** Using
Re: Development question
Hi, Well, I don't think it's a bug, and I don't think they will fix it. I suggest that you try it, and then ask BMC if this is as designed. The consistency of this bug is thorough, and I have depended heavily on it in an internal RRR-system I built right after 7.6.04 was released. Best Regards - Misi, RRR AB, http://rrr.se Very happy until reading your last sentence :) I can't provide a development based on a bug. If someday BMC solves it, then my development will crash. Thanks! Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Jun 13, 2012 at 3:46 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, If you walk your table, and then perform a service-call to the details-records one at a time. Whatever happens inside that service-call (a push-fields to the details-record in this case), will be committed to the database before the service-call exits. This will then enable you to do a COLSUM(), or some such thing, on your details-records after your table-walk has been completed. The drawback is that the details-updates will be committed to the database even though a later update should fail with an error... Another drawback is that Doug Mueller has told me that if it works like that, it is a bug, and should be fixed. But I have seen no evidence of this being addressed in the 3 service packs released so far... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Can't use active links. The parameter can be changed from another form using a push and active links won't be triggered. Thanks! El miércoles, 13 de junio de 2012, Joel Sender escribió: ** Jose, You might try it in stages; **1. **An active link pushes the new Invoice value to all the detail entries **2. **A filter recalculates each detail’s value(s) **3. **A second active link (higher exec order) recalculates (or triggers filters to recalc) Invoice values from the detail entries. HTH, *Joel*** Joel Senderjdsen...@earthlink.net javascript:_e({}, 'cvml', 'jdsen...@earthlink.net');310.829.5552 ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG ');] *On Behalf Of *Jose Huerta *Sent:* Monday, June 11, 2012 5:27 AM *To:* arslist@ARSLIST.ORG javascript:_e({}, 'cvml', 'arslist@ARSLIST.ORG'); *Subject:* Development question ** ** ** Hi listers, ** ** I have a question for developers. I've got a solution, but I want to know if there is a better option, since it doesn't satisfy me 100%. ** ** Here's the case (It's not really my case, but a simplified version of it): ** ** I have one form: AAA:Invoices. This form has a table field that shows related requests on AAA:DetailLines. ** ** So each invoice in AAA:Invoices is related to several Detail Lines in AAA:DetailLines. ** ** I have a field in AAA:Invoices that is a parameter used to compute the value of the detail lines. I call it: InvoiceParameter. I have a filter that when InvoiceParameter is changed, it propagates it to all related detail lines. When those lines are modified, they automatically (with filters) recalculate their value. ** ** I also have a total value field at AAA:Invoices that it is the sum of the detail lines. I want to keep it updated, so I thinked some options, but concurrency makes the result going wrong. ** ** Summarizing the case: The objective is that when modifying the field InvoiceParameter at an Invoice, it propagates to the detail lines, recalculating its value, and returns to the invoice with the
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: WARNING: 7.6.X DDM AND ITSM
The problem comes down to evaluation process. Generally people do some sort of paper based RFP and they ask things like: a) Do you have SSO (yes) b) Do you have Surveys (yes) c) Do you have Calendars (yes) d) Do you have SRM (yes) etc…. Then - an implementation time - you find out -- yes it has SSO - however on a 1 to 10 scale -- probably a 1… etc… So - instead of asking - do you have something? - ask quality questions. Something like: If this functionality was on it's own - how would it stand in the marketplace… (fail, survive, thrive) *** and why would it (fail,survive,thrive) etc… Then - as a company - ask yourself - would you want to run your IT on a bunch of things that work together - but individually are at a level of xxx? If so - march along - if not -- try something else. I personally prefer Best of Breed (BB) - vs Best of Suite (BS)… BS typically requires you to upgrade everything - to get something… (Say an improvement to your SRM functionality - you need to upgrade the world to the next version -- pretty risky/costly to improve 1/10 of the system) [OK - the most important part of the system :) ] And unfortunately - when you upgrade - you find that all kinds of other things were improved too -- to the Best Practices (etc..) - however you ask yourself - Who's best practices - cause they are not good for us… (Then you question yourself as a company - maybe we are a bunch of fools doing last years best practices, etc… (then you renew your subscription to People magazine - so you can be better informed on the latest trends)) Vs - BB. Best of Breed requires connecting stuff up front (however - BB stuff is designed for connections as it always in only part of the solution). Once connected - you are in much better control of your outcome. When it comes to your neck on the line -- do you want a collection of leaders - or a collection of rfp checkoffs? Oh - another thing -- with BB - keep in mind that every 3-5 years - you will have a 6-9 month hold. Why? - from what I see - it seems that companies do major upgrades every 3-5 years of BS - which throws the whole IT world into turmoil… I personally do not think that the effort put in - is worth the outcome… It is such pain - that the org questions itself and spends 6-9 months on tool discussions. With a BB - you can still question tools - but you are questing 1/10 of it at a time… and being surgical vs blunt force… Reminds me of the medical world - if somebody has a sore toe - you don't give them a new leg. But in IT - you do :) OK - enough - Have fun storming the castle (I mean - implementing OOB SSO). -John On Wed, Jun 13, 2012 at 5:05 AM, John Baker jba...@javasystemsolutions.comwrote: Guillaume With all the money and resources that BMC spent on DDM,they could have just paid Misi from RRR to make RRR|Chive prettier, i.e. essentially having a GUI and colorful reports so management **thinks** it's enterprise ready. Our customers have told us, and BMC, the same reference AtriumSSO. And I think there's an important point here - one I made to the poor BMC person who's coming to RUG and receiving a dressing down over support. If you try to be good at everything, you'll almost certainly fail. Stick to the core business and do it well. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ 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: Configuring a Solaris 10 server to run as an Escalation server – Pointers Needed
You could probably add some version of $SERVER$ = hostname into your escalation qualifications - therefore pinning the escalation to run on the named server. -John -John On Wed, Jun 13, 2012 at 7:26 AM, Ron Tavares ron.tava...@gmail.com wrote: ** Good Morning Listers, *The Problem:* We have lots of escalation traffic running on our system, which causes our current Windows Escalation server to be over-taxed. To the best of my knowledge, there is no way to run escalations on more than one server at any given time. *Solution Attempted:* So, we are in the process of standing up and configuring a new AR server on Solaris 10, hoping that this will have more horsepower to handle the large traffic. But we are having some issues. First off, we are not seeing the increase in processing time that we had hoped for. We are also seeing various errors show up whenever escalations fire workflow that touches the CTM:People form. It’s important to note that these do not show in the arerror.log, but rather they appear in the Putty session that was used to start the AR Server process. Examples of errors are as follows: Error signaling server server name Message number : 91 Message : RPC call failed Appended : RPC: Unable to receive; An event requires attention Status Struct : Message type : ERROR Error signaling server server name Status List : 1 items in thread Status List : 1 items Message number : 90 main Message : Cannot establish a network connection to the AR System server Appended : server name: RPC: Success Message : RPC call failed java.lang.NoClassDefFoundError: http://localhost:8080/rkm/fromRemedy/jsp?reset=remedyUsers Message type : ERROR There are other issues as well, such as the ARDBC Plugin appearing to load repeatedly every 10 minutes or so, after the AR Server starts. We have tried increasing and decreasing the List and Fast threads. The Escalations that we are testing are running on dedicated pools, and we have added the necessary threads to support those pools. The server does not show that it is being maxed out on memory or CPUs. *Bottom Line: * I think we just do not have this Solaris box configured correctly for Remedy. Perhaps we are approaching this with a “Windows” mentality and missing some key steps. So, my question is; is there anyone out there that is knowledgeable in configuring AR Servers on Solaris, and/or has seen these issues before. I could really use some pointers here as I am trying to guide the customer in the right direction, with my limited experience/knowledge in UNIX environments. *Here are our specs:* ARS 7.1 p11 ITSM 7.0 DB Oracle10 running on Solaris 10 All AR Servers are running on Windows Server 2003, (with the exception of the new Escalation server which is running on Solaris 10) We have a dedicated AR Server for Administrator functions and a dedicated server for Escalations. Thanking all you Solaris Gurus in Advance, Ron _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
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: AIE Re-Install
this line is making me think that the installer you're using is an older SP than the version you currently have installed. (Jun 11 2012 04:35:04.057 PM -0500),INFO,com.bmc.install.product.atriumfoundation.task.AtriumFoundationDownGradeDetectionValidationTask, LOG EVENT {Description=[Validation error],Detail=[BMC Atrium CMDB 7.6.04.01 featureDSL 7.6.04.01 Atrium Impact Simulator Engine 7.6.04.01]} i believe there is an AIE only download on BMC's site. that would be worth a shot. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Fwd:AIE Re-Install
to me that sounds pretty self-explanitory. it looks like you're trying to use the 7.6.04 SP0 installer over top of a 7.6.04 SP1 installation ___ 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
multi-tenancy SLA
Hi All, I have a multi-tenancy environment and currently the SLA does not get attached when a ticket is transferred from one tenancy to the other. The requirement is basic: Attach SLA. Any feedback would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
mutiple addresses for one user account
Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
Sorry: ARS 7.5, patch 007 Solaris David D. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 12:15 PM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia __ _ 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: mutiple addresses for one user account
We do this an have had no issues.. except my favorite typos or : or something dumb. Can't fix stupid. On Wed, Jun 13, 2012 at 12:16 PM, David Durling durl...@uga.edu wrote: Sorry: ARS 7.5, patch 007 Solaris David D. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 12:15 PM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia __ _ 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 -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
It will work, use semi-colon, else the email engine may reject it unless you have it config'd to recognize commas. If you have an integration in place to update people records it could get overwritten. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:16 AM To: arslist@arslist.org Subject: Re: mutiple addresses for one user account Sorry: ARS 7.5, patch 007 Solaris David D. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 12:15 PM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia __ _ 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 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
There was a bug with the Notify processes within the AR System. I think it's still in 7.6.04. You can have a large character filed for the To: on your form. The To: field on the AR System Email messages form is also large character field. However a bug in the Notification workflow trims the data to 256 characters. So if your combined email addresses in the To:, CC: or BCC: are longer than 256 characters, they will get trimmed to 256 characters when they hit the AR System Email Messages form. The work around is to push directly to the AR System Email Messages form. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, June 13, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ 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: mutiple addresses for one user account
Thanks for the caution - this is actually just 2 mailing list addresses, so managing addresses shouldn't be a problem in this instance. (If I don't use the same message to mail the lists, people signed up for both lists will receive 2 messages.) David -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, June 13, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. __ _ 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: mutiple addresses for one user account
Thanks, good to know that in case it comes up. David D. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, June 13, 2012 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account There was a bug with the Notify processes within the AR System. I think it's still in 7.6.04. You can have a large character filed for the To: on your form. The To: field on the AR System Email messages form is also large character field. However a bug in the Notification workflow trims the data to 256 characters. So if your combined email addresses in the To:, CC: or BCC: are longer than 256 characters, they will get trimmed to 256 characters when they hit the AR System Email Messages form. The work around is to push directly to the AR System Email Messages form. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, June 13, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. __ _ 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
7.6.04 Exporting reports for import into another server
Hello Listers; We have a production environment with multiple ARS and Web reports that have been created over time by a variety of admins and users. We want to put those reports on a Development environment for refinement and ultimately move them back into Production and to a DR server. When I export entries from the Production form: Report, the attachments names change. When I import them to the DEV server using the Import Tool, some of them fail to import and those that do import fail to run, showing an error that the definition is not available. The attachments appear in the record however, many of the imported definitions have a zero byte count when using either ARX or XML formats. I've also tried to export the records from the forms: ReportCreate and Report Definition. Importing those is also unsuccessful. I've read all the (too many) manuals and they are just not intuitive for this process. Does anyone have a step-by-step method for exporting and importing reports? Thanks; R Ray Palla Sr. IT/Remedy Consultant http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg Mobile: 512-917-1739 Time Zone: Central Email: ray.pa...@insona.com http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif Professional http://www.linkedin.com/pub/1/544/598 Profile http://www.insona.com/ INSONA Corporation 1201 Berry Lane http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX +77074%2CUSAhl=en Georgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are bg_bluefade_195x42.jpgINSONA-Logo.jpgicon_in_blue_14x14.gif
Re: Migration from Solaris/Oracle to Windows/MSSQL
For the data move there is also Meta-Update. It isn't as free as RRR|Chive but very flexible. If you are moving like for like ITSM version (you didn't mention the versions or if it is even ITSM) then RRR|Chive will do the trick. If you need to massage data, relationships, CMDB classes, roles and permission groups when going from an older version of ITSM to a newer one the Meta-Update maybe worth it. http://www.softwaretoolhouse.com/product/SthMupd/index.html No matter what using a tool that goes through the Remedy api is the way to go. If you did a the conversion at the db level that conversion will always be held in question if problems arise down the road (aka that method is not supported by BMC). Jason On Wed, Jun 13, 2012 at 6:51 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Do a fresh install, import the definitions (maybe using Migrator). But use RRR|Chive instead to move the data. It is faster and more robust in this regard, and is designed to handle a high volume of records. Documentation, no login required: https://www.rrr.se/c/doc/rrrchive/?arslist Download and configuration: https://www.rrr.se/cgi/rrrchive/main?arslist Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, We're currently in the process of moving a Solaris/Oracle (11g) based system to a Windows/MSSQL (2012) environment. While using Migrator should absolutely work, the fastest way would be to just import the Oracle DB into the new MSSQL DB and we'd prefer that. The problem here is, that there are two providers in MSSQL to import data from Oracle databases and both don't manage to import all data completely and correctly. The .net Framework Data Provider for Oracle doesn't copy views, but manages to import all data, but the views would be required for the AR server to function correctly. The Microsoft OLE DB Provider for Oracle does copy views as well, but doesn't set the correct data types when creating tables and thus fails to import data after some time. The question is: has anyone performed a migration from Oracle to MSSQL by just importing the database to the MSSQL server? Or should we just stick with the Migrator for this matter? Regards Jan Hartung ___ 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: mutiple addresses for one user account
Actually that depends on how you are sending the messages. Since he is on Solaris, if he is using normal Unix methods of sending emails then he will want to use a comma as the separator (since that is the separator as defined by Unix sendmail type processes) and make sure the com.bmc.arsys.emaildaemon.CommaValidAddressSeparator=true is set -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Goodall, Andrew C Sent: Wednesday, June 13, 2012 11:30 AM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account It will work, use semi-colon, else the email engine may reject it unless you have it config'd to recognize commas. If you have an integration in place to update people records it could get overwritten. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:16 AM To: arslist@arslist.org Subject: Re: mutiple addresses for one user account Sorry: ARS 7.5, patch 007 Solaris David D. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 12:15 PM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
Are you kidding? That was a bug back in 6.3. BMC still has not fixed it? I thought it had been fixed so I am glad this came up as part of the discussion. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, June 13, 2012 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account There was a bug with the Notify processes within the AR System. I think it's still in 7.6.04. You can have a large character filed for the To: on your form. The To: field on the AR System Email messages form is also large character field. However a bug in the Notification workflow trims the data to 256 characters. So if your combined email addresses in the To:, CC: or BCC: are longer than 256 characters, they will get trimmed to 256 characters when they hit the AR System Email Messages form. The work around is to push directly to the AR System Email Messages form. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, June 13, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ 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 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: mutiple addresses for one user account
Yes I think it was 6.3 that we stumbled on it. We keep hoping and checking the release notes. Haven't seen any reference to it being changed. As we get ready to upgrade to a new version it's something we test to see if we can go back to the Notify workflow. Still seems to be there. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Wednesday, June 13, 2012 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account Are you kidding? That was a bug back in 6.3. BMC still has not fixed it? I thought it had been fixed so I am glad this came up as part of the discussion. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, June 13, 2012 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account There was a bug with the Notify processes within the AR System. I think it's still in 7.6.04. You can have a large character filed for the To: on your form. The To: field on the AR System Email messages form is also large character field. However a bug in the Notification workflow trims the data to 256 characters. So if your combined email addresses in the To:, CC: or BCC: are longer than 256 characters, they will get trimmed to 256 characters when they hit the AR System Email Messages form. The work around is to push directly to the AR System Email Messages form. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, June 13, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: mutiple addresses for one user account In these situations we use email distribution lists maintained in Exchange instead of having them listed anywhere in Remedy. I don't see why it wouldn't work, since the email engine is just passing onto SMTP or whatever and properly formatted lists of email addresses should work. I would just caution you that you may not want to be responsible for maintaining those lists in Remedy rather than Exchange. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, June 13, 2012 11:15 AM To: arslist@ARSLIST.ORG Subject: mutiple addresses for one user account Do any of you rely on the Email field on the User record allowing you to list multiple addresses? address1@fakeaddress, address2@fakeaddress (or maybe other separator like ;) I don't see a mention of it in the docs, but it seems to work on test. I don't want to reply on it if it's not an expected behavior, though. The reason: I need for a particular notice to some addresses to be sent as one email, not separate ones for each user. David Durling Enterprise IT Services University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ 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 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ 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: 7.6.04 Exporting reports for import into another server
Ray - Simple method when you're not talking about 100s or more...open Report Console, search for all. Highlight the record, then drop down to the attachment field, right click, Save as x. Do the reverse in DEV. Create new, right click and add the report you save earlier. Sent via BlackBerry by ATT -Original Message- From: Ray Palla ray.pa...@insona.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Wed, 13 Jun 2012 12:16:58 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: 7.6.04 Exporting reports for import into another server Hello Listers; We have a production environment with multiple ARS and Web reports that have been created over time by a variety of admins and users. We want to put those reports on a Development environment for refinement and ultimately move them back into Production and to a DR server. When I export entries from the Production form: Report, the attachments names change. When I import them to the DEV server using the Import Tool, some of them fail to import and those that do import fail to run, showing an error that the definition is not available. The attachments appear in the record however, many of the imported definitions have a zero byte count when using either ARX or XML formats. I've also tried to export the records from the forms: ReportCreate and Report Definition. Importing those is also unsuccessful. I've read all the (too many) manuals and they are just not intuitive for this process. Does anyone have a step-by-step method for exporting and importing reports? Thanks; R Ray Palla Sr. IT/Remedy Consultant http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg Mobile: 512-917-1739 Time Zone: Central Email: ray.pa...@insona.com http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif Professional http://www.linkedin.com/pub/1/544/598 Profile http://www.insona.com/ INSONA Corporation 1201 Berry Lane http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX +77074%2CUSAhl=en Georgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications ___ 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 bg_bluefade_195x42.jpgINSONA-Logo.jpgicon_in_blue_14x14.gif
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_