Event Management - Impact Tree Builder job retrieves too many records impacting instance performanceIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Event Management - Impact Tree Builder may retrieve too many records and impact performance especially when multiple jobs execute in parallel. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All releases Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Query conditions may result in large result sets. [0:00:00.016] Compacting large row block (file.write: em_impact_maint_ci 10000 rows 160000 saveSize)[0:00:00.017] Compacting large row block (file.write: em_impact_maint_ci 10000 rows 160000 saveSize)[0:00:00.018] Compacting large row block (file.write: em_impact_maint_ci 10000 rows 160000 saveSize)WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 324238Query that got us here is: TABLENAME = em_impact_maint_ci ENCODED_QUERY = statusISEMPTY^ORstatus=newly added com.glide.db.QueryWarning.warn(QueryWarning.java:44) com.glide.db.DBQuery.loadResultSet(DBQuery.java:3227) com.glide.db.DBQuery.executeAndReturnTable(DBQuery.java:338) com.glide.db.DBAction.executeNormal(DBAction.java:241) com.glide.db.DBAction.executeAndReturnException(DBAction.java:195) com.glide.db.RDBMSQueryContext.executeQuery(RDBMSQueryContext.java:42) com.glide.db.DBQuery.execute(DBQuery.java:2664) com.glide.db.meta.Table.queryBasic(Table.java:331) com.glide.db.meta.Table.query(Table.java:205) com.glide.script.GlideRecordITable.query(GlideRecordITable.java:108) com.glide.script.GlideRecord.query0(GlideRecord.java:3314) com.glide.script.GlideRecord.query(GlideRecord.java:3033) com.snc.sw.dao.BasicDAOImpl.find(BasicDAOImpl.java:146) com.snc.sw.dao.BasicDAOImpl.find(BasicDAOImpl.java:125) com.snc.sw.dao.BasicDAOImpl.find(BasicDAOImpl.java:121) com.snc.sw.impact.data.ImpactMaintCiDAO.getAllCisMarkedAsMaint(ImpactMaintCiDAO.java:55) com.snc.sw.impact.handler.ImpactMaintenanceHandler.getCisToMarkAsMainteanance(ImpactMaintenanceHandler.java:340) com.snc.sw.impact.handler.ImpactDiscoveredServiceGraphHandler.buildAndSaveImpactGraph(ImpactDiscoveredServiceGraphHandler.java:58) com.snc.sw.impact.handler.ImpactTreeBuilderHandler.createImpactGraph(ImpactTreeBuilderHandler.java:215) com.snc.sw.impact.handler.ImpactTreeBuilderHandler.buildTree(ImpactTreeBuilderHandler.java:202) com.snc.sw.impact.handler.ImpactTreeBuilderHandler.handleNextTriggeredService(ImpactTreeBuilderHandler.java:178) com.snc.sw.impact.handler.ImpactTreeBuilderHandler.handleTriggeredServicesFlow(ImpactTreeBuilderHandler.java:120) com.snc.sw.impact.handler.ImpactTreeBuilderHandler.handleTriggeredServices(ImpactTreeBuilderHandler.java:92) com.snc.sw.impact.ImpactManager.jsFunction_handleForTriggeredServices(ImpactManager.java:210) sun.reflect.GeneratedMethodAccessor1185.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138) org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:670) org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614) org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2582) org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:85) org.mozilla.javascript.gen.sys_trigger_08bab0131b131010b6cf98ec0a4bcb67_331303._c_script_0(sys_trigger.08bab0131b131010b6cf98ec0a4bcb67:1) org.mozilla.javascript.gen.sys_trigger_08bab0131b131010b6cf98ec0a4bcb67_331303.call(sys_trigger.08bab0131b131010b6cf98ec0a4bcb67) org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:563) org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3429) org.mozilla.javascript.gen.sys_trigger_08bab0131b131010b6cf98ec0a4bcb67_331303.call(sys_trigger.08bab0131b131010b6cf98ec0a4bcb67) org.mozilla.javascript.gen.sys_trigger_08bab0131b131010b6cf98ec0a4bcb67_331303.exec(sys_trigger.08bab0131b131010b6cf98ec0a4bcb67) com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:279) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:118) com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:82) com.glide.script.Evaluator.evaluatePossiblePrefixedString(Evaluator.java:210) com.glide.job.RunScriptJob.evaluateScript(RunScriptJob.java:166) com.glide.job.RunScriptJob.execute(RunScriptJob.java:87) com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:108) com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:111) com.glide.schedule.JobExecutor.execute(JobExecutor.java:95) com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:329) com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:192) com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35) com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:192) com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:100) Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Have the customer create an "evt_mgmt_impact_maint_ci.max_size" system property of value 100000.