Self-Solve Knowledge Search

Minimize Maximize
Overflow error trying to insert/update data using Connect -IT
This document has not been formally reviewed for accuracy and is provided as is
Title :
Overflow error trying to insert/update data using Connect -IT
Document ID :
KM01517131
Product - Version:
asset manager 9.41 ;
OS :
Windows
Updated :
Thu Apr 16 21:12:04 GMT 2015
Summary :
An overflow error is being displayed when you try to insert/update data using Connect -IT
Problem
Asset Center/AssetManager 'API error' Unable to change the management type
Certain records in the 'Portfolio Items' table would no longer be consider with the new structure. Agent COverflowChangeAgent returned error: '54 integrity was not correctly applied (no additional information avalialble) Format error'
Element rejected due to rejection of a sub-element or an unrecoverable error.
Cause

The error happens when you are trying to insert/update a value that is not the existing one on Asset Manager.

For example: if you try to insert a nature into Asset Manager that contains the value 'Nothing' with a new value 'Single host'

It will displayed the error because the mapping is suggesting to update a field that does not make reference to the last value.

Fix

You can:

1. Change the data manually on Asset Manager

2. Correct the mapping going to Element Computer and remove the model