Palo OLAP Server doen't start anymore with no reasons...

    Palo OLAP Server doen't start anymore with no reasons...

    Hello, until yesterday everything worked fine, I was able to use Palo Web on Windows XP and Palo for Excel (community edition version 3.2.0.5160). Today I couldn't get anything working because if I try to log in with the usual admin\admin on palo web I got this message:

    ERROR: Config database missing or invalid!


    Then I checked my C:\Programmi\Jedox\Palo Suite\log\olap_server.txt log file and this is what I can read:



    2011-12-06 15:20:05 INFO: user 'admin' logged in
    2011-12-06 15:20:05 WARNING: error code: 2002 description: database not loaded message: database not loaded

    Has anyone any idea of why did it happen and, more important, how to solve this issue?

    I really need to get my olap server back ASAP!

    Thank you very much!

    patrickgumball wrote:

    Yes and I also tried to restart the machine itself... But always the same problem!
    If I'll perform a uninstall will I loose my ETL project?

    Any other suggestions?

    Thanks
    This is the OLAP Server log file: seems like the 'Config' database is missing... how can I restore it?

    Source Code

    1. 2011-12-12 09:42:42 INFO: starting Palo 3.2.1 (2227)2011-12-12 09:42:43 INFO: registered system database 'System'2011-12-12 09:42:43 INFO: registered user info database 'Config'2011-12-12 09:42:43 INFO: registered database 'Demo'2011-12-12 09:42:44 INFO: registered user info database 'fgrp1'2011-12-12 09:42:44 INFO: registered user info database 'fgrp2'2011-12-12 09:42:44 INFO: system database not yet loaded, loading now2011-12-12 09:42:48 INFO: auto loading database 'Config'2011-12-12 09:42:48 INFO: created CubeDimension2011-12-12 09:42:49 ERROR: cannot load database 'Config'2011-12-12 09:42:49 WARNING: cannot load database 'Config'2011-12-12 09:42:49 WARNING: message 1: dimension not found2011-12-12 09:42:49 WARNING: message 2: parameter 'dimension identifier' value '17'2011-12-12 09:42:49 INFO: auto loading database 'Demo'2011-12-12 09:42:49 INFO: created CubeDimension2011-12-12 09:43:05 INFO: setting client cache type to 02011-12-12 09:43:05 INFO: setting hide elements to 02011-12-12 09:43:05 INFO: auto loading database 'fgrp1'2011-12-12 09:43:05 INFO: created CubeDimension2011-12-12 09:43:05 INFO: setting client cache type to 02011-12-12 09:43:05 INFO: setting hide elements to 12011-12-12 09:43:05 INFO: auto loading database 'fgrp2'2011-12-12 09:43:05 INFO: created CubeDimension2011-12-12 09:43:07 INFO: setting client cache type to 02011-12-12 09:43:07 INFO: setting hide elements to 12011-12-12 09:43:07 INFO: rebuilding all markers2011-12-12 09:43:07 INFO: sorting all cube pages2011-12-12 09:43:07 INFO: user login is required2011-12-12 09:43:07 INFO: http port '7921' on address '127.0.0.1' open2011-12-12 09:43:07 INFO: starting to listen2011-12-12 09:43:08 INFO: Service started succesfully.2011-12-12 09:43:17 INFO: user '_internal_suite' logged in2011-12-12 09:43:18 WARNING: error code: 2002 description: database not loaded message: database not loaded


    Thanks!

    I have the exact same problem

    I had to restart the instance on which palo was running. It went fine for a couple of hours and then I got the same "Config database missing or invalid" error.
    We reinstalled palo (different directory, same instance), it worked for a few hours and then, the Config database error again.
    Any idea what could cause the problem (and how to fix it)?
    Hi,

    from my experience, sometimes database files get corrupted, and the end of the file is truncated.

    check whether the file end with the following statements:
    - PALO CUBE DATA END (for cube files)
    - PALO DATABASE DATA END (for database.csv file)

    hope this helps
    laloune

    Post hoc, non est propter hoc
    well, it does not come necessarily from Palo, . The problem for me was due to a system crash (on windows, not linux), and I guess that the memory state could not be correctly commited, and as a result, ran into corrupted files.

    On which OS are you running your server ? Are you sure about the amount of ram ?
    laloune

    Post hoc, non est propter hoc