Created a new schema and then deleted it - Error message

Avatar

Avatar

radhikas2660960

Avatar

radhikas2660960

radhikas2660960

01-06-2020

Hi,

I recently created a new schema and deleted it. I recreated this and was still receiving en error so deleted it again.

I am now receiving an error message that is 'unkown schema:' It seems that it has not actually deleted, however we cannot see it in the database structure anymore. Therefore, any further schema changes I am trying to do will not work as this error for that specific schema keeps popping up.

Any ideas on what to do in the situation?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jyoti_Y

MVP

Avatar

Jyoti_Y

MVP

Jyoti_Y
MVP

02-06-2020

Hi Radhika,

 

1) Looking at error screenshot:

Reason for error was: <Element> tag of leads was closed in first line itself. It shouldn't be like that.

Define your schema like below:

<element name="lead" id="lead">

<attribute ....>

</element>

 

2) Try to drop table using SQL activity:

DROP TABLE <namespace>Leads

 

3) Once done, clear your local cache and relogin.

 

Thanks.

 

Answers (2)

Answers (2)

Avatar

Avatar

_Manoj_Kumar

MVP

Avatar

_Manoj_Kumar

MVP

_Manoj_Kumar
MVP

02-06-2020

Hello @radhikas2660960 ,

You mentioned that you were getting some error initially that is why you deleted and re-created the schema.

Can you please create it again and then we can look at the schema. May be there was some linking you might have done which is throwing error now because the dependency is lost

Also, Can you click on the show details button on the error dialog box to show the more details and re-share the screenshot?

Avatar

Avatar

dhanesh04s

Avatar

dhanesh04s

dhanesh04s

01-06-2020

Hi @radhikas2660960 ,

Can you post the snapshot of the error you are facing.

 

Thanks,

Dhanesh