Elements exceeds the maximum allowed as defined in the Properties

Nate Wert1
Giga Guru

I have a user table that has 110K plus records.   I am trying to get a breakdown of a team by user.   When I create a breakdown source off the sys_user table I get the following error: "This breakdown source was automatically disabled because the number of elements exceeds the maximum allowed as defined in the Properties".   What is even more perplexing is the fact that with the filters set, this breakdown source is really only using 7 records.

I have tried to adjust the properties setting to exceed the number of records that are in this breakdown.   The property that I adjusted was "Maximum number of breakdown elements for a breakdown to be included in data collection."   However still get the same message.  

  Has anyone seen this before?   Thoughts?

13 REPLIES 13

Thank you Vincent and all, for your help.



That was apparently the problem.   Once it disables it, it remains that way.   When I put the same conditions into a new breakdown source.   It works great.   Thank you very much for your time.



Regards,


Nate


Hi Nate,



did you check the "DC active" check box after you changed the conditions?


In your screen capture it shows as unchecked.


Elements exceeds the maximum allowed as defined... _ ServiceNow Community 2015-12-23 13-51-08.png



Greets,


Jochen


Hi Jochen,



Thank you for responding.   Not sure what that does.   Can't seem to find on wiki.



Nate.


Hi Nate,



when during a data collection a breakdown source hits the element limit the breakdown source is disabled and the message, displayed in red in the screen capture, is shown. As long as the breakdown source is disabled the data collector won't include it in following collection cycles. I think that was the reason that after you changed the filters of the breakdown source it still was not included in collections. As solution you created a new breakdown source.



Ticking the "DC active" check box would have solved your issue without having to create a new breakdown source.



Thanks,


Jochen