CUIC ANI Query Value List Issue

[chake6000]

We upgraded CUIC from version 10.5 to 11.0. After the upgrade we hit a bug (CSCvd22426), which renders the CUIC Server unusable when an underlying ANI Value List is executed, and the CUIC Server has to be rebooted to resolve the issue. Basically CUIC goes out of memory and produces heap dumps when the ANI Value List is executed, because it pulls millions of records which renders the CUIC Server useable.

The ANI Value List is also required for our reports to pull ANI information.

Below are the queries used within the ANI Value List:

ANI Value List

Value List Query:

SELECT DISTINCT ANI AS ID, ANI AS VALUE FROM Termination_Call_Detail

Collection Query

SELECT [ID] AS ID, [VALUE] AS VALUE FROM [TABLE] WHERE CollectionIdentifierField =<COLLECTIONIDENTIFIER>

What we need is a modified query that will provide less and focused results, which will not be as verbose in the query results to cause the heap dumps.

Thanks!

[Gerry O'Rourke]

How about using TOP to limit your query or using a filter to only look at ANI from TCD for the last 365 days?

e.g. Here is a combination of both:

SELECT DISTINCT TOP 3000 ANI AS ID, ANI AS VALUE FROM Termination_Call_Detail WHERE DateTime > GetDate()-365

Or have a custom database that is used (add it to datasource) where you have exported the ANI and have it already filtered.

Gerry