Service Desk Manager - New Fields from ITIL Content Pack Not Created Correctly
search cancel

Service Desk Manager - New Fields from ITIL Content Pack Not Created Correctly

book

Article ID: 145754

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

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: