SQL Anywhere Mobile - Error -193

Author

Error -193

Usmanov A.

2005-08-03, 3:25 am

Hi.
We use ASA 9.0.2 (3131).
I sow a strange error during download data to the remote database.
HotSync get an error -193
FAIL Adaptive Server Anywhere Conduit (SQLCODE = -193) 08/03/05 13:42:16
Primary key for 'ROSPOutlets' is not unique 08/03/05 13:42:16

Script for DownloadCursor return 3 records
OUTLET_ID,CONTR_ID,O
UTLET_NAME,OUTLET_AD
DRESS,OUTLET_IDD
4373,2966,'bla-bla-bla','bla-bla- bla','10027870000412
826'
4312,2923,'bla-bla-bla','bla-bla- bla','10027890003159
851'
4308,1912,''bla-bla-bla','bla-bla- bla','10027890003771
751'

Primary key for this table is OUTLET_ID and in download cursor they are
unique (4373,4312 and 4308).
What it means? Any ideas?

--

Best regards,
Alex Usmanov

David Fishburn

2005-08-08, 9:24 am

"Usmanov A." <alex_u@pochtamt.ru> wrote in news:42f0870f$1@foru
ms-2-dub
of sybase.public.sqlanywhere.mobilink:

UA> We use ASA 9.0.2 (3131).
UA> I sow a strange error during download data to the remote database.
UA> HotSync get an error -193
UA> FAIL Adaptive Server Anywhere Conduit (SQLCODE = -193) 08/03/05
13:42:16
UA> Primary key for 'ROSPOutlets' is not unique 08/03/05 13:42:16
UA>
UA> Script for DownloadCursor return 3 records
UA> OUTLET_ID,CONTR_ID,O
UTLET_NAME,OUTLET_AD
DRESS,OUTLET_IDD
UA> 4373,2966,'bla-bla-bla','bla-bla- bla','10027870000412
826'
UA> 4312,2923,'bla-bla-bla','bla-bla- bla','10027890003159
851'
UA> 4308,1912,''bla-bla-bla','bla-bla- bla','10027890003771
751'
UA>
UA> Primary key for this table is OUTLET_ID and in download cursor they
are
UA> unique (4373,4312 and 4308).
UA> What it means? Any ideas?

Is it possible you have a download_delete_curs
or and a download_cursor
for this table?
Do they both attempt to download the same values?

Please start ML using -vcrsn -ot ml.txt and post the output for a failed
sync.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Usmanov A.

2005-08-09, 3:25 am

Thanks for advice.
There is no other scripts defined for this table.
Log-file already is full.
Now this problem is obsolete (after full download of all data). I'm waiting
for next such collisions.
--
Best regards,
Alex Usmanov

Sponsored Links