Error -11149 Cannot save instance to storage


Problem

When trying to change a project property, user gets error -11149, Cannot save instance to storage (instance id ...,class id....,class name...)

Solution

The problem was with id columns in the database that were set as a numeric data type and should have been int.  problem occured after incorrectly converting database from Oracle to SQL

PROJECTTYPEID needs to be an int NOT a numeric data type
UNIQID needs to be an int NOT a numeric

Example query to fix a particular table:
alter table I_CTDOT_BRIDGE_BEN alter column PROJECTTYPEID int;

user should always backup database before altering the database

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!