Issue
The error message "Syntax Error or Access Rule Violation detected by database (Unknown column 'discovery_map.sys_id' in 'field list')" appears when following step 7a in the Software Asset Management Foundation plugin configuration (Overwrite customizations for Software Asset Management Foundation plugin migration):
- In Software Asset Management Foundation plugin configuration, set new field values (added as part of the automatic changes performed by plugin activation) to take advantage of the new features offered.
- Navigate to Software Asset > Licensing > Software Models.
Release
Kingston
Cause
Database cache causing the issue.
Resolution
Run the following code as a background script:
gs.invalidateCache();
Related Links
Instance performance might get impacted after running the script.