Catastrophic error with 5.4.3

Posts   
 
    
njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 15-Oct-2018 16:20:02   

Sorry for the headline on this but this is a serious bug with 5.4.3.

I have a project that is multi-database homed, SQL Server and MySql. It is small, pointing to a database that has only 4 tables in it.

I have a project that works but for certain reasons I need to re-sync with the databases.

I right-click and delete the entities and DTO and then try to re-sync. The re-sync happens but when I try to create new Entities from the SQL Server, I get an exception saying the entity is already created and the underlying project is trashed. As in, I cannot recover any information from it. It appears that the delete function does not really delete everything.

I have to go back to a saved llblproj to recover anything.

This is a serious issue.

The genesis of this is that the entity generated did not work with both database backends. I discovered that the MySql mapping didn't have ordering on it, but after getting ordering on it, I am still seeing mismatch errors. In order to ferret out these mismatch errors, I was attempting to re-do the project when I ran into this major error.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 15-Oct-2018 18:44:11   

Could you please create a Helpdesk thread, and attach the llblgen project file, and the DDL of both the SQL and the MySQL?

njbelf
User
Posts: 70
Joined: 07-Jun-2017
# Posted on: 15-Oct-2018 19:51:37   

Walaa wrote:

Could you please create a Helpdesk thread, and attach the llblgen project file, and the DDL of both the SQL and the MySQL?

I have created a Helpdesk thread.