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.
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
You can clear all historical messages from the wsc_messages table executing the following SQL sentence:
truncate table wsc_messages
truncate table msgbv
Still have questions? We can help. Submit a case to Technical Support.