Auto Flush related logs when plugin com.snc.cloud.mgmt is not installed


Description

Plugins may not be collectively installed and that can cause issues when a file residing in plugin A has some dependency on a file in plugin B.

Table Cleanup (sys_auto_flush) contains a record which meets this criteria. Auto Flush on table sn_cmp_order_step_result_chunk is OOB on Cloud Management Platform application.

https://<instance-name>service-now.com/nav_to.do?uri=sys_auto_flush.do?sys_id=483d7f1dc3078010225ed02422d3aeb4

In this example, system logs as provided are observed:

Invalid query detected, please check logs for details [Unknown field stack.stack_status in table sn_cmp_order]
Invalid query detected, please check logs for details [Unknown field order_step.order.stack.stack_status in table sn_cmp_order_step_result_chunk]

Cause

Table sn_cmp_order_step_result_chunk is installed with the Cloud Management [com.snc.cloud.mgmt] plugin.

The dependency is that without installation of plugin com.snc.cloud.mgmt, the table cannot be recognised and therefore reference specification points to an empty object. This subsequently creates an invalid dot walk path order_step.order.stack.stack_status.

Resolution

Installation of plugin Cloud Management [com.snc.cloud.mgmt] will prevent the log occurrences.

The logs can be safely ignored if there is no desire to install the Cloud Management plugin.