Service Desk Manager - New Fields from ITIL Content Pack Not Created Correctly
Article ID: 145754
Updated On:
Products
Issue/Introduction
We installed the ITIL content pack on our environment and began encountering a number of errors. We found that the new fields that the content pack added were created in Schema Designer, but the fields did not exist in the data dictionary or database. I tried to re-run the pdm_publish command and that updated the data dictionary, but the fields were still not created in the database, so we still encountered errors.
5012 ERROR majic.y 2757 Column Act_Log.zClarityLastSync for attribute alg.zClarityLastSync is not defined in the schema
5012 ERROR majic.y 2821 Column Change_Request.zcategory_init for attribute chg.zcategory_init is not defined in the schema
5012 ERROR majic.y 2821 Column Change_Request.zchg_bus_cls for attribute chg.zchg_bus_cls is not defined in the schema
5012 ERROR majic.y 2757 Column Change_Request.zcl_proj_id for attribute chg.zcl_proj_id is not defined in the schema
5012 ERROR majic.y 2757 Column Change_Request.zcl_task_id for attribute chg.zcl_task_id is not defined in the schema
5012 ERROR majic.y 2821 Column Change_Request.zisRelease for attribute chg.zisRelease is not defined in the schema
5012 ERROR majic.y 2821 Column Change_Request.zowner for attribute chg.zowner is not defined in the schema
5012 ERROR majic.y 2757 Column Change_Request.zscope for attribute chg.zscope is not defined in the schema
Environment
Release : 17.2 and newer
Component : SERVICE DESK MANAGER
Resolution
Manually copy the following files from the content pack zip:
files\schema\wsp.altercol
and
ITIL_Content_17_x\files\schema\wsp.altertbl files
Place them into the the site\mods on the primary server and then run the pdm_publish
This should force the creation of the fields in the database.
Additional Information
Information on where to obtain the ITIL Content Pack is available in the existing documentation:
Feedback
