upgrade database from 6.0 to 12.0 SQL Anywhere

[Former Member]

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?

thanks

================================================
SQL Anywhere Unload Utility Version 12.0.1.3769
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'

[Former Member]

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.