You are not logged in.

PaloException: 5000 cube not found

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.

Robert

Trainee

  • "Robert" is male
  • "Robert" started this thread

Posts: 1

Date of registration: Aug 25th 2008

Location: Netherlands

  • Send private message

1

Monday, August 25th 2008, 10:33pm

PaloException: 5000 cube not found

I'am using ETL Server 1.1. on Windows and I am trying to load a flat by using the xml-interface. All dimensions are created and loaded successfully into the Palo database, including the creation of the cube. Except from this, I am getting a warning "PaloException: 5000 cube not found
cube not found in Cube Turnover". Result: Cube is empty.

I checked all the names of exports, pipelines etc.
Any Ideas?

Kind regards,
Robert

a_froehlich

Sage

Posts: 173

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

2

Wednesday, September 3rd 2008, 10:58am

RE: PaloException: 5000 cube not found

I'm not sure where this problem origins. Please try to restart the Palo Server, if this does not work try to use another name for the cube.

Regards, Andreas

rvanroon

Trainee

  • "rvanroon" is male

Posts: 3

Date of registration: Jun 28th 2007

  • Send private message

3

Thursday, September 4th 2008, 3:09pm

Thanks a lot Andreas. I de-installed the Palo-server and installed it again and the ETL-script started working. Then after a while I got same kind of warning.
Just stopping and starting the Palo-server was then enough to solve the problem.

What I also notice sometimes is that the Palo-icon, in the task-bar, disapears while the Palo-service is still running.

Kind regards,

Robert
Kind regards,
Robert van Roon.

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

4

Monday, September 15th 2008, 10:01am

Could you maybe attach the xml and (if not to large) the flat file you are importing from?
And could attach the log from the ETL process (in the /Logs-directory of the installation folder).

a_froehlich

Sage

Posts: 173

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

5

Friday, September 19th 2008, 8:17am

You could try to reduce the Bulk-Size for the Cube-Exports to Palo:
- Edit the File ./config/core/config.xml:
<parameter name="bulkSize">1</parameter>
Let us know if the problem still occurs.

rvanroon

Trainee

  • "rvanroon" is male

Posts: 3

Date of registration: Jun 28th 2007

  • Send private message

6

Thursday, October 2nd 2008, 2:39pm

Hi there, sorry for my late response. Got disconnected from the internet for several weeks. X(

Since I reconfigured the BulkSize I am not having this problem anymore. Thankx a lot.

Loaded some data via xml and figured out that I have only factdata at the lowest level of dimensions. As soon as I choose a consolidated level, I do not have factdata showing in my excelsheet.

Any idea. See screenshots.
rvanroon has attached the following file:
  • screenshots.zip (44.03 kB - 442 times downloaded - latest: Apr 3rd 2013, 3:02am)
Kind regards,
Robert van Roon.

This post has been edited 1 times, last edit by "rvanroon" (Oct 2nd 2008, 2:41pm)

rvanroon

Trainee

  • "rvanroon" is male

Posts: 3

Date of registration: Jun 28th 2007

  • Send private message

7

Monday, October 6th 2008, 3:21pm

I've got it !!
I defined the exports in my xml file with elementtype="text" which is wrong. Elements can't be consolidated as long as they are of type text.
Now my fact-data is calculated also on consolidated level.

Hoping to help anybody with same kind of error.
Kind regards,
Robert van Roon.
Rate this thread