Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Schemas viewable from Console, but not present in Database

Ssb_94
Level 6
Level 6

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

Thanks,

SSB

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

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.

 

Adhiyan_0-1637580403804.png

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

View solution in original post

4 Replies
Adhiyan
Employee
Employee

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
Level 6
Level 6

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

Ssb_94_0-1637355209815.png

Here is the complete schema code for the same.

Ssb_94_1-1637355316479.png

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
Correct answer by
Employee
Employee

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.

 

Adhiyan_0-1637580403804.png

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

View solution in original post

Ssb_94
Level 6
Level 6

Thanks @Adhiyan,

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