Error converting database SQLA 9.0 to SQLA 17.0

[Former Member]

I am trying to upgrade the database being used by our client from SQL Anywhere 9.0 to SQL Anywhere 17.0

I followed the instructions provided on http://dcx.sap.com/index.html#sqla170/en/html/81591cfe6ce210149f0889139dc8d91f.html however I was faced with an error:

• ***** SQL error: Permission denied: you do not have permission to select from "SYSUSERPERM"
• An error occurred while attempting to unload the database 'C:\Users.......

Any one got any idea what might be wrong?

Kind regards,

Pau

[chris_keating]

You are using an user, MOSIAPPS, that does not have permissions to execute the view SYSUSERPERM. You should be using an user with DBA authority.

[Former Member]

Hi Chris.

Is there a way to add a DBA user to this database even without another DBA user access? This is because the DBA credentials were not documented five years ago and there seems to be no way for us to recover the DBA user for this database.

[Former Member]

Just to add to me inquiry, if I need to add a DBA user, that means I should only use SQLA 9 to do this, right? I could not add a DBA user using SQLA 17?

[former_member182948]

DBA authority is required for SQLA17 to read the old database.
However, MOSIAPPS did not have DBA authority.
If you can use another user with DBA authority, SQLA9 is not necessary.

[Former Member]

Hi Koichi.

Is there a way to add a DBA user to this database even without another DBA user access? This is because the DBA credentials were not documented five years ago and there seems to be no way for us to recover the DBA user for this database.

[former_member182948]

Unfortunately, I think that DBA authority is required to add DBA user.
BTW,
Would you tried connecting by the default DBA user?
(UID=DBA;PWD=sql)

[Former Member]

I have just tried connecting using those credentials, sadly I can't connect.

[chris_keating]

If you or your customer have a support plan, you may want to discuss this with support to see what options might be available.