Remedy DB refresh and Business Objects

2012-06-20 Thread Peters, Ron
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

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Nathan Aker
, 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

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Grooms, Frederick W
-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

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Peters, Ron
@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

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Gangji R
You will need to repoint the BOXI universe (the ITSM universe) to your dev DB. That connectivity info is resident on the BOXI server and so even though you have successfully managed to port ARS between the two systems, the BOXI connection to the ARS DB has not been updated. You can re-point

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread patchsk
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

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Jose Huerta
Could you list all tables in ARSystem except those starting by t, h or b? I'm suspecting that you are using the same database for ARS and BO. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A.

Re: Remedy DB refresh and Business Objects

2012-06-20 Thread Peters, Ron
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