SQL Anywhere Mobile - Remote Savepoints Not Supported

Author

Remote Savepoints Not Supported

Mark Hampton

2005-03-30, 9:43 am

ASA 9.0.2.2451, Mobilink 9.0.2.2451. Consolidated database has proxy tables
that connect to another ASA 9.0.2.2451 database for the data storage.

While upgrading our ASA 8.x to ASA 9.x, we just noticed this error now when
performing a synchronization:

E. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]General error: Feature 'remote savepoints'
not implemented (ODBC State = HY000, Native error code = -134)
E. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error: Unable to insert into table
'shipping_header' using upload_insert
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error Context:
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: User Name: XP-SANDREWS
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Modified User Name: XP-SANDREWS
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Transaction: upload
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Table Name: shipping_header
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Insert Row:
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: XP-SANDREWS-1
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 82945649544324882
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 2005-03-28
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: TS
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 107
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Y
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NEW
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Y
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: XP-SANDREWS
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Script Version: v1.1_13
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Script: call
ml_insert_shipping_h
eader( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: End of Error Context

Any ideas?

I used scripts to create the databases from scratch using DBINIT (for asa
9). The server is created as class 'asaodbc'.

Reg Domaratzki $iAnywhere Solutions$

2005-03-30, 9:43 am

You'll want to apply the v902.3044 patch from the download site referenced
in my footer.

ML Bug Fix: (QTS 377471) Synch could fail with "Feature 'remote savepoints'
not implemented"
Versions fixed : 902.3022, 901.1977, 803.5209

Customer Description:
When using proxy tables a synch could fail with the message "Feature 'remote
savepoints' not implemented". This has been fixed.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Mark Hampton" <mhampton. removeme@datavantage
corp.com> wrote in message
news:424855f4@forums
-1-dub...
> ASA 9.0.2.2451, Mobilink 9.0.2.2451. Consolidated database has proxy
tables
> that connect to another ASA 9.0.2.2451 database for the data storage.
>
> While upgrading our ASA 8.x to ASA 9.x, we just noticed this error now
when
> performing a synchronization:
>
> E. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error: [-10002] ODBC:
[Sybase][ODBC
> Driver][Adaptive Server Anywhere]General error: Feature 'remote
savepoints'
> not implemented (ODBC State = HY000, Native error code = -134)
> E. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error: Unable to insert into table
> 'shipping_header' using upload_insert
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Error Context:
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: User Name: XP-SANDREWS
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Modified User Name: XP-SANDREWS
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Transaction: upload
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Table Name: shipping_header
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Insert Row:
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: XP-SANDREWS-1
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 82945649544324882
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 2005-03-28
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: TS
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: 107
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NULL
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Y
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: NEW
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Y
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: XP-SANDREWS
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Script Version: v1.1_13
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: Script: call
> ml_insert_shipping_h
eader( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> I. 03/28 13:59:50. <1.5> [XP-SANDREWS]: End of Error Context
>
> Any ideas?
>
> I used scripts to create the databases from scratch using DBINIT (for asa
> 9). The server is created as class 'asaodbc'.
>
>
>

Mark Hampton

2005-03-30, 9:43 am

OK... Do I need to apply the patch to all levels (e.g., handheld and
desktop) or just to the desktop. (I'm assuming the latter, since that is
where Mobilink is running, and the fixed case appears under the heading
Mobilink).

Thanks.

Actually, this brings up a comment: It sure would be nice to have a way to
search the fixed problems database other than searching through the readmes
for each release.

"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:42496c3d@forums
-1-dub...
> You'll want to apply the v902.3044 patch from the download site referenced
> in my footer.
>
> ML Bug Fix: (QTS 377471) Synch could fail with "Feature 'remote
> savepoints'
> not implemented"
> Versions fixed : 902.3022, 901.1977, 803.5209
>
> Customer Description:
> When using proxy tables a synch could fail with the message "Feature
> 'remote
> savepoints' not implemented". This has been fixed.
>
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "Mark Hampton" <mhampton. removeme@datavantage
corp.com> wrote in message
> news:424855f4@forums
-1-dub...
> tables
> when
> [Sybase][ODBC
> savepoints'
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-03-30, 9:43 am

This patch only needs to be applied where MobiLink is running.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Mark Hampton" <mhampton. removeme@datavantage
corp.com> wrote in message
news:42497d09$1@foru
ms-1-dub...
> OK... Do I need to apply the patch to all levels (e.g., handheld and
> desktop) or just to the desktop. (I'm assuming the latter, since that is
> where Mobilink is running, and the fixed case appears under the heading
> Mobilink).
>
> Thanks.
>
> Actually, this brings up a comment: It sure would be nice to have a way to
> search the fixed problems database other than searching through the
readmes
> for each release.
>
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> wrote in message news:42496c3d@forums
-1-dub...
referenced[color=dar
kred]
asa[color=darkred]
>
>

Sponsored Links