Failed to create [CMM000030]

Document ID : KB000006852
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When creating or updating an Asset group following error occurs

 

"Failed to create [CMM00030]"

"ADO Version 6.3 - ExecuteCommandPointer  -COM Error: ErrorCode:-2147217833,WordErrorCode:3159, IDispatch error #3159, Arithmetic overflow error converting expression to data type int., Microsoft SQL Server Native Client 11.0, (null)"

 

cmm000030.jpg

 

 

Cause:

This error occurs when a value for a column modify_version of SQL table usd_class_version has reached the integer limit 2147483647

In case of Group creation/update problem is with row : name = 'asset_grp'

 

So following query like is generating this SQL error :

update usd_class_version set modify_version = modify_version +1 where name = 'asset_grp' 

 

 

Example :

If we execute this SQL request we could reproduce the error :

update usd_class_version set modify_version = 2147483648 where name = 'asset_grp' 

 

Capture.JPG

 

 

 

Resolution:

The solution is to reset modify_version to 0 for asset_grp row of table usd_class_version in mdb database :

 

update usd_class_version set modify_version = 0 where name = 'asset_grp'