After deleting an entity we get the following error during publish:
Upgrade Error
Generic SQL Error. Invalid object name 'OUTSYSTEMS.dbo.OSUSR_DWP_TEST'. System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'OUTSYSTEMS.dbo.OSUSR_DWP_TEST'.
Hey,
Its seems that you have used that deleted entity somewhere so thats why this error occures.
Thanks
Yogesh
Hello,
I think you already published your module with that test entity and after that created a new entity with same name. So OS get confused as there was already an entity with that name. I will suggest you to create the entity with different name to avoid this error.
Hope it helps!
Sanjay
Hi Sanjay,
Thanks for your reply.
The test entity is was created once and we just want to get rid of it.Renaming the entity doesn't help either.
Kind regards, Cees
There is a workaround for this specific problem in this post :
https://www.outsystems.com/forums/discussion/39384/invalid-object-name/
First try with the marked solution, if didn't work, you can approach for finding physical table 'OSUSR_DWP_TEST' in osys_entity and deleting that.
Hi Cees,
Could you please try to restore the previous version and then try again to delete it. Also please check if you have used this entity name somewhere in an Advance query?
Regards,
-PJ-