on 2019 Feb 05 4:52 AM
Hi All,
There is a database created under server SA 12.0.1.4134, you need to convert it for server SA 17.0.9.4913.
When trying to unload it into a file (reload.sql + *.dat) using the utility
C:\\SQLANY17\\Bin64\\dbunload -up -c "uid=dba;pwd=sql;dbf=d:\\test" unload
I get an error message
SQL Anywhere Unload Utility Version 17.0.9.4913 Connecting and initializing ***** SQL error: Procedure 'sa_exec_script' not found
Question: How to fix it so that I could convert the base for the new version of the server ?
Request clarification before answering.
Found the reason for this error. In my database, the user "dba" for some reason was not included in the group "PUBLIC". As soon as I added it to this group, dbunload immediately began to work without this error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Stalker: Glad you found the issue. I marked your answer as accepted, alright?
I used the rebuild method "2217114 - How to upgrade to SQL Anywhere 17" and it worked for me:
call "%SQLANY17%\\bin64\\dbunload" -c "UID=DBA;PWD=sql;dbf=D:\\test\\dbname.db" -an "D:\\test\\Rebuild\\dbname.db"
Connect to the new DB "D:\\test\\Rebuild\\dbname.db" and execute:
select @@version and sp_disk_info (for example, this is a new sp in V17) to be sure you are in 17 version.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.