I am not an expert with the BO but recently had to self learn while trying to deploy BMC Analytics solution. I am assuming you are using BO with BMC Analytics. When BO is installed it has two options a) Installer installs a small MySQL dirby database within the BO installation to store BO related meta data. b) Use a different data base that is managed separately like if you have defined your own database to use with BO.
Incase if you have used option 1, the production refresh should not impact BO at all because all the meta data is stored locally on the BO server. If you used option 2, the production refresh to dev should not impact BO if you only copied ARAdmin schema. But if your DBA moved the BO schema also from prod to dev then it makes sense that your dev BO is now pointing to prod remedy. What you can do is, launch your dev BO Designer tool and reimport the ITSM universe and just change the connection parameters and specify the dev oracle connection parameters.. That way all your dev BO reports will now get the data from your dev remedy database. On Wednesday, June 20, 2012 12:43:20 PM UTC-7, Peters, Ron wrote: > > ** > > Hi all, > > > > I’m working through a developing a process for refreshing our dev/qa > environments with production data. We dumped the data from production into > dev and I’ve done a lot of cleanup and re-pointing so Remedy/ITSM is > working correctly. That part seems to be fine. > > > > The issue I’m having is that our BO reporting server seems to now be > pointing to production. I logged into CMC as administrator yesterday and > there was nothing in the environment. No reports, users, groups (other than > defaults), as well as our license string. I restarted BO and Tomcat today > because I again couldn’t log in and now when I log in, I see production > reports that successfully ran this morning. > > > > First of all, I wasn’t expecting our BO environment to be affected by the > data refresh. In any case, we had this implemented by a contractor and I’m > not fully clear how BO connects to the database and where those settings > are kept. Any thoughts as to where I might look? > > > > Thanks in advance, > > Ron > _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"
