Created a new schema and then deleted it - Error message

[#1]

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.

[#2 · Accepted solution]

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.