If Service Desk Manager is completely down, or seeing severe performance issues the following logs may indicate an issue with the MDB:
05/08 10:01:43.86 SERVER sqlagt:select17 9276 SIGNIFICANT prov_base.c 1010 SQL Query has returned (20000) rows for (USER). Clause (SELECT <SQL Statement>) Input (<None>)
05/08 11:01:19.26 SERVER web:primary:2 11764 SIGNIFICANT session.c 4091 This request took 144349 milliseconds to complete. session id:636432343 login name: htmpl name:login.htmpl
These logs may be Frequent with high milliseconds to complete and/or high numbers of SQL Query results.
This log may be seen also:
05/08 10:49:32.28 SERVER boplgin 10444 SIGNIFICANT bplhndlr.c 1719 BOPLGIN not ready (status=6143); request queued
MDB has become backed up with SQL Queries
Release : 17.3
Restarting the SQL server should clear the queued queries and SDM should be functional.
Suggest the customer examine these queries and their purpose.
SDM is not meant to handle a high amount of queries and results.
Broadcom offers Jaspersoft Reports to handle reporting functionality if the queries are used for reporting purposes.