Schemas viewable from Console, but not present in Database

[Ssb_94]

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 @Vipul_Raghav @Jyoti_Yadav @Jonathon_wodnicki 

Thanks,

SSB

[Adhiyan]

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

[Ssb_94]

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 · Accepted solution]

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

[Ssb_94]

Thanks @Adhiyan,

Yes you are right, these are nothing but referring to Xtk:Folder