Designer get frozen after click Perform Tasks to sync DB to model

Posts   
 
    
Rosacek
User
Posts: 157
Joined: 18-Mar-2012
# Posted on: 07-Dec-2023 11:46:19   

Hi, in recent days I start facing strange problem with designer (standalone application)

Many times happen when I open "Sync Relation Model Data", click "Perform Tasks..." and then LLBL Designer got frozen and expected dialog "Relation Model Data Retrieval Wizard" is not shown. I have to kill designer in task manager and start designer again and try again.

Sometimes it works normally but sometimes UI got frozen.

Project file is about 830kB, using data from several databases. But when it works it works as expected.

Any idea what could block opening data retrieval wizard dialog?

5.9 (5.9.4) RTM build date 14-Feb-2023

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39738
Joined: 17-Aug-2003
# Posted on: 07-Dec-2023 13:41:20   

Might be related to accessing the databases in your project, e.g. the network connection to your databases?

Frans Bouma | Lead developer LLBLGen Pro
Rosacek
User
Posts: 157
Joined: 18-Mar-2012
# Posted on: 07-Dec-2023 13:58:55   

DBs are on localhost (MSSQL 2019)

Anyway the problem appears "before" wizard dialog Relation Model Data Retrieval Wizard. If you have no idea, I will check if same behavior for other projects later on.

Today I faced this issue twice from about 10 runs. Yesterday that was much worse ratio like 50:50.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39738
Joined: 17-Aug-2003
# Posted on: 08-Dec-2023 08:01:02   

I can't reproduce it, and as it fluctuates, it has to be network related or server related (like, it's busy). SQL Server might be slow loading the db metadata perhaps, but other than that I don't know what it might be...

Frans Bouma | Lead developer LLBLGen Pro