cancel
Showing results for 
Search instead for 
Did you mean: 

Update mobilink script on Sql Any Consolidated v 9 to 11

Former Member
1,668

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
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

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.