Content

Problem description / Issue description

When you start the service of the SmartConsole, or even if it was working fine, you can notice that suddenly the SmartConsole window stops responding, it freezes.

Cause

It could be due to several reasons, but the most common cause is because of the size of the WebSmartConsole database. To verify if this is the root cause of the problem, then you should enter the file t4trace.log (located by default into your SmartConsole installation directory) and search for this type of errors: 

Error found executing "DELETE FROM wsc_messages WHERE msgdate < 'YYYYMMDDhhmmss'": [Microsoft][SQL Native Client]Query timeout expired

EXCEPTION: [Microsoft][SQL Native Client]Query timeout expired

Solution

You can clear all historical messages from the wsc_messages table executing the following SQL sentence:

truncate table wsc_messages
truncate table msgbv

IMPORTANT NOTES:

  • This will delete all your historical WebSmartConsole messages.
  • If you try to execute the sentence DELETE into your SQL Server engine, then you will make the Log File of the database increase its size to a really huge value (so, emphatically we don't recommend using DELETE, instead we recommend using TRUNCATE).
     

Additional information

Related articles

SmartConsole stop responding when the maintenance of WebSmartConsole is running

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: October 23, 2018