Level 5

Solved

Schema not showing up in Update Database wizard

Forum|Forum|2 years ago
January 24, 2024
1 reply
1186 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by rvnth

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

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

Manoj_Kumar

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 | https://themartech.pro

R

rvnthAuthor

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.

tarvind_singh1

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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded