Re: Remedy DB refresh and Business Objects
The BO related metadata is stored in the DB under the BOAdmin schema, Remedy data is under ARAdmin. I'm not sure of the steps to get you back pointing to your dev environment. We did something similar and wound up having to pull a contractor back in (the one who set everything up) to clean it back up. I believe you have to repoint all the universe connections and report connections in CMC but I know there were a number of steps he had to go through. Nate. 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.comhttp://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
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
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@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
Re: Remedy DB refresh and Business Objects
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 this via the BO designer. Open the universe in designer and if my memory serves me right, go to Tools -- Connection and you should be able to re-point to the correct ARS DB from there. Hope this helps! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy DB refresh and Business Objects
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
Re: Remedy DB refresh and Business Objects
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. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Wed, Jun 20, 2012 at 10:33 PM, patchsk vamsi...@gmail.com wrote: ** 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_ _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 image003.jpgimage004.jpgimage001.jpgimage002.jpg
Re: Remedy DB refresh and Business Objects
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