Exists in database as Long Integer (Autonumber) error
Question

I have received the error below. I created an User_Extended entity that extended the default system User entity. 


I created User_Extended entity primary key with the primary key of the Users primary key to create a one to one relationship but received this error. I must admit, this was the last entity that I created so I may have accidentally saved the attribute with it auto generated ID for my custom extended entity at one time prior.  

If I had access to SQL I probably could fix but wanted to know if there another way.

Any suggestions

Thanks!!


Error -

#Database Upgrade Error


Column 'OSUSR_PEX_USER_EXTENDED.ID' exists in database as Long Integer (Autonumber) but the new version is defined as Integer (INT). Database Autonumber columns can not be changed."



mvp_badge
MVP
Solution

Hi,

You initially published the entity with autonumber.

Cut the entity and then paste it again, that will enforce new table creation.

Regards,

Daniel

it worked for me as well, thank you

When he says cut, does he mean cut the entity arrtribute ( User_Extended ID in this) and then paste it on the the same entity? Or does he mean cut and the whole entity (User_Extented) and paste it on on the Database? your help would be appreciated..

Worked like a charm... Thanks!

Thanks! It worked

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