Full database, everytime i try to expand it

chrisxx83 · 2010-01-11

Hi
i have problem with my database. Everytime I try to expand it and open again, in one second it makes full again.
How can I check witch function makes that strange thing? (number of records in tables are correct)

ara3n · 2010-01-11

This is strange.

Could you put some more info on what version you are on. SQL or natvie db?

What steps do u take to expand the db?

Alex_Chow · 2010-01-11

I would stop any processing on the database before trying to expand it again.

chrisxx83 · 2010-01-11

ara3n wrote:

This is strange.

Could you put some more info on what version you are on. SQL or natvie db?

What steps do u take to expand the db?

NAV 5.0 SP1 PL, native

We crateded a copy of .fdb file and on our local computers problem still appear.
Steps:
1. We open the database
2. Expand it
3. Now database works quite fine ( we have some problems with keys in tables, but db size not increasing)
4. We close database
5. Open it again and get error about reaching space limit

Alex Chow wrote:

I would stop any processing on the database before trying to expand it again.

We work on local copies so all processes are stopped.
Thanks in advance for any help

Alex_Chow · 2010-01-11

chrisxx83 wrote:

Alex Chow wrote:

I would stop any processing on the database before trying to expand it again.

We work on local copies so all processes are stopped.
Thanks in advance for any help

Are you sure there aren't any processes that automatically start? Database does not expand by itself.

David_Singleton · 2010-01-12

This is a recurring bug in Navision. But it only happens on certain versions.

You need to switch the DB to read only and create a full backup. Then upgrade your executable to a later version. Check Waldo's blog to see what version you can upgrade to. You will want to find a version that made changes to the Native client (fin.exe). Now restore the database.

The error you had most likely came from a network error of some kind, so you also need to do a complete check of the network and alook for bad network cars, switches or cables. Its very important that you get this bit sorted.

David_Singleton · 2010-01-12

By the way, don't forget search, this bug has been discussed time and time again.

http://www.mibuso.com/forum/viewtopic.php?f=23&t=33802&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=28872&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=25330&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=20222&hilit=expand+database+error

Full database, everytime i try to expand it

Comments

Categories