I am unable to set Configuration Items that have been loaded by pdm_load or pdm_userload to inactive.

Document ID : KB000049385
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When I try to change the status of a Configuration Item from "Active" to "Inactive", the following error message appears and the change to the CI cannot be saved.

"cmdb_check_inactive:1300 - Attribute (not_ambiguous) can not be set when CI is inactive"

Solution:

When CIs are loaded by running pdm_load, the following tables are not updated:

  • ci_superseded
  • ci_ambiguity_ci

You need to run cmdb_update_ambiguity.bat after pdm_load is executed. cmdb_update_ambiguity.bat loads the CIs, forces Service Desk/CMDB to calculate the ambiguity and updates the relevant tables.

See the following example:

cmdb_update_ambiguity.bat -d MSSQL -s localhost:1434 -u sa -p password -m ci

NOTE:

It is not recommended to use pdm_load to load Configuration Item data. The pdm_load tool does not include the logic needed to properly register CI's and related tables with the MDB.

GRLoader should be used to load CI data or the web interface to modify individual records. This ensures all of the logic required to populate tables required for determining ambiguity and other functionality are updated as appropriate.

Description:

When I try to change the status of a Configuration Item from "Active" to "Inactive", the following error message appears and the change to the CI cannot be saved.

"cmdb_check_inactive:1300 - Attribute (not_ambiguous) can not be set when CI is inactive"

Solution:

When CIs are loaded by running pdm_load, the following tables are not updated:

  • ci_superseded
  • ci_ambiguity_ci

You need to run cmdb_update_ambiguity.bat after pdm_load is executed. cmdb_update_ambiguity.bat loads the CIs, forces Service Desk/CMDB to calculate the ambiguity and updates the relevant tables.

See the following example:

cmdb_update_ambiguity.bat -d MSSQL -s localhost:1434 -u sa -p password -m ci

NOTE:

It is not recommended to use pdm_load to load Configuration Item data. The pdm_load tool does not include the logic needed to properly register CI's and related tables with the MDB.

GRLoader should be used to load CI data or the web interface to modify individual records. This ensures all of the logic required to populate tables required for determining ambiguity and other functionality are updated as appropriate.