How to fix "An error has occurred. The target schema is in an unknown state" on Windows PC (VS Professional 2022)?

User's image

Hello there, i tried to compare and update schema few months ago. But i performed the wrong action. I set the source and target in the opposite way and updated. after that i also incorrectly performed a Post Deployment script which is not required. after that, i received this error message everytime i tried to compare and update the schema. I re-installed visual studio professional and SQL server management studio and re-clone the whole project, but however did not resolve this issue. Could anyone inform how i should resolve this issue please? Thanks!

ShaktiSingh-MSFT 15,341 Reputation points

2024-06-17T03:58:24.3933333+00:00

Hi Lu, Yiling (SI BSW OPS TECH SW-ENG 3) •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Lu, Yiling (SI BSW OPS TECH SW-ENG 3) 0 Reputation points

2024-06-18T05:00:51.1+00:00

Hello there,

I have tried step 2 and 3 but not working.

For step 1, would you mind to be a little more specific on how I can check any schema that have been modified and fix it so I can proceed future schema comparison normally please?

And for step 4 do you mean to delete the dbmdl file from the project? Do I also need to remove the bin and debug folder?

Thank you for your help!

1 answer

ShaktiSingh-MSFT 15,341 Reputation points

2024-06-14T08:08:38.5633333+00:00

Hi Lu, Yiling (SI BSW OPS TECH SW-ENG 3) •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting "An error has occurred. The target schema is in an unknown state" in Azure Database for MySQL.

Could you please try the solutions mentioned below:

1). This could be caused by a new schema added, try to check drop and recreate.

2). Check version of your Software, try updating if helps.

3). Try to open VS with "Run As Administrator" mode.

4). Try to clear cache file(dbmdl) from the project if that helps.

Let us know if any of the above helps you proceed.

If not, please share more details step wise so that we can investigate.

Thanks
Please sign in to rate this answer.
Lu, Yiling (SI BSW OPS TECH SW-ENG 3) 0 Reputation points

2024-06-18T05:05:49.7133333+00:00

Hello there,

I have tried step 2 and 3 however not working.

For step 1, may i ask could you give a little more information on how i can check which schema has been modified/added and to revert it so i can proceed future schema comparison successfully please? because currently i do not need to change any schema, just trying to fix the issue first for future comparison.

For step 4, do you mean to delete the dbmdl file from the project? (do i also need to remove the bin and debug folder as well?)

Thank you very much!

ShaktiSingh-MSFT 15,341 Reputation points

2024-06-19T07:33:30.4066667+00:00

Hi Lu, Yiling (SI BSW OPS TECH SW-ENG 3) •,

We are sorry about the issue you are experiencing.

Yes, you are right, try deletion and re-compare.

Also, refer to similar post here on Stackoverflow forum:

https://stackoverflow.com/questions/25661094/when-using-sql-server-data-tools-what-can-i-do-about-the-error-message-an-erro

Let us know your findings.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to fix "An error has occurred. The target schema is in an unknown state" on Windows PC (VS Professional 2022)?

1 answer

Your answer