Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

Schema not showing up in Update Database wizard

Avatar

Level 5

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 5

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 5

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 5

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