After business service converted to an application service, access the record in "cmdb_ci_service_discovered" list view, it returns error:
"Error Message Syntax Error or Access Rule Violation detected by database (Unknown column 'cmdb0.a_ref_27' in 'field list')"
List view of "cmdb_ci_service_discovered"
Record view of "cmdb_ci_service_discovered"
During upgrade of the instance, the creation of the filed "storage_alias" in table "sys_storage_alias" is pointed to incorrect storage table. In this case, it pointed to <storage_table_name>cmdb</storage_table_name>
- Access "sys_storage_alias" table. Search the field "storage_alias" with value "a_ref_27"
- Export the record to xml format.
3. Open the xml file and modified the "storage_table_name"
Attached "before_sys_storage_alias.xml" and "after_sys_storage_alias.xml" for reference.