Created a new schema and then deleted it - Error message | Community
Skip to main content
radhikas2660960
Level 2
June 2, 2020
Solved

Created a new schema and then deleted it - Error message

  • June 2, 2020
  • 3 replies
  • 5800 views

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.

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 Jyoti_Yadav

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.

 

3 replies

Level 3
June 2, 2020

Hi @radhikas2660960 ,

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

 

Thanks,

Dhanesh

radhikas2660960
Level 2
June 2, 2020

Manoj_Kumar
Community Advisor
Community Advisor
June 2, 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?

Manoj  | https://themartech.pro
radhikas2660960
Level 2
June 2, 2020

Hi Manoj,

I recreated the schema and once I click 'save' i get the unknown schema error.

Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
June 3, 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.