Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Schema not showing up in Update Database wizard

Avatar

Level 4

Hi everyone , 

 

I encountered an unusual problem while attempting to update the columns in the table. Although this table was present in Data Schemas, it was not visible in the Update Database Wizard.

 

Please suggest, how Can I make sure the updates processed to DB. 

 

Thank you in advance

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi @isahore ,

 

There was view-='true' attribute defined at schema level which is blocking and not getting displayed at Update Database wizard. I have removed and the table is getting displayed there.

 

Thank you everyone

View solution in original post

5 Replies

Avatar

Community Advisor

Hello @rvnth 

 

Could you please add more details on what changes you have made in the schema? 

 

Update Database schema does not show SQL/change for all kinds of updates.


     Manoj
     Find me on LinkedIn

Avatar

Level 4

Hi @Manoj_Kumar_ , 

 

I have incorporated a new field into the schema in XML. Yet, I expected that at a minimum, the table would appear in the Update Database Wizard. Surprisingly, the table itself isn't displayed in the database wizard.

This has led me to question where the table has disappeared and why it is absent in the Update Database Wizard.

 

Thank you in advance.

Avatar

Level 1

Hi @rvnth , Check if any other schema has been saved recently with XML Errors or even the schema you have saved has small XML errors. Normally, if any schema issue is present, you won't see 'Update Data Wizard. showing any schema changes.

Hope it helps!

Avatar

Community Advisor

Hi @rvnth,

 

Does your schema has mappingType = sql?

If not, then there is no table beneath it, hence you might not be seeing it in the wizard at all.

 

Regards,

Ishan

Avatar

Correct answer by
Level 4

Hi @isahore ,

 

There was view-='true' attribute defined at schema level which is blocking and not getting displayed at Update Database wizard. I have removed and the table is getting displayed there.

 

Thank you everyone

The following has evaluated to null or missing: ==> liql("SELECT id, subject, body, depth, post_time, author.login, author.id, author.rank, metrics.views FROM messages WHERE topic.id = '${topicId}' AND is_solution = true").data.items[0] [in template "analytics-container" at line 82, column 31] ---- Tip: It's the final [] step that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign acceptedAnswer = liql("SELECT... [in template "analytics-container" at line 82, column 5] ----