Error Opening the Database....

Dommel
Dommel Member Posts: 8
edited 2009-03-09 in NAV/Navision Classic Client
While opening the table in database(Native which is NAV v4.0 SP3) its showing error as



Other Concurrent activities have reused te available space in the database that contained your snapshot of data. This can occur in connection with time-consuming task such as printing or making backups.
If this occurs often ou should create more available space in the database by

*Expanding the database
*Deleting unnecessary data
* Date compressing older, non-concurrent entries.
*Optimizing the database.

Comments

  • DenSter
    DenSter Member Posts: 8,307
    Go to File, Database, Information and check the Database tab. If the Database Used is full, you need to expand the database to make some room. It is recommended to have at least 15% free space.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Dommel
    Dommel Member Posts: 8
    I cannot expand..

    the only option available is NEW and OPEN.
  • slmaluwa
    slmaluwa Member Posts: 366
    Dommel wrote:
    I cannot expand..

    the only option available is NEW and OPEN.

    That means, the DB is not opened by the client. This happened many times to me and I feel that the DB is corrupted. Our partner was not able to give a solution.

    It was always an easy task for me to restore from the last backup.

    Good luck!
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • KYDutchie
    KYDutchie Member Posts: 345
    Dommel,

    you have to open the database first before other options become available.
    So first open the database, then click file->Database -> Information.

    Regards,

    Willy
    Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.
  • Dommel
    Dommel Member Posts: 8
    That's the problem i cannot open the database...

    the only option available is NEW...
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Dommel wrote:
    That's the problem i cannot open the database...

    the only option available is NEW...

    You need to be on the machine where the database is, if its on the server then go to that machine.

    Make sure the server.exe service is STOPPED.

    Run Nav and go File database Open.
    Blank out the server

    Then browse to the database and open it.

    Now you can expand the database.

    if not DESCRIBE THE ERROR.
    David Singleton
  • slmaluwa
    slmaluwa Member Posts: 366
    hi
    Please let us know whether David Singleton's suggestion works.
    Because, we have had this issue many times and never been able to open it to expand.
    If I remember correctly, I tried to open on server machine also. But, I don't remember STOPPING the service.

    Ultimately, we had to restore from the backup.
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • Savatage
    Savatage Member Posts: 7,142
    slmaluwa wrote:
    we have had this issue many times

    Are you doing anything different now to prevent this?
    Was it a corrupt database or out of database space?

    I check ours weekly.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • slmaluwa
    slmaluwa Member Posts: 366
    Savatage
    I feel that this happened mainly due to network failures and I think that the DB was corrupted.
    I also feel that the service was not properly shutdown before server is down.

    We now have adopter better server/data center maintenance and always maintain at least 40% free space in the DB.
    Also, a weekly optimization of tables. Still using native DB with 35GB in size.
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • Savatage
    Savatage Member Posts: 7,142
    I hear you, we're native @ 30GB would be much more if we kept our pictures internally
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Dommel
    Dommel Member Posts: 8
    Hi David.

    Thanks for the reply.

    But it's still the same.... still cannot open the database.
  • garak
    garak Member Posts: 3,263
    Do you run some backup tools to create fbk at this time or is there a process that "rebuild" the database from a backup?
    Can you connect to the database if you open it "local" ? Has some other user the database open local?
    Do you make it right, it works too!
  • lubost
    lubost Member Posts: 633
    Hi,

    I think that David meant theat you should open database via the file (your picture shows empty file field). The reason to stop service may be that Navision tries to find database via TCP.
    I recommend you to erase ZUP file before any action.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Dommel wrote:
    I cannot expand..

    the only option available is NEW and OPEN.

    Dommel wrote:
    Hi David.

    file.php?id=45&mode=view
    ... still cannot open the database.


    If the opnly option is NEW, then how di you get to this prompt.

    You have two options, either do it your way, or follow advise.

    Follow the steps one at a time, and have some own watch you to make sure you are really doing them.
    David Singleton wrote:
    Dommel wrote:
    That's the problem i cannot open the database...

    the only option available is NEW...
    David Singleton wrote:
    You need to be on the machine where the database is, if its on the server then go to that machine.

    Make sure the server.exe service is STOPPED.

    Run Nav and go File database Open.
    Blank out the server

    Then browse to the database and open it.

    Now you can expand the database.

    if not DESCRIBE THE ERROR.

    There is a bug in NAV, how can people help you if you refuse to listen to advise. ](*,)
    David Singleton
  • Dommel
    Dommel Member Posts: 8
    Hi David,

    I followed every step that you said.

    the only option in the database is OPEN and NEW.

    but still the same i cannot open the database.

    thanks anyway for the help.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Dommel wrote:
    Hi David,

    I followed every step that you said.

    the only option in the database is OPEN and NEW.

    but still the same i cannot open the database.

    thanks anyway for the help.

    Ok, lets do this step by step.

    Step 1. STOP THE SERVER. If you don't know how to stop the server then ask how to stop the server.
    David Singleton
  • Savatage
    Savatage Member Posts: 7,142
    Not to confuse, so if it does then ignore this post. You posted a picture of how you were connecting to the database with no file name listed.
    Stop the service.
    I believe the thought would be open the client that is installed on the server
    Open the database directly & try to File->database->Expand
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • sudhakarsv
    sudhakarsv Member Posts: 100
    I have encountered the same problem while opening the database locally/server mode.
    below chekings i have done
    1.Cleared the all sessions
    2.Killed the other logins from the Task manager
    3.reinstalled the Navision Client

    any suggestions...
    Regards,
    S.V.Sudhakar

Categories