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."
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..
The whole entity Yes
Thank You Its Worked
Worked perfectly, thank you!
Worked like a charm... Thanks!
Thanks! It worked