fix script max execution time?

[kjcv912]

Hi

Running housekeeping scripts on pa_scores table (Performance Analytics) and have observed that the fix scripts ends after 24 hrs and some minutes (2 up to 45 min) even though there is huge number of orphan records to be deleted.
Has disabled business rule "PA Cache buster" (pa_scores / trigger Delete).
Execute the fix scripts in the background.

Progress Workers list view shows that   State is "Complete" and background colour green which doesn't match my view when it has terminated before being removing all orphan records.

When checking messages via "System Diagnostics > Progress Workers Fix Script: PA - Remove orphan BD(5)"

can I see TOTAL time at the bottom and in several cases also NPEs

Evaluator: java.lang.NullPointerException

    Caused by error in script at line 19

16:	while (gr.next()) {
17:		count++;
18:		gs.log("PA: Indicator '" + gr.indicator + "' and element '" + gr.element + "' on " + gr.start_at + " score " + gr.value + " deleted. ( " + count + " of " + gr.getRowCount() + " )", logSource);
==>   19:		gr.deleteRecord();
20:	}
21:
22:	gr.close();

[24:29:23.655] Total Time

line 19 has been executed 4 000 000 times and suddenly this NPE.

Is there a instance / global setting stopping fix scripts after 24 hours of execution time ?

Any ideas?

Stefan

[Uncle Rob]

That's some great intel.