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
asked 09 Mar '12, 10:08
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