Schemas viewable from Console, but not present in Database | Community
Skip to main content
S
SurabattulaSr
Level 6
November 19, 2021
Solved

Schemas viewable from Console, but not present in Database

  • November 19, 2021
  • 1 reply
  • 1680 views

Hello Folks,

We have a strange issue where few of the OOTB schemas which are visible from Console but not present in the Database.

We are using ACC V7 and Oracle as DB

Any thoughts why it could be?

@adhiyan @vraghav @jyoti_yadav @jonathon_wodnicki 

Thanks,

SSB

    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 Adhiyan

    Hello Ssb,

     

    All the schemas you have mentioned are following the template of xtk:folder as evident from the below definition :

    <element img="nms:program.png" name="program" pkgAdmin="@id != 0" template="xtk:folder">

     

    You can go in the data tab for each schema , do a configure list and select the SQL query to find out which table the query is actually running.

     

    This basically means , nms:program , nms:offerCategory , nms:plan will exist as different types of entities under the xtk:folder table 

    OR

    they are folders of different types in the hierarchy .

     

    Regards,

    Adhiyan

    1 reply

    Adhiyan
    Adobe Employee
    AdhiyanAdobe Employee
    Adobe Employee
    November 19, 2021

    Hello,

    There can be two possibilities.

     

    1. Schemas are created but not synced with the Database from the application via the update database wizard.

    2. Certain attributes when applied to a schema ensure that they don't get created as a table on the Database.

    For example - you won't see nms:broadLog and nms:trackingLog in the database although they are present in the console as they are libraries ( templates ) to create other tables.

    the attribute - library="true" determines this.

     

    So if it's not case 1 , then please provide the schema definition under the <srcSchema> ....<srcSchema/> tag to check why it's not in the Database.

     

    --

    Adhiyan

      S
      SurabattulaSrAuthor
      Level 6
      November 19, 2021

      Thanks @adhiyan for your quick response!

      Definitely 1 is not the case because I am talking about a OOTB schema (nms:program) which is never extended or changed. However, I don't see this schema at all in Update DB Wizard

      Here is the complete schema code for the same.

      BTW this is happening with OOTB schemas, not custom one's. We never touched nor did any change. Another example is nms:plan, nms:offerCategory etc.

      Kindly please help with any suggestions

      Thanks

       

       

      Adhiyan
      Adobe Employee
      AdhiyanAdobe EmployeeAccepted solution
      Adobe Employee
      November 22, 2021

      Hello Ssb,

       

      All the schemas you have mentioned are following the template of xtk:folder as evident from the below definition :

      <element img="nms:program.png" name="program" pkgAdmin="@id != 0" template="xtk:folder">

       

      You can go in the data tab for each schema , do a configure list and select the SQL query to find out which table the query is actually running.

       

      This basically means , nms:program , nms:offerCategory , nms:plan will exist as different types of entities under the xtk:folder table 

      OR

      they are folders of different types in the hierarchy .

       

      Regards,

      Adhiyan

        Terms & ConditionsAccessibility statement

        Loading footer...