Notifications

78 views

Description

Symptoms

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"

 

Release

Madrid

Cause

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>

Resolution

  1. Access "sys_storage_alias" table. Search the field "storage_alias" with value "a_ref_27"
  2. Export the record to xml format.
    3. Open the xml file and modified the "storage_table_name"
    from
    <storage_table_name>cmdb</storage_table_name>
    to
    <storage_table_name>cmdb$par1</storage_table_name>

Attached "before_sys_storage_alias.xml" and "after_sys_storage_alias.xml" for reference.

Article Information

Last Updated:2019-11-28 12:38:27
Published:2019-06-22
after_sys_storage_alias.xmlbefore_sys_storage_alias.xmlPasted image.pngPasted image.png