cancel
Showing results for 
Search instead for 
Did you mean: 

Update mobilink script on Sql Any Consolidated v 9 to 11

Former Member
1,732

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

regdomaratzki
Product and Topic Expert
Product and Topic Expert

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.