I can revert to the snapshot (vmware) I took prior to the upgrade. We're working out the proper process and we apparently have it wrong.
I talked with the DBA who did the restore and he wasn't familiar with the "aradmin" schema. We looked at the DB and didn't see anything obvious. This screenshot is what we have and he restored the whole ARSystem database from prod to dev. How do we identify the proper subset/schema to restore? Thanks again. [cid:image001.png@01CD4EE6.39E55D70] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, June 20, 2012 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy DB refresh and Business Objects It sounds like you copied the entire database instead of just the "aradmin" schema. When copying data from production down to a non-prod database I always say to just do the aradmin data What DB are you using? Can you do a restore from before the copy of the non "aradmin" schema? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, June 20, 2012 2:43 PM To: arslist@ARSLIST.ORG Subject: Remedy DB refresh and Business Objects ** 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 _______________________________________________________________________________ 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"
<<inline: image001.png>>