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

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • 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)?
  • 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