Arithmetic Overflow Error adding Tagged Value

[Rakesh]

I have a large EA Project in MS SQL Server, with 700+ Requirements and have been using Tagged Values to add additional attributes to manage these.  However have not got to a stage when adding a Tagged Value get the following error:

"Microsoft  OLE DB Provider for SQL Server [-2147217833]
Arithmetic Overflow error converting IDENTITY to data type int"

Enterprise Architect 9.1.910 build (910)  Corporate Edition
Database version: 7.0
Version Date: Jan-31-2004
MS SQL: 2008 R2 Standard, build 10.50.1617

If a run the following SQL can see that the PropertyID & ObjectId have large numbers, even though there are only 10,000 records in the table:


SELECT  
a = Max(t_objectproperties.PropertyID)
, b = Min(t_objectproperties.PropertyID)
, c = Max(t_objectproperties.Object_ID)
, d = Min(t_objectproperties.Object_ID)
, e = Count(*)
FROM t_objectproperties

a = 2147483647      
b = -2146703681      
c = 2143811339      
d = -2141479829      
e = 10499

Is there a way to fix this ?

Thanks in advance

[qwerty]

I'd try to export the whole model as XMI and import it into a fresh repository. That will start over the object IDs from the beginning. Not sure whether it will solve the problem, but worth a try.

Note that you have to transport reference data additionally via Project/Model Im-/Export/Export Reference Data

However, you should send an official bug report (link at bottom of this page).

q.

[Rakesh]

Thanks have attempted this on a local EAP repository and the ID's were renumbered.  Will now do as a SQL Server Repository.

Only downside is that the auditing history is lost.

Have also logged this as a bug.