Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Error in SQL!!!!!!!!!!!!!!!!!!!!!!!!!!!! Serious!!!
Thu, Jun 12 2008 7:57 AMPermanent Link

Roger Oliveira (Brazil)

Hi, I have one problem in one SQL:

Message: DBISAM Engine Error # 9479 The table 'tbHistorico' is full and cannot contain
any more data

What's wrong?

Table: TBHistorico
Size: 3.906.222 KB
Records: 20.833.147
Thu, Jun 12 2008 8:36 AMPermanent Link

"John Hay"
>  Hi, I have one problem in one SQL:
>
>  Message: DBISAM Engine Error # 9479 The table 'tbHistorico' is full and
cannot contain
> any more data
>
>  What's wrong?
>
>  Table: TBHistorico
>  Size: 3.906.222 KB
>  Records: 20.833.147
>

You need to enable large file support.  Check out the link below

http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=5&category=1&topic=5

John

Thu, Jun 12 2008 10:11 AMPermanent Link

"Eduardo [HPro]"
Roger

Your table reach the OS limit size (4 Gb). Follow the suggestion from John
Hay.

If you desire you can contact me (in Brazil too) directly by e-mail.

Eduardo

Sun, Jun 22 2008 10:12 PMPermanent Link

Dave
Hi

Are there any downsides or risks associated with enabling this option?

(It would seem a no-brainer, but then why is it not enabled by default?)

Thanks

d
Sun, Jun 22 2008 10:40 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< Are there any downsides or risks associated with enabling this option? >>

Windows 9x/ME will not work with this option, which is why it isn't enabled
by default.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jul 2 2008 4:08 AMPermanent Link

Dave B
I am curious if activating this option on an existing table will fix the problem?
Or does this need to be applied to new databases only?

Thanks


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Dave,

<< Are there any downsides or risks associated with enabling this option? >>

Windows 9x/ME will not work with this option, which is why it isn't enabled
by default.

--
Tim Young
Elevate Software
www.elevatesoft.com
Wed, Jul 2 2008 8:50 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Dave,

> Or does this need to be applied to new databases only?

No, you can change it at any moment you wish - it only changes the way
locking is performed, nothing is changed in the tables when you change this
setting. Just don't mix application or servers using different settings for
LargeFileSupport.

--
Fernando Dias
[Team Elevate]

Image