That is exactly why we pushed back on them because it’s not what we would normally be told. I think the SQL just changes the owner name of the objects so it shouldn’t harm anything, but I also don’t understand why the 8.1.2 installer would have potentially changed them in the first place.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, December 12, 2014 8:32 AM To: [email protected] Subject: Re: Deleting Overlays - Nightmare ** Well that's certainly interesting...I've never heard BMC recommend doing ANYTHING directly at the DB via SQL. On Fri, Dec 12, 2014 at 7:28 AM, Pierson, Shawn <[email protected]<mailto:[email protected]>> wrote: ** We recently ran into an issue on 8.1 where BMC told my colleague that using the Class Manager is no longer the recommended way to modify the underlying forms, in our specific case it was to add a few new Status Reason values to Base Element. Additionally, with 8.1.2 our views were corrupted somehow on at least Base Element, where we’ve been instructed to directly update the views manually via SQL. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of LJ LongWing Sent: Friday, December 12, 2014 8:05 AM To: [email protected]<mailto:[email protected]> Subject: Re: Deleting Overlays - Nightmare ** Aditya, Yes, Misi is 100% correct. When adding attributes to CMDB you are supposed to do it through the class manager, which manages all of the forms and joins and such. Overlays are not supported and will need to be deleted...which means you will loose your custom attributes, but you'll want to take a backup and restore them after the upgrade and the attributes are added in 'properly' On Fri, Dec 12, 2014 at 5:30 AM, Aditya Shrivastava <[email protected]<mailto:[email protected]>> wrote: ** Hi Claire and Terry, While upgrading Atrium Core from 7.6.04 to 8.1.01, even I am getting this error on installer that (X) Following forms have overlays created. Atrium install needs this overlay to be deleted. Please delete the overlay for following forms before proceeding with upgrade: BMC.CORE:BMC_BaseElement BMC.CORE:BMC_BaseElement:AUDIT BMC.CORE:BMC_ComputerSystem BMC.CORE:BMC_Equipment We do have custom attributes for some of the classes including those mentioned above but I believe this should be preserved. Please suggest how to correct this error? Also, we plan to upgrade ITSM after this. Should I be prepared to see such errors there as well? Please suggest how to take it forward. Regards, Aditya On Tue, Oct 28, 2014 at 4:06 AM, Terry Bootsma <[email protected]<mailto:[email protected]>> wrote: ** Claire: The fact that your prod db was changed when you deleted your overlays in Dev Studio when connecting to RemTST tells me that maybe you didn't update your database connection from your RemTST VM to point to the test database? I know it is pretty obvious, but that is the only reason I could think it would happen. But, why you should have to delete your overlays is confusing (unless your overlays were corrupt ? ) . That's the whole purpose of overlays. Terry ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Sanford, Claire Sent: October-27-14 6:06 PM To: [email protected]<mailto:[email protected]> Subject: Deleting Overlays - Nightmare ** I’m trying to do an “upgrade” on a new VM server. Did ARS 7.6.04 PS3 to ARS 8.01.03. Just a few hiccups. Going from Atrium Core 7.6.04 SP3 to SP5 has been the nightmare. Once that is done then I’ll be doing the rest of the ITSM stuff which is heavily overlayed! I have had the DBA copy the Prod DB to a new space RemTST and the installer for the CMDB told me to delete the Overlays for some of the “BMC.CORE:” forms. When I did this using Dev Studio (after confirming with the support dude), the tables went from “Overlayed” to “Unmodified”. On RemTST. It also happened on RemProd. The Production Database. I was not even logged into the Prod server in Dev Studio. All those forms now show Unmodified instead of Overlayed. Because the fields were entered using the class manager, my fields should still be there. There is a backup from this morning for RemProd. The DBA looked at the database on the Oracle level and said that the table ID numbers I gave him are there. They do not show up when I look at the DB via ArUtilities. Any Ideas? I have not had to delete an overlay since going into production and am concerned about the ramifications. All I have gotten from BMC support for all of my questions regarding this upgrade have been copies of KB articles instead of just a yes/no answer to my direct questions. Once Again! Overlays do not make patching and upgrading easier! Claire _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
