Error When Attempting to Create a Change Plan Template after Upgrade to 8.x

Products

• ServiceDesk

Issue/Introduction

The customer upgraded his Servicedesk from 7.5 to 8.x.  After the upgrade,  it was decided that Change Templates would be used.  When attempting to create a change plan template, after the upgrade, the below error occured.

System.Exception: Execution Exception ---> System.Exception: exception component created:  ---> LogicBase.Framework.BusinessRuleException: The critical error failed execution on component List Change Plan Templates : Invalid column name 'CmChangePlanTemplateId'. :    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

Environment

Upgrade from 7.5 to 8.x

Cause

The ORM data type for the database table CmChangePlanTemplate did not properly update with the revised structure to respect the foreign key changes made in 8.x

Resolution

Run the following SQL in your environment:

Delete from ObjectStructureCheck where type_name = 'Symantec.ServiceDesk.Cm.Core.DataTypes.ChangePlanTemplate'

Then attempt to create a new Change Plan Template and make sure that you include an approval chain or CAB.