Error: Arithmetic overflow error converting IDENTITY to data type int.

[Former Member]

HI,

We are getting this new error Arithmetic overflow error converting IDENTITY to data type int. while triggering any job in IDM Manifest IC. this is only happening for Manifest IC and not the approved IC.

Any job we try to trigger by clicking on run and this message will be shown and the job is not running.

This is happening just some time back and we thorugh this might be SQL DB issue and we also asked our server team to restart the server but that seems be not working.

Can any one please let us know if they have comes across this issue before and if yes please tell us how to resolve this.

Error is like this.

Arthmetic overflow error converting IDENTITY to data type int.

ADO errors:

1. Arthmetic overflow occured.

Method: Run now

Error: 80040E57h

Description: Arithmetic overflow error converting IDENTITY to data type int.

ADO errors:

1. Arthmetic overflow occured.

This is the message shown on the pop up window.

I am getting this error in Microsoft Management console.

Please give some resolution for this issue.

Let me know if you need any more information with this regards,

We are running IDM

SAP NetWeaver Identity Management

SAP AG

Version: 7.0

[Former Member]

Arun,

Check the target column size for each column you are trying to import.

Make sure the data types from the source and destination( database match )

I am thinking this can be a database issue because the database is not allowing the pass to get updated try working with DB administrator to increase the column size.

For example if someones Name is a large name in your records

DB may not be able to accept those records.

Also I was thinking you are passing a string(aplhanumeric) rather than a integer in one of the columns

Edited by: Franklin Jayasim on Jul 22, 2010 12:46 AM