Re: DSO with Different Data Type
Hi, Yes DSO custom mapping supports different data types for source and destination fields. If source and destination data types are different, DSO converts the field value from source data type to destination data type. Thanks, Rajendra On Tue, Jan 5, 2010 at 10:41 PM, tina flores csoukn...@columnit.com wrote: Hi Listers, Can anyone confirm if using DSO (Custom Mapping), you can push fields to different data type (source: date type field and destination: date/time type field) without any issues? Thanks, Tina -- View this message in context: http://old.nabble.com/DSO-with-Different-Data-Type-tp27026663p27026663.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
MidTier Logs
I have the error in our Midtier Log: Dec 28, 2009 8:05:12 AM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: ARERR [9264] User has no access permission to the form Contract Signature Dialog Box. How do I know who is creating this error? Why doesn't it log the users login id Right now our log level is Warning and the Log Format is Simple Text. Is there something else I need to set to gather this info? It's able to gather the login if for this error: Dec 28, 2009 7:28:15 AM - WARNING (com.remedy.log.SESSION) : DataCache: System form not defined for UserActorsUS046590 Global Miditer 7.5 p2 ARS 7.1 p7 Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: MidTier Logs
I'm not sure on the 7.5 MidTier, but on 7.1 you want to use the Detailed Text log format. With Detailed Text you get the (Thread ###) so you can trace all information for a session. The Login info is on a separate line. Jan 4, 2010 5:18:23 AM - FINE (com.remedy.log.PERFORMANCE) : (Thread 15) com.remedy.arsys.ws.services.ARService processRequest WS Total time = 34 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, January 06, 2010 8:56 AM To: arslist@ARSLIST.ORG Subject: MidTier Logs ** I have the error in our Midtier Log: Dec 28, 2009 8:05:12 AM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: ARERR [9264] User has no access permission to the form Contract Signature Dialog Box. How do I know who is creating this error? Why doesn't it log the users login id Right now our log level is Warning and the Log Format is Simple Text. Is there something else I need to set to gather this info? It's able to gather the login if for this error: Dec 28, 2009 7:28:15 AM - WARNING (com.remedy.log.SESSION) : DataCache: System form not defined for UserActorsUS046590 Global Miditer 7.5 p2 ARS 7.1 p7 Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
HD5.5 to HD5.6 upgrade
Listers, I would like to upgrade HD5.5 to HD5.6. I downloaded the Solaris version of HD5.6 from the BMC site the documentation says there is an upgrade script but it's not in the BMC HD5.6 download. I opened a service request with BMC in the hopes they could find the upgrade script but was told it's no longer available. Does anyone on the list have the Solaris version of HD5.6 that contains the upgrade script and if so would you be willing to send it to me? Thanks, Mark Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ARServer Status monitor
Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: HD5.5 to HD5.6 upgrade
Mark,, hey any thoughts on upgrading to 7.6? I mean, since you are already paying BMC support for the HD, why not use the latest version? Much more value in 7.6 than 5.6 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Mark Wilson [mwil...@pcc.edu] Sent: Wednesday, January 06, 2010 12:19 PM To: arslist@ARSLIST.ORG Subject: HD5.5 to HD5.6 upgrade Listers, I would like to upgrade HD5.5 to HD5.6. I downloaded the Solaris version of HD5.6 from the BMC site the documentation says there is an upgrade script but it's not in the BMC HD5.6 download. I opened a service request with BMC in the hopes they could find the upgrade script but was told it's no longer available. Does anyone on the list have the Solaris version of HD5.6 that contains the upgrade script and if so would you be willing to send it to me? Thanks, Mark Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Runmacro issue
I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Juega y gana con Samsung y Windows Live http://www.equipatucasa.com.mx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: HD5.5 to HD5.6 upgrade
Hi Guillaume, Yes we have talked about upgrading to the current version and, well it's been a long discussion. Our plan as of now is to upgrade to ARS7.5 and install HD5.6 on top of that. At this point in time that should work well for us. Maybe next year we can look at going with the full blown Atrium CMDB package. It's been a tough decision for us. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Wednesday, January 06, 2010 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: HD5.5 to HD5.6 upgrade Mark,, hey any thoughts on upgrading to 7.6? I mean, since you are already paying BMC support for the HD, why not use the latest version? Much more value in 7.6 than 5.6 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Mark Wilson [mwil...@pcc.edu] Sent: Wednesday, January 06, 2010 12:19 PM To: arslist@ARSLIST.ORG Subject: HD5.5 to HD5.6 upgrade Listers, I would like to upgrade HD5.5 to HD5.6. I downloaded the Solaris version of HD5.6 from the BMC site the documentation says there is an upgrade script but it's not in the BMC HD5.6 download. I opened a service request with BMC in the hopes they could find the upgrade script but was told it's no longer available. Does anyone on the list have the Solaris version of HD5.6 that contains the upgrade script and if so would you be willing to send it to me? Thanks, Mark Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.comwrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I’d like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don’t like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: HD5.5 to HD5.6 upgrade
Hi Mark, What version of ARS are you currently running? HD 5.6 still uses the RAPP service, correct? I have my doubts that the RAPP service will work with ARS 7.5. You may or may not need the RAPP service but it is something to consider. Jason On Wed, Jan 6, 2010 at 12:01 PM, Mark Wilson mwil...@pcc.edu wrote: Hi Guillaume, Yes we have talked about upgrading to the current version and, well it's been a long discussion. Our plan as of now is to upgrade to ARS7.5 and install HD5.6 on top of that. At this point in time that should work well for us. Maybe next year we can look at going with the full blown Atrium CMDB package. It's been a tough decision for us. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Wednesday, January 06, 2010 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: HD5.5 to HD5.6 upgrade Mark,, hey any thoughts on upgrading to 7.6? I mean, since you are already paying BMC support for the HD, why not use the latest version? Much more value in 7.6 than 5.6 Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Mark Wilson [mwil...@pcc.edu] Sent: Wednesday, January 06, 2010 12:19 PM To: arslist@ARSLIST.ORG Subject: HD5.5 to HD5.6 upgrade Listers, I would like to upgrade HD5.5 to HD5.6. I downloaded the Solaris version of HD5.6 from the BMC site the documentation says there is an upgrade script but it's not in the BMC HD5.6 download. I opened a service request with BMC in the hopes they could find the upgrade script but was told it's no longer available. Does anyone on the list have the Solaris version of HD5.6 that contains the upgrade script and if so would you be willing to send it to me? Thanks, Mark Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net sponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net sponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: HD5.5 to HD5.6 upgrade
I tend to agree. I recently performed an ARS upgrade for a customer on HD 5.6. We stopped at ARS 7.1 for that reason. I don't KNOW that they won't work together, but I wasn't interested in finding out the hard way. Also check to see if any plugins you are using will port over. I believe the authentication API changed from ARS 5 to 7 - take that into account as well. We had some minor issues with the Email forms, too. Rick On Wed, Jan 6, 2010 at 12:58 PM, Jason Miller jason.mil...@gmail.comwrote: ** Hi Mark, What version of ARS are you currently running? HD 5.6 still uses the RAPP service, correct? I have my doubts that the RAPP service will work with ARS 7.5. You may or may not need the RAPP service but it is something to consider. Jason On Wed, Jan 6, 2010 at 12:01 PM, Mark Wilson mwil...@pcc.edu wrote: Hi Guillaume, Yes we have talked about upgrading to the current version and, well it's been a long discussion. Our plan as of now is to upgrade to ARS7.5 and install HD5.6 on top of that. At this point in time that should work well for us. Maybe next year we can look at going with the full blown Atrium CMDB package. It's been a tough decision for us. Mark -Original Message- From: Action Request System discussion list(ARSList) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
CMDB 2.0 Class
Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Is the ARSystem Portmapper service actually stopped or just not responding? I have used a nice utility called Servers Alive to do Windows server (and Service) monitoring. http://www.woodstone.nu/salive/index.asp Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Wednesday, January 06, 2010 12:10 PM To: arslist@ARSLIST.ORG Subject: ARServer Status monitor Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database ARSystem requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (servername removed) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.commailto:john.j.rei...@lmco.com wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Alternately you could even use the Services Manager on the server to restart the service on consecutive failures.. There are option for that on the service properties configuration. If that is not ideal a batch job can also be written to restart a service periodically using the net stop service name in double quotes followed by a net start service name Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Grooms, Frederick W Sent: Wednesday, January 06, 2010 4:33 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor Is the ARSystem Portmapper service actually stopped or just not responding? I have used a nice utility called Servers Alive to do Windows server (and Service) monitoring. http://www.woodstone.nu/salive/index.asp Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Wednesday, January 06, 2010 12:10 PM To: arslist@ARSLIST.ORG Subject: ARServer Status monitor Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 2.0 Class
I made all servers (including DB servers) part of BMC_ComputerSystem My databases are under BMC_Database Yes, BMC recommends using BMC_SoftwareServer for database servers. Not sure the logic here.. I imported my assets to the BMC.CORE:BMC_ forms (join). This join form will join the BMC_BaseElement form w/ the correct form. I did NOT use AST: forms. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Wednesday, January 06, 2010 3:18 PM To: arslist@ARSLIST.ORG Subject: CMDB 2.0 Class ** Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 2.0 Class
The database server and that database are not the same thing, as a database server can potentially host multiple databases. The database server is indeed a software server, but the database instance itself is a separate logical entity that is managed/used/controlled by the database server. I model them using the Database class and relate that to the software server that hosts the database. For example, you could have a SQL Server represented by a SoftwareServer class, and then every separate database instance hosted by that SQL Server (the database software, not the machine) would be an instance of the Database class related back to that SoftwareServer (e.g., a Dependency). You could potentially also use the DatabaseStorage class which represents the physical storage used by the database, but unless you actually care about modeling and tracking the storage for the database separately, you're probably better off just using Database. Having said all that, what you use will depend on the level of detail that you are trying to capture. If all you want to say is that Application X depends on Database Y, but you don't care about whether it's Oracle, SQL Server, etc., then you probably could just use the Database class and not worry about the Software Server class. If you want to track your database server software and keep track of what databases are hosted by which servers, then you will want to use both classes. If you're storage is stored on SANs or the like, then you may also want to use the DatabaseStorage class so that you can store more information about your database's storage allocation, etc. and easily relate it to things like the actual disk array the storage is on, etc. Does that make any more sense? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Wednesday, January 06, 2010 2:18 PM To: arslist@ARSLIST.ORG Subject: CMDB 2.0 Class ** Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 2.0 Class
We have a habit of calling the machine a database server, because that's its primary purpose. However, the machine is just a computer system that runs a software server that hosts a database. If you keep that distinction in mind, then BMC's recommendation makes a lot of sense. The actual physical machine is a ComputerSystem. The running database software (SQL Server, Oracle, etc.) is a SoftwareServer. Each database instance hosted by a particular software server is a Database. The way you decide to model it really depends on how you view it and what level of detail you want to track. If each physical server only hosts a single instance of a database server, and you don't care about tracking the details about the database software (e.g., version, patch level, etc.), then it can be convenient to effectively put the two together and track both as simply a Computer System. However, if you have a single physical server that hosts multiple database servers, and you want to track that fact as well as additional information about those servers, then you need to separate things out into different classes. In that case, your class list would probably look more like what I outlined above. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Wednesday, January 06, 2010 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: CMDB 2.0 Class ** I made all servers (including DB servers) part of BMC_ComputerSystem My databases are under BMC_Database Yes, BMC recommends using BMC_SoftwareServer for database servers. Not sure the logic here.. I imported my assets to the BMC.CORE:BMC_ forms (join). This join form will join the BMC_BaseElement form w/ the correct form. I did NOT use AST: forms. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Wednesday, January 06, 2010 3:18 PM To: arslist@ARSLIST.ORG Subject: CMDB 2.0 Class ** Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
When you restarted portmapper it actually stopped and restarted the AR System Server service as well. I don't think it was portmapper that was the problem. It looks like your problem is that the AR Server is losing connection to the SQL Server. How about trying something like an Escalation that runs every x minutes and does a SQL query to the database. Something like: Select COUNT(*) from ARSCHEMA. This would make a call to the database and keep that connection alive. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Wednesday, January 06, 2010 3:43 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database ARSystem requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (servername removed) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.com wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Ah, I used to have a 7.1 servers that would do that. The app and db server were plugged into the same darn switch but they would lose connection. Fortunately it was short enough that ARS usually recovered with no issue. I am surprise that a restart of Portmapper would resolve the issue. Do you have DSO? You could check available by transferring records. If not you could create a web service that does a simple query against a small form on prod and then have an Escalation on dev that would call the web service. If there is an error you could have dev perform whatever action you wish. This would include the Mid-Tier as a point of failure but maybe you want to make sure that MT is responding at the same time? Another idea would be to call runmacro from an Escalation on the dev server to try export a small set of records from prod. You can then either parse the return for error messages or if no file was created assume that the server is down. Look at the sc (Service Control) command to start/stop remote services. HTH, Jason On Wed, Jan 6, 2010 at 1:42 PM, Reiser, John J john.j.rei...@lmco.comwrote: ** Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database ARSystem requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (servername removed) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Jason Miller *Sent:* Wednesday, January 06, 2010 3:54 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.com wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I’d like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don’t like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: HD5.5 to HD5.6 upgrade
I'm running ARS6.3 and HD5.5 on Solaris. I don't think HD5.6 runs the RAPP service I know HD5.5 doesn't. I actually have a test instance of ARS7.5 and HD5.6 running. I haven't tested extensively but email is working and basic ticket creation is working. Basically I'm looking for the HD5.5 to HD5.6 upgrade script so I don't have to manually bring my customizations into HD5.6. The HD5.6 documentation indicates that it should be there. I just thought someone on the list might have a copy of it. Mark _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: HD5.5 to HD5.6 upgrade ** Hi Mark, What version of ARS are you currently running? HD 5.6 still uses the RAPP service, correct? I have my doubts that the RAPP service will work with ARS 7.5. You may or may not need the RAPP service but it is something to consider. Jason On Wed, Jan 6, 2010 at 12:01 PM, Mark Wilson mwil...@pcc.edu wrote: Hi Guillaume, Yes we have talked about upgrading to the current version and, well it's been a long discussion. Our plan as of now is to upgrade to ARS7.5 and install HD5.6 on top of that. At this point in time that should work well for us. Maybe next year we can look at going with the full blown Atrium CMDB package. It's been a tough decision for us. Mark -Original Message- From: Action Request System discussion list(ARSList) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Issues in SLM 7.0.3
Dear ARSList, ARS Version : 7.1.00 Patch 006 SLM Version : 7.0.03 We are facing some issues in SLM 7.0.3, like to check any of you have any information\experienced this issues: 1) When the Incident is created in Pending state directly, the SLA status is moved to Pending state but after 15 min (15 is the Goal set for this SLA) the Status is getting changed to “Missed Goal” which causes the SLA to Missed though it’s in Pending state. The SLA is configured to Exclude Status = Pending. It Appears this issue is fixed in SLM 7.1 patch 002 . 2) This issue is related to the First one, the Milestones for the SLAs are also firing though the Status is Pending. This is happening even the Incident is created with any other state (New\Assigned) and then moved to Pending as well. I think we need to add the “Exclude if” condition in the Milestones also. Will that help ? 3) While calculating the Compliance for the Monthly review period, the Compliance is not considering the Incidents that are in Met state, its counting only the Missed records. In Development Server this is getting calculated correctly but not in production. But the Service target\SLA configuration is the same in both the servers. Appreciate your help and please let me know if you have any related information. THANKS ARSList!! Thanks, Viswa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are