Notifications

33 views

Description

The following error is observed when attempting to list the affected fields:

Error Message Syntax Error or Access Rule Violation detected by database (Unknown column 'cmdb_ci_pc_hardware0.sys_id' in 'on clause')

Steps to Reproduce

One way to replicate this OOB is to create a new sys_m2m record to link incident and problem table allowing multiple Incidents to be linked to multiple Problems and vice versa:
+------------+----------+--------------------------+--------------+--------------+----------------+----------------+
| From table | To table | Many to Many table | M2M to field | M2M to label | M2M from field | M2M from label |
+------------+----------+--------------------------+--------------+--------------+----------------+----------------+
| incident | problem | u_m2m_problems_incidents | u_problem | Incidents | u_incident | Problems |
+------------+----------+--------------------------+--------------+--------------+----------------+----------------+

with this, trying to list incidents linked to a specific Problen using the many-to-many relationship, will result with the same error:
Syntax Error or Access Rule Violation detected by database (Unknown column 'incident0.sys_id' in 'on clause')

> Expected behavior: the values are listed without the error message.

> Actual behavior: The Syntax Error or Access Rule Violation error is issued.

Workaround

After carefully considering the severity and frequency of this problem, and risk of attempting a fix, it has been decided to not address this issue in any current or future releases. We do not make these decisions lightly, and we apologize for any inconvenience. If you have any questions regarding this problem, contact ServiceNow Technical Support.

The error has NO impact. The related list will work properly.


Related Problem: PRB1365789

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-10-29 03:25:23
Published:2019-10-29