Attribute level cleanup

[raghavendra_desu]

Hi Experts,

If i add a attribute to a itemtype and update the system, it will be added to that table. But later if i want to remove that attribute from system, i can't remove that particular column using Hybris update. I have tried with system cleanup as well. The system cleanup is removing the itemtype level not at attribute level. The only way i can remove that attribute from db is either through initialization or dropping that column directly from db. If i drop the column from db, still i can find the attribute is available with the itemtype definition in hmc. I have observed this by using MySql. Is there a way to remove that column with out initialization..? If i want to change the attribute type also we can't perform that. Is anyone observed this situation before, if observed can you please help me if you found the solution.

Thanks in Advance

Raghavendra.

[Former Member]

Hello Raghavendra,
Please follow below process to perform attribute level cleanup :
1. Remove attribute definition from item type and update the system, also you have to manually drop the column form the table.
2. Once this is done - restart the hybris server and open HMC or BackOffice
3. go the System - > Types and search for your type
4. in the properties tab - remove the attribute that you want to remove
5. this will remove unwanted attribute from all places - such as models, tables and respective representation in HMC or any other cockpit.
To change the data type of the attribute you can do it in the Similar way - update your item declaration - do the system update - update column in the database directly and lastly update type system in HMC

If you find it correct please upvote and mark answer as correct.