Hi I try to upgrade from 6.0 to 12.0. During the upgrade, the following error occurs.
Compared with normal DATABASE, I made sure that the users & groups - dbo is in uppercase. Probably think this is the cause, I wonder if there is a way to fix this.
Resolved in version 6.0, if the DB rebuild, which takes too much time. Is there any other workaround?
================================================ SQL Anywhere Unload Utility Version 18.104.22.16869 Connecting and initializing Unloading user and group definitions Unloading table definitions Unloading index definitions Unloading functions Unloading view definitions Unloading procedures Unloading triggers Unloading SQL Remote definitions Unloading MobiLink definitions ***** SQL error: User 'PUBLIC' already has membership in group 'dbo'
I have experienced wierd messages during in-place upgrades. They were always caused by previous errors I had made which seemed to be functioning just fine in the old db (such as creating an index without an object name: worked fine in ASA 10 but not in 11).
I discovered the "real" problem by creating an script file with dbunload and then searching for the offending term (public or dbo in your case). Once I discovered the underlying error, I 1) fixed it in the original db and repeated the in-place upgrade, or 2) edited the unload script file and then executed it manually.
answered 11 Sep '12, 17:56