CMS : Report generation slows down and also gets hung


Doc ID    SOLN212666
Version:    7.0
Status:    Published
Published date:    17 Apr 2020
Created Date:    20 Oct 2012
Author:   
ysu
 

Details

Any CMS Release

The CMS system slowed down and then hung on reports

Problem Clarification

Reports became locked or hung for all users
 

Cause

Agent Groups should be limited to approximately 30 agents (for Release 16.3 or lower) or 99 agents (for Release 17 and higher). Any agent groups much larger than 30 / 99 agents should be avoided because system performance will be adversely affected.

Possibly caused by a hung process but because was unable to open some menus was unable to confirm

Solution

Customers have to either break down the agent group setting or set in CMS application menu: Maintenance  ->  Report Administration, “Agent Groups > 30 / 99” to “NO” so users are not able to run any agent group reports larger than what is supported (this feature is only avaialbel to the customers who have CMS version >= R16.2)

Place system in single user mode after given permission and back to multi user and test

 The SMALLINT data type stores small whole numbers that range from 32,767 to 32,767. The maximum negative number, 32,768, is a reserved value and cannot be used.
The SMALLINT value is stored as a signed binary integer.
Integer columns typically store counts, quantities, and so on. Because the SMALLINT data type requires only two bytes per value, arithmetic operations are performed efficiently. SMALLINT, however, stores only a limited range of values, compared to other built-in numeric data types. If a number is outside the range of the minimum and maximum SMALLINT values, the database server does not store the data value, but instead issues an error message.

supervisor could only display no more than 32767 lines, which is working as designed

Attachment File

designer report.png
21K • < 1 minute @ 56k, < 1 minute @ broadband



Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy