Parent tables can not access reports from child domains if Report / Gauge tables contains the sys_overrides field

On certain scenarios, for example, after installing the MSP extensions plugin, the column sys_overrides is added to the sys_report table. 

The sys_overrides field is a process table only field, that reverses the flow of data visibility on a table so that processes can be consumed by child domains.

The issue with using this field on any Data table is that users lose access to child domain data while in their default domain.
Any impersonation of the user by the system will fail to access data on these tables and could break processes.

 

1. An ITIL user schedules a report in a child domain.
2. The system impersonates the user and is in the users default domain. This causes an error.
3. If you run the report on the child domain, this works. If you search for the report on the parent domain, it is not available.

This problem was fixed in New York Patch 7 and Orlando Patch 1.

A workaround for an earlier instance requires a change request to remove the columns [sys_report.sys_overrides] and [sys_gauge.sys_overrides].