Errors importing resources into CA PPM - error code : 1422

Document ID : KB000106317
Last Modified Date : 13/07/2018
Show Technical Document Details
Issue:
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.
Resolution:
Remove all duplicate OBS units