You are not logged in.

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

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

patrickgumball

Intermediate

  • "patrickgumball" started this thread

Posts: 12

Date of registration: Dec 6th 2011

  • Send private message

1

Tuesday, December 6th 2011, 3:35pm

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!

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

2

Thursday, December 8th 2011, 12:45pm

Hi,
Did you try restarting the services? Any error messages in olap server log during startup?

patrickgumball

Intermediate

  • "patrickgumball" started this thread

Posts: 12

Date of registration: Dec 6th 2011

  • Send private message

3

Sunday, December 11th 2011, 2:59pm

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

patrickgumball

Intermediate

  • "patrickgumball" started this thread

Posts: 12

Date of registration: Dec 6th 2011

  • Send private message

4

Monday, December 12th 2011, 10:11am

Quoted from "patrickgumball"

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!

patrickgumball

Intermediate

  • "patrickgumball" started this thread

Posts: 12

Date of registration: Dec 6th 2011

  • Send private message

5

Tuesday, December 13th 2011, 10:57am

I did a reinstall and now it's working fine like before...

Thanks anyway.

spierrard

Trainee

Posts: 3

Date of registration: Nov 3rd 2011

  • Send private message

6

Monday, December 19th 2011, 9:32am

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

BMWTouring

Intermediate

  • "BMWTouring" is male

Posts: 9

Date of registration: Apr 1st 2012

Location: Netherlands

  • Send private message

7

Thursday, May 3rd 2012, 10:29pm

Error

Ì have the same error in version 3.2. It looks like the MOLAP can't start anymore. error code: 2002 Strange and buggy

laloune

Sage

Posts: 216

Date of registration: Dec 2nd 2009

Location: Berlin

Hobbies: Born to work :-)

  • Send private message

8

Tuesday, May 8th 2012, 8:42am

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

"To understand recursion, one must understand recursion"

BMWTouring

Intermediate

  • "BMWTouring" is male

Posts: 9

Date of registration: Apr 1st 2012

Location: Netherlands

  • Send private message

9

Thursday, May 10th 2012, 9:27pm

Its all there. Everytime I have to install the product again. Then it works.....looks like buggy product. To bad because I really loved the functionality and posiibilities.

laloune

Sage

Posts: 216

Date of registration: Dec 2nd 2009

Location: Berlin

Hobbies: Born to work :-)

  • Send private message

10

Thursday, May 31st 2012, 5:44pm

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

"To understand recursion, one must understand recursion"

bloger7791

Beginner

  • "bloger7791" is male

Posts: 1

Date of registration: Oct 19th 2012

Location: Moscow

Occupation: Freelancer

Hobbies: Cars

  • Send private message

11

Friday, October 19th 2012, 2:53pm

I have the same problem

Similar threads

Rate this thread