Hi,
You can compare an unmodified def of the form with your own def using
RRR|DefFieldDiff.
You will probably need to:
1. Export data to ARX (maybe using RRR|Chive)
2. Remove the attributes
3. Import the data again
You might also do some fancy stuff with archgid, changing dbname of the
attributes and add duplicate parallel field so that you do not need to
export/import the data but can copy it on the database layer later.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Misi & LJ,
>
> Thank you for valuable inputs.
> Being new to this Remedy environment I am not aware how these custom
> attributes were added. I believe they were not added via Class Manager (the
> best practice) and hence there is an overlay existing corresponding
> to them, as you have mentioned.
>
> I wish to preserve the custom attributes and data corresponding to them.
> *How should I go about doing that?*
> How should I analyze to which all forms the custom attribute has been
> added? via BPCU, isn't it?
> Once I have list of those forms, do I need to take backup of forms (def)
> and data (arx)?
>
> Regards,
> Aditya
>
>
> On Fri, Dec 12, 2014 at 7:34 PM, LJ LongWing <[email protected]> wrote:
>>
>> **
>> 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_
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "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"
