have you checked the AR system ranking forms to see that the correct servers are set in the ranking forms, especially if your servers are in a server group? Date: Thu, 1 Nov 2012 15:47:17 +0000 From: rpet...@columbia.com Subject: Re: WWRUG12 - Session Question - Database Moving To: arslist@ARSLIST.ORG
** I've had a couple requests for our procedure so I thought I'd add it here: We’re on AR 7.5 ITSM 7.6: On occasion we want to refresh the data within the non-production Remedy environments. This aligns all the data/configuration between environments. This is the process that we've developed. 1. Take a VMWare snapshot of the database server in the environment to be refreshed. Just in case. 2. Disable the Email Engine service 3. Disable the AR server service 4. Disable the Server Intelligence Agent in the Central Configuration Manager for Business Objects. Done on the RKM box. 5. Have a DBA backup the following 6 pre-refreshed tables (for Business Objects) for later restoration. § dbo.CMS_Aliases6 § dbo.CMS_IdNumbers6 § dbo.CMS_InfoObjects6 § dbo.CMS_LOCKS6 § dbo.CMS_RELATIONS6 § dbo.CMS_VersionInfo 6. Have a DBA Restore current production Remedy database onto the destination DB server. 7. Have a DBA restore the 6 backed up tables from above on top of the newly restored database. This keeps the Business Objects environment working as it was before. Both BO and Remedy use the same database and have their tables intermixed. 8. Start the Server Intelligence Agent in the Central Configuration Manager for Business Objects. Done on the RKM box. § Good to validate that BO is working correctly and reports the new data. 9. Start the AR server service 10. Log into the thick client for further modifications 11. Change the server in the records of the following forms: · AP:Rule Definition ( nothing changed for accounts payable – maybe revisit) · AR System Searches Preference (modified all records with new ar server) · AR System Server Group Operation Ranking (modified all records with new ar server) · AR System User Preference (Server = $NULL$) ( not changed) · BMC.CORE.CONFIG:BMC_FederatedDataInterface ( nothing to modify) · BMC.CORE.CONFIG:BMC_FederatedInterface (modified all records with new ar server) · CAI:AppRegistry (modified all records with new ar server) · EIE:CommonDialog (Help File Path) ( cant change host/internal instance) · KMS:Administration_Integration (modified all records with new ar server) · Report (modified all records with new ar server) · SRD:STAGE:MasterDataMappingList ( no records to modify) · SRM:ApplicationSettings (SRM Application Settings) ( no form) SHARE:Application_Properties (Help files web location to point to the correct Mid-Tier) ( modified all the appropriate entries – Help File Path) · SYS:Integration Management ( nothing to modify) 1. Remove any unsent mail from the Remedy mail queue 2. Remove all support group members. Don't want to confuse people. Seem to have to go back to the service desk group. May have something to do with fixed licenses. It'd be nice if you could remove more than one member at a time. 1. Remove all the distribution lists from support group notification configuration. 2. Update the email box configurations per the table below. Passwords can be found in 3. Possibly clean up the actual Exchange inbox if necessary (unlikely). This will only be the case if the environment has been down a while and can't catch up. 4. Update the license entries per the table below. 5. Change the email address of the 'remedy email' faceless account (People record) to be appropriate for the environment. § This address MUST match the address of the sender of the incoming mail (per mailbox configuration). If they don't match, the returned error will be “missing ar system user information” 6. Change the email address of the 'cab user” faceless account (People record) to be appropriate for the environment. 7. Remove the distribution list from the service desk support group. Probably redundant from above. 8. Update the pager configuration to have the appropriate 'sender' email address for the specific environment. 9. Start the email engine service 10. Send a message to the environment service desk email to validate default tickets are being created correctly. 11. Send a message to Procmail to validate those tickets are being created correctly. Clean up mail queue, remove all old production messages from the non-production environment. This will take quite a while and probably should be done overnight. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving My new management team had the Network Admin team copied the Prod Server as a whole to the Dev Server. They wanted the environments to be identical in every way. The problem is that they are not. I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. The DBA team copied the Database over and I think I have that all sorted out as well... I have fixed things in many places, but am sure there is something I am missing because the performance is terrible. They want to do this again and at WWRUG in of the sessions the speaker mentioned a list at the end of his presentation. I can't find the note where I wrote down which session it was and I THINK I have gone through every presentation on the thumb drive. So this is basically what management called "P to V" copying. Physical to Virtual. I will take any list anyone has at this time. I will compile it all into one list in combination with what I have already noted that I changed. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, October 31, 2012 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG12 - Session Question - Database Moving I wasn't there this year but to clarify your question, are you asking about copying the database server or database or something else and copying it to another server? We do something similar to refresh our non-prod environments with the production database. I came up with the process and it may not be exhaustive, but we haven't had any issues with it. Let me know if you're interested. Ron -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Wednesday, October 31, 2012 8:26 AM To: arslist@ARSLIST.ORG Subject: WWRUG12 - Session Question - Database Moving I have drawn a complete blank and in my 97 pages of notes (yes, I took notes in a notebook) from WWRUG12 I can't find what I am looking for. In one of the sessions there was some discussion regarding taking one server and copying it to another server. It is not recommended but whoever was doing the presentation said that he (I do remember it was a he) had the steps at the end of the presentation or would send them (not sure here) for the 7 or 8 things that MUST be modified to make the new server function properly. We did that here and while things look like they are working properly, we are getting a lot of DB timeouts and the performance is very slow. Does anyone know what presentation I am talking about? Does anyone have those specific steps? ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org _______________________________________________________________________________ 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" _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"
<<attachment: image001.png>>
