Errors importing resources into CA PPM - error code : 1422

book

Article ID: 106317

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

When importing resources into CA PPM using Xog, we are getting the following error message:

<ErrorInformation> 
<Severity>FATAL</Severity> 
<Description>This record has not been inserted</Description> 
<Exception><![CDATA[SQL Exception with error code : 1422]]></Exception> 
</ErrorInformation>

Cause

In this particular instance the Xog import xml file was also updating resources OBS information
but in CA PPM there were duplicate OBS units and therefore xog failed as it could not determine which one to use.

Environment

Release:
Component: ODXOG

Resolution

Remove all duplicate OBS units