Did you ever get an answer back from BMC on the SLMConfDSServerName field data in the SLM:ConfigDataSource form? I noticed that the act of recreating the filters on a different server does not change the value in this table, but the filters still use the local server reference for the new server.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Mary Ann > Sent: Tuesday, February 24, 2009 1:43 PM > To: arslist@ARSLIST.ORG > Subject: Server Name references - export/import ARSystem DB - ITSM 7 > > We have been struggling with the list of server name references that > need to be changed when exporting/importing an ARSystem DB from one > server to another server. > > Last week we found that one of the imbedded server references has been > causing Apache on our Mid-Tier server to crash because we had a server > reference for the CI Viewer to the original server. > > Our versions installed: > ARS 7.0.01/Patch 7 > CMDB 2.0.1/Patch 3 > ITSM IM/PM/AM/Change 7.0.02/Patch 5 > SLM 7.0.03/No Patch > RKM 7.2/Patch 1 > SQL Server 2005/SP2 > > I looked at past postings on this list and have been using that list to > update server references up to now. Based on our crashes I looked for > and found a SQL Server procedure on the internet to search for text > (old > server references) in columns in tables. > > These are the server references that we will NOW update when we move > the > > ARSystem database from one server to another server: > > FORM DATA: > - KMS:Adminstration_Integration - Server Name > - SHARE:Application_Properties - help file paths > - SYS:Attachments - survey path > - Report - Server field > - CAI:Application Registry - Server field > - BMC.CORE:CONFIG:BMC_FederatedInterface - ARServerName field [this was > the one causing the MidTier apache crash] > - AR System Searches - Server field > - CAI:EventParams - FromServer field > - CAI:Events - SourceServer, TargetServer fields > - SLM:ConfigDataSource - SLMConfDSServerName field - hidden in GUI > [have > > not changed this yet due to possibly having to rebuild all service > targets > connected to this data source, waiting for a response from BMC Support] > - SRM:AppInstanceBridge - AppInstanceServer field > > WORKFLOW: > - Active Link: CHG:CCMCalendar:PrintActionWUT - Action 1 path > > I asked BMC Support to confirm this list and they said "we currently do > not have a doc that contains this information, as migrating the > database > > is not a supported process. R&D is developing a document that will > define > how this should be done and once this document is published, we will > begin > supporting a DB migration like the one you describe. Unfortunately, > there > is currently no ETA on this document." The good news is that they are > working on this document and hopefully we will see one soon, so I will > feel more comfortable that we have caught everything. > > I hope this list helps others who have been struggling with this. > > Thanks. > > Mary Ann > > _______________________________________________________________________ > ________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
