Why does GlideAggregate create a limited number of rows?

zsquared
Tera Contributor

‎06-12-2017 04:51 AM

Hello,

I was wondering if someone can provide insight on this issue...   I created a GlideAggregate script to count the number of rows of data grouped by a certain column.   I am expecting to see about 150K in new rows to show the aggregate data but the script keeps maxing out at 100,001 rows.   Does anyone know why this could be the case?

Labels:
0 Helpfuls
  • 1,945 Views
10 REPLIES 10

TrenaFritsche
Tera Expert

‎06-12-2017 05:39 AM

Hi Zhen,


Try checking the system property "com.snc.pa.dc.max_row_count_indicator_source" to see if the value is 100000.   This sounds like it is controlled by a property, but this property is the closest one I could find that might be controlling it?   Let me know if this is it.



Thanks,


Trena


0 Helpfuls

TrenaFritsche
Tera Expert

‎06-12-2017 05:41 AM

Also, I just noticed that it has .pa. in the name and I think that property might relate to Performance Analytics, so it might not be it.  


0 Helpfuls

zsquared
Tera Contributor
In response to TrenaFritsche

‎06-12-2017 05:47 AM

Yeah, this system property doesn't change the number of rows imported from glideaggregate script.


0 Helpfuls

amlanpal
Kilo Sage

‎06-12-2017 05:59 AM

Hi Zhen.



Please have a look at the system property named 'glide.db.max.aggregate.size' mentioned over here: Available System Properties - ServiceNow Wiki. It might be related to the issue you are facing, honestly, I don't know firmly.



I hope this helps.Please mark correct/helpful based on impact


0 Helpfuls