Delete attributes from native schema | Community
Skip to main content
wkt85768776
wkt85768776
Level 3
November 29, 2017
Solved

Delete attributes from native schema

  • November 29, 2017
  • 17 replies
  • 14003 views

Hello, i would like to know if i can delete an attribute from a native schema of AdobeCampaign. I need to delete some but i dont know how does it will affect neolane or the DB. I will also need to know how to do it .

thanks

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by vraghav

    To delete an existing attribute on factory schemas follow the steps outlined here

    • Extend the scehma
    • Define the same attribute again in this extended schema (name must match) and then define _operation="delete"
    • Save the schema and update database structure.

    <attribute name="registrationToken" _operation="delete"/>

    Should you do this?

    I would not recommend it as you never know what can break in the system when deletion of an attribute happens.

    Regards,
    Vipul

    17 replies

    Show previous replies
    florentlb
    florentlb
    Level 10
    December 5, 2017

    Hi again,

    Adobe's answer is the same one David's suggested, and the same that Vipul, who is very familiar with dealing with such issues as part of our Customer Care organization, suggested.

    As for Vipul's suggestion, did you correctly perform all the steps he mentioned, including extending the schema (not modifying the schema itself)?

    Florent

      KX00557965
      KX00557965
      July 1, 2018

      Hi Vipul,

      What if we have mistakenly extended factory schema using the same namespace 'nms'.

      Do you think we can delete only the extended part using the above mentioned command?

      Thanks

      Kapil

      Prem_Kumar_Gane
      Prem_Kumar_Gane
      Level 3
      July 4, 2018

      Hi Kapil,

      _operation="delete" attribute is used to delete the columns in the schema.  When we extended the OOTB recipient schema with the same nms:  namespace , it will override the existing schema and hides the schema definition but the structure remains unchanged. We too had the same issue, to restore the schema we need to replace the schema definition from any other instance and save it .

      Thanks & Regards,
      Prem Kumar Ganesan

      A
      Anonymous
      July 13, 2018

      Hi Prem,

      Could you please elaborate the steps on how to restore the schema from other instance?

      I tried it and when I hit the Regenerate Schema option it gives the below error -

      Thanks & Regards,

      Sadaf

      Prem_Kumar_Gane
      Prem_Kumar_Gane
      Level 3
      July 16, 2018

      Hi sadafali​,

      If your instance is hosted in Adobe data centers , please raise adobe support ticket to restore the schema . If its on-prem or hybrid model, follow the below steps to restore your OOTB schema . Ensure this operation should be performed only by Expert users .

      1. Under configurations-- Data Schemas -- Right click on the schema whichever you want to replace and click delete. Refresh the folder and ensure the schema is deleted .

      2. Click on  'New' button, select create a New table, give the name, label of the deleted schema and click next .

      3. Now in the edit schema window just delete the auto generated schema definition code starting from <srcSchema....>  to  </srcSchema>

      4.Copy the deleted schema definition starting <srcSchema....>  <attributes...> </srcSchema> from other instance, paste it in the edit window and click save .

      5. Now try to open the replaced OOTB schema and verify whether its shows a warning as "factory configured - object should not be edited".

      Thanks,

      Prem Kumar Ganesan

        alwaysDigital
        alwaysDigital
        Level 2
        September 13, 2018

        Hi Prem,

        I am facing issues with editing any schema in my Adobe Sandbox server. Issue seems with nms:seedMember schema which is corrupted somehow. Now I am not able to regenerate to repair it. It is always throwing error like -

        xtk-170030 empty value is not valid as a key for element srcSchema of document type Source schema of entities (xtk:srcShema)

        Can you suggest something here. Thanks a lot in Advance.

        Cheers!

        miked83399566
        Adobe Employee
        miked83399566Adobe Employee
        Adobe Employee
        September 7, 2019

        Thx Prem!  This info was just what I needed!!

          Terms & ConditionsAccessibility statement

          Loading footer...