Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Schemas viewable from Console, but not present in Database

Avatar

Level 7

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

1 Accepted Solution

Avatar

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

Avatar

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

Avatar

Level 7

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

 

 

Avatar

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

Avatar

Level 7

Thanks @Adhiyan,

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