Highlighted
Absent Member.. Absent Member..
Absent Member..
126 views

Large Report Generation Error

We are running uCMDB 9.05, CUP14 with CP11u14.

 

We are trying to generate a large report and getting the error below.  What settings have to be adjusted to make this work?

 

2014-10-30 15:55:19,498 [1766877078@Tql Pattern Calc Process Task-27129] (TqlUpdateSetResultToRepository.java:298) ERROR - Pattern [SN Retire IPAddress] result is too big. Objects Size=212433. Links Size=157760, Max=100000
2014-10-30 15:55:19,929 [1766877078@Tql Pattern Calc Process Task-27129] (TqlUpdateSetResultToRepository.java:306) ERROR - Pattern :SN Retire IPAddress was changed to not active since size of result exceeds limit.
2014-10-30 15:55:20,231 [1491116308@qtp0-48576] (AbstractCommonOperation.java:106) ERROR -      !!!     Operation       Tql Query: Get Server Tql Result. Pattern [SN Retire IPAddress]()   ID:     320965632       FAILED (running time:   16317 ms[ms])
com.mercury.topaz.cmdb.shared.tql.exception.TqlException: [ErrorCode [120] failed to calculate active & not-persistent pattern]
Failed to calculate results for the pattern :SN Retire IPAddress

 

 

0 Likes
3 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Large Report Generation Error

Hello Rich ,

 

 

I hope you are doing well .

 

 

I have been reviewing and the error is :"size of result exceeds limit."

 

We would to test using a smaller tql and run the report .

 

Please feel free to contact me if you need something else .

 

Best Regards ,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: Large Report Generation Error

Hi Melissa,

 

Rich and I have been trying to generate this report which has over a 100,000 Ip Address CIs.

We don't have a problem generating reports using smaller TQLs but, putting them together is a pain.

 

What we need to know from you is,

1: What is the name of the setting that controls this number in Infrastructure settings.

2: What are the consequences of changing the limit ?

 

Kindly oblige.

 

Thanks,

Praveen

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: Large Report Generation Error

Any updates or solutions for this post ?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.