Update mobilink script on Sql Any Consolidated v 9 to 11

[Former Member]

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.

[Former Member]

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

[regdomaratzki]

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

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

[Former Member]

Reg, I have permission from my customer to send you the database I was using if you are still interested in seeing it.

[Former Member]

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.

[regdomaratzki]

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.

[regdomaratzki]

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.