Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error -604 Too Many Records Loaded?? Please Help!

2 posts in General Discussion Last posting was on 2003-06-23 03:02:33.0Z
Hegemon Posted on 2003-06-22 22:05:21.0Z
Reply-To: "Hegemon" <drichards@rxscan.tzo.com>
From: "Hegemon" <drichards@rxscan.tzo.com>
Subject: Error -604 Too Many Records Loaded?? Please Help!
Date: Sun, 22 Jun 2003 18:05:21 -0400
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <#hRNwtQODHA.279@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: dhcp9396004.columbus.rr.com 24.93.96.4
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1225
Article PK: 3469

I am using:
EVC 3.0 on Windows 2000 Host
Windows Pocket PC 2002 on a Toshiba e750 Client

Sybase Adaptive Server Anywhere Database Engine Version 8.0.2.4122
Adaptive Server Anywhere MobiLink Version 8.0.2.4122

Using C++ Ultralite Development Classes

I am attempting to load approx. 100,000 records into a table on my PPC
(reference database). I can load chunks of data
up to about 60,000 records, then I recieve the following error for MobiLink:

I. 06/22 17:43:20. <1.2> [drichards]: # rows downloaded to remote from table
NDC : 25000
E. 06/22 17:43:39. <1.2> [drichards]: Error: Download failed with client
error -604
I. 06/22 17:43:39. <1.2> [drichards]: ROLLBACK Transaction: end_download
I. 06/22 17:43:39. <1.2> [drichards]: end_connection <connection> (no
script)
I. 06/22 17:43:39. <1.2> [drichards]: COMMIT Transaction: end_connection
I. 06/22 17:43:39. <1.2> [drichards]: Disconnected from consolidated
database
I. 06/22 17:43:39. <1.2> [drichards]: Synchronization failed

This is defined as:
A dbspace has grown to its maximum number of disk pages, which is usually
limited by the maximum operating system file size. This is a fatal error.

So, I used
#define UL_STORE_PARMS UL_TEXT("cache_size=128K;file_name=\\Program
Files\\Rxscan Ultra\\Rxscan.udb;reserve_size=10m;page_size=8k");

which works, because it started the DB size @ 10MB in the new directory.

Same problem.

Is there a limitation to the number of records I can load into the *.udb
file?
Please help :(

Thanks.
Dan
drichards@rxscan.tzo.com


Shuchit Velkar Posted on 2003-06-23 03:02:33.0Z
Subject: Re: Error -604 Too Many Records Loaded?? Please Help!
From: Shuchit Velkar <xxx@xxx.net>
References: <#hRNwtQODHA.279@forums-2-dub>
Message-ID: <Xns93A2E91AC974BsvelkarNOsybaseSPAMc@192.138.151.106>
User-Agent: Xnews/5.04.25
Newsgroups: ianywhere.public.general
Date: Sun, 22 Jun 2003 20:02:33 -0700
NNTP-Posting-Host: CPE0080c6ee7d81-CM024340006571.cpe.net.cable.rogers.com 24.101.240.132
Lines: 7
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1226
Article PK: 3466

Please do not cross-post. I have replied to your post in the UltraLite
newsgroup.

--
Shuchit Velkar
iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.ianywhere.com/developer