HUB Desktop Taking a Long Time to Load

Owned by Former user (Deleted)
Aug 12, 2019
2 min read

Problem

Some desktop installations result in the application not loading properly. This may be due to a need to manually start the SQL database, a process which takes about 5 minutes, and is detailed below.

 

Solution

If you have recently installed the HUBPL Desktop and it seems to take a long time to load properly, loads an incomplete page, or a message appears stating “configuring database for the first time” then some manual, administrative steps may be required to effectively initiate the application.

  1. Clear the current database in the Command prompt:

2. Now restart the SQL server by typing the following set of commands, pressing enter after each line

  • sqlcmd -S .\HUBSERVER -U sa -P HUB@2018

  • GO

  • USE master;

  • GO

  • drop database UPDM_TEST_1

  • GO

3. If the above steps cause an error, please try:

  • sqlcmd -S .\HUBSERVER -U sa -P HUB@2018

  • GO

  • USE master;

  • GO

  • ALTER DATABASE UPDM_TEST_1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

  • GO

4. Publish the database

  • Go to the location C:\TechnicalToolBoxes\HUB

  • Launch the HUBPL Windows Batch File

  • Close the window once the execution is complete:

  •  

5. Load the HUBPL desktop (Use the local host URL to access HUBPL desktop):

  • Enter the user’s credentials as prescribed by Technical Toolboxes (Once successful, the HUBPL homepage loads the first canvas and any available tools can be accessed)

Related articles