I upgraded my v 9.0.2 database to version 11.0.1 using dbunload -ar switch. This worked fine. I tried to run the script READ 'c:Program FilesSQL Anywhere 11MobiLinkupgrade9.0.2upgrade_asa.sql'; and received many errors. It looks like some tables are missing but mlserver seems to be running fine. Here is some of the code that failed. drop procedure ml_qa_stage_status_from_client go drop procedure ml_qa_staged_status_for_client go drop procedure ml_qa_handle_error go drop function ml_qa_get_agent_property go drop function ml_qa_get_agent_object_property go drop function ml_qa_get_agent_network_property go drop function ml_qa_get_message_property go drop view ml_qa_messages go drop table ml_qa_notifications go drop table ml_qa_status_history go and this code had the wrong number of inserts error. insert into #ml_qa_delivery (msgid,address,client,status,statustime,syncstatus) select md.msgid,md.address,md.client,md.status,md.statustime, md.syncstatus from ml_qa_delivery md go Thanks. asked 09 Mar '12, 10:08 jimboidaho |
These look like problems when upgrading the schema to support QAnywhere. If you're not using QAnywhere, these errors won't prevent other aspects of the ML Server from working. answered 09 Mar '12, 10:39 Reg Domaratzki |
What user ID did you use to run the MobiLink server upgrade script? Could you please follow the upgrade procedure described in the SA manual:
SQL Anywhere 12 - Changes and Upgrading » Upgrading to SQL Anywhere 12 » Upgrading MobiLink » Upgrading your consolidated database
Thanks
I'd be interested in trying to figure out why the upgrade failed for these objets though if you're willing to help out. I don't suppose you have a backup copy of the v902 consolidate database on whch you can re-run the
I have a copy but it is big 1.2 gig. I guess I could zip it up and ftp it to you.
I did follow the directions including logging in as dbo.
I did not try the upgrade steps described in the doc. However, I did not see any error, when I ran the upgrade script file with the DBA use ID. Could you please tell us what exact steps and commands you used to run the upgrade script file?
I upgraded the database using dbunload -ar.
GRANT CONNECT TO dbo IDENTIFIED BY password; logged into isqlc as dbo SETUSER "dbo"; READ 'c:Program FilesSQL Anywhere 11MobiLinkupgrade9.0.2upgrade_asa.sql'; GRANT CONNECT TO dbo
Reg, I have permission from my customer to send you the database I was using if you are still interested in seeing it.
I am not sure why my reply was hidden so I will post here.
Reg, I have permission from my customer to send you the database if you are still interested.
Yes, I'm still interested. E-mail me diretly and we'll sort out how you can send me the database. My direct e-mail is :
firstname.lastname@sybase.com, where you replace "firstname" and "lastname" with my actual first and last name.