Jobs Collected with Errors

[Michael Bachme1]

When I try running the Daily Job Collection, I'm getting errors. Specifically this one:

Fetched too many rows from indicator source Incidents.Open. Allowed: 50,000 fetched: 420,600

The default property setting for "Maximum number of rows that are allowed to be fetched from an Indicator Source" is 50000. What is the best way to run this job without getting this error?

Thanks

[Vincent Loffel1]

Hi Michael,

What think happened is that the filter of the indicator source incident.open looks for incidents without a resolved date. In some cases (mostly when you updated your ServiceNow instance from dublin or earlier) the field resolved isn't filled when closing an incident. Therefore it shows all incidents ever recorded, which is apparently a lot 🙂

Go to Indicator Source-> Incidents.Open

It looks probably like this:

Now add two filter options like resolved, but instead use the field Closed. It should now look similar to this:

To verify that it worked click on the yellow arrows (refresh). It should now show a lot less incidents.

Note that you have to make the same adjustments for the Incident.Resolved indicator source.

Cheers,

Vincent

[Vincent Loffel1]

Hi Michael,

Did I answer your question? Or do you still encounter some problems?

Cheers,

Vincent

[ammar_naqvi1]

Thank you so much Vincent for your solution. I am working on Helsinki and your reply on the completed field resolved my issue.

One thing concerning, that there is no Resolved field in Helsinki

There is one Resolved Time. that we can make empty but can not after today.

Can you advise on that if this is needed or not. Thanks once again

Ammar

[Vincent Loffel1]

Hi Ammar,

If there is no resolved field you should check out the plugin list. Search for "Incident Resolution Fields". Old instances do not have the plugin enabled automatically, that happened only to instances created after Calgary release, i believe.

Cheers,

Vincent