| Author |
9.0.2.3137 A dbspace has reached its maximum file size
|
|
| Dave Joyner 2005-09-07, 8:23 pm |
| I'm getting this error and I'm not sure why. I moved the sync to a desktop
machine thinking that it was a limitation of the device but get the same
result.
I tried reserve_space with about double the size needed for the sync
(15MB) -- no help.
The asa manual says:
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.
What have I missed ?
Thanks
Dave Joyner
| |
| Tom Slee 2005-09-07, 8:23 pm |
| Dave Joyner wrote:
> I'm getting this error and I'm not sure why. I moved the sync to a desktop
> machine thinking that it was a limitation of the device but get the same
> result.
>
> I tried reserve_space with about double the size needed for the sync
> (15MB) -- no help.
>
> The asa manual says:
>
> 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.
>
> What have I missed ?
>
> Thanks
> Dave Joyner
>
>
UltraLite reuses the ASA error codes, but sometimes the meanings are a
bit different. The most likely issue in this case is that you have run
into UltraLite's maximum row limit, which is 65535 rows in a table.
Tom Slee
iAnywhere Solutions
| |
| Dave Joyner 2005-09-07, 8:23 pm |
| Duh. I didn't check the download_cursor query before bothering you.
Thanks
"Tom Slee" <Tom.Slee@ianywhere.com> wrote in message
news:431f3852$1@foru
ms-1-dub...
> Dave Joyner wrote:
>
> UltraLite reuses the ASA error codes, but sometimes the meanings are a bit
> different. The most likely issue in this case is that you have run into
> UltraLite's maximum row limit, which is 65535 rows in a table.
>
> Tom Slee
> iAnywhere Solutions
| |
| Jonathan Chapman 2005-09-14, 8:24 pm |
| I have the same issue.
Are there any work arounds that people can suggest.
Thanks,
Jonathan
"Tom Slee" <Tom.Slee@ianywhere.com> wrote in message
news:431f3852$1@foru
ms-1-dub...
> Dave Joyner wrote:
desktop[color=darkre
d]
usually[color=darkre
d]
error.[color=darkred]
>
> UltraLite reuses the ASA error codes, but sometimes the meanings are a
> bit different. The most likely issue in this case is that you have run
> into UltraLite's maximum row limit, which is 65535 rows in a table.
>
> Tom Slee
> iAnywhere Solutions
| |
| Tom Slee 2005-09-15, 9:23 am |
| Jonathan Chapman wrote:
> I have the same issue.
>
> Are there any work arounds that people can suggest.
>
> Thanks,
> Jonathan
>
> "Tom Slee" <Tom.Slee@ianywhere.com> wrote in message
> news:431f3852$1@foru
ms-1-dub...
>
>
> desktop
>
>
> usually
>
>
> error.
>
>
>
>
There are three ways to deal with this problem:
- Examine your synchronization logic to see if you can cut down what is
stored in the UltraLite table. This has the benefit of giving
performance improvements at the same time and in many cases is the best
way to go.
- Split the data into two tables. Perhaps split by date or depends on
your logic.
- Wait for the next major release of UltraLite, in the SQL Anywere
Studio Jasper edition, which will not have this limitation.
Tom Slee
iAnywhere Solutions
|
|
|
|