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. |
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. |
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.