Schemas viewable from Console, but not present in Database | Adobe Higher Education
Skip to main content
S
SurabattulaSr
Level 6
November 19, 2021
Resuelto

Schemas viewable from Console, but not present in Database

  • November 19, 2021
  • 1 respuesta
  • 1680 visualizaciones

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

    Este tema ha sido cerrado para respuestas.
    Mejor respuesta de 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 respuesta

    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
      SurabattulaSrAutor
      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 EmployeeRespuesta
      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

        Términos y condicionesAccessibility statement

        Loading footer...