CA Datacom Dataview CMCDEP96E DVW ELEMENT has missing or misaligned field(s)

Products

• Datacom
• DATACOM - AD
• Datacom/DB
• INFOCAI MAINTENANCE

Issue/Introduction

A CA Datacom dataview gives error:                                                          

CMCDEP96E DVW ELEMENT has missing or misaligned field(s)            

This happened after a column was modified from type N to C.

Environment

Release : 14.0

Component : CA DATACOM DATADICTIONARY

Resolution

The reason for the error could not be determined but something must have gone wrong with the column modification.
The solution is to modify the column back from type C  to N , Copy and Enable the area, then catalog the dvw.

Then modify the column again from type N to C, restore table from prod to T001, Copy and enable area, catalog the dvw