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]> 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]] *On Behalf Of *LJ LongWing > *Sent:* Friday, December 12, 2014 8:05 AM > *To:* [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]> > 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]> > 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]] *On Behalf Of *Sanford, Claire > *Sent:* October-27-14 6:06 PM > *To:* [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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
