Loading...
Loading...
Using the related list via a Report on a cmdb_ci extended table returns no results and causes an error "Syntax Error or Access Rule Violation detected by database" Steps to Reproduce 1. login to any madrid instance (patch 2) . 2. Configure the cmdb_ci_service_group , to include the 'Service Group > Parent Group' Related list. 2. Create a Report based on cmdb_ci_service_group 3. Choose Type = List 4. Via Related List Conditions choose: Service Group > Parent Group 5. Run the report and following error is encountered: Error MessageSyntax Error or Access Rule Violation detected by database (Unknown column 'sj0.a_ref_8' in 'on clause') Error MessageSyntax Error or Access Rule Violation detected by database (Unknown column 'sj0.a_ref_8' in 'on clause')
This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In field to determine whether any versions have a permanent fix.
PRB1347836
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.