ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Service Desk Manager Frequently Querying MDB

book

Article ID: 241220

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager

Issue/Introduction

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

Cause

MDB has become backed up with SQL Queries

Environment

Release : 17.3

 

Resolution

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.