Column exists in database as Integer (int)
Application Type
Service Studio Version
11.54.26 (Build 62807)

I have seen the other solutions for this (cut entity and paste) and was able to use it on other entities however I don't know where the userprofile entity is and have no idea how it got changed.

Database Upgrade Error | Column 'OSUSR_M66_USERPROFILE.ID' exists in database as Integer (int) but the new version is defined as Integer (Autonumber). Database int columns can not be changed to Autonumber.


I ended up just closing the module and reopening which brought up the latest version. I lost my changes but they were minor. Leaving this in case anyone else runs into a similar issue.

Hi Paula,

You can Right click the Database element and select "Add Dependency":

Then you can search for "USERPROFILE" and see from which module this entity is:

Once you find the entity, you can delete the data on it and the database upgrade will work. Since there won't be data there to break the attribute conversion process.

I hope this helps you :)

Best regards,


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.