Thanks for all the suggestions. Object Owner: As for the object owner, from what little I know about databases, it seems that it is in the form of [owner].[object]. In our case the owner on all the objects is 'dbo' which from some quick google surfing is the default when a DB is created. I'm not sure this is going to help.
BO Designer: When opening designer on our BO system, it asks for user credentials on a specific system. I have 3 systems in the pulldown: devsystemname, qasystemname, and prodsystemname. I choose our Dev system and log in. Once in, in the title bar of the application, it says: Universe Designer - [Administrator - @prodsystemname:6400]. When I log into the prod environment, it displays the same thing (prodsystemname). When choosing 'Import', there are no available universes. When I try to open a saved copy of the dev universe to re-export, it says I'm not authorized since that universe belongs to a different CMS. I know where the connections are in the universe, that is if I could import it. I believe it's correct in saying I share a DB between AR and BO. I'll likely have to back out but are there any more thoughts on moving forward so I only get the proper elements? Ideally I'd change a pointer somewhere and be back in business. From my experience with this product suite, I'm sure it won't be that simple. Thanks again, Ron From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, June 20, 2012 2:07 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy DB refresh and Business Objects ** It looks like you are using a Microsoft database (I use Oracle). Schema in Oracle terms usually means Owner in MS terms. Look at who owns the objects (tables/views/...) in the database. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Wednesday, June 20, 2012 3:12 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy DB refresh and Business Objects ** 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@01CD4EF2.24F41300] -----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 _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"
<<inline: image001.png>>
