Failed to load Cube: Palo Server not responding.

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.

ckosiegbu

Professional

Posts: 14

Date of registration: Apr 10th 2012

Sunday, August 12th 2012, 8:38pm

Failed to load Cube: Palo Server not responding.

Hi All,

Anyone know why this could be happening when I try to load a cube through ETL? The cube has 7 dimensions only. I'm trying to load an input file with about 20K rows. If I reduce the size of the file, it works. Can someone please advice on what to do? For example, parameters to tune?

2012-08-12 18:56:49,534 INFO : Using jpalo for communicating with palo olap server.
2012-08-12 18:56:49,550 INFO : Starting execution of job LOAD_REPORTING_CUBE
2012-08-12 18:56:49,550 INFO : Execution Parameters: #logLimit:100 ; #failOnError:true
2012-08-12 18:56:49,566 INFO : Starting load REPORTING_TXN of Cube Reporting
2012-08-12 18:56:49,566 INFO : Data retrieval from transform TXN_REPORTING_XFORM
2012-08-12 18:56:49,566 INFO : Data retrieval from extract TXN_DATA_REP_CUBE_EXT
2012-08-12 19:01:58,079 ERROR : Failed to load Cube Reporting: Palo Server not responding.

Regards,

CK

Go to the top of the page

tish1

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

Monday, August 13th 2012, 9:38am

Hi,

ETL Server obviously gets a timeout. 5mins is default. Within this time, ETL Server is not able to read your input file. So changing the timeout should help.

Regards.

Robert Tischler
Senior Consultant Vector SW DV GmbH

Unterstützung für Jedox und Palo Projekte - Jedox und Palo Schulungen in Wien - Vector Blog auch über Jedox und Palo

Go to the top of the page

ckosiegbu

Professional

Posts: 14

Date of registration: Apr 10th 2012

Monday, August 13th 2012, 11:45pm

Quoted from "tish1"

Hi,

ETL Server obviously gets a timeout. 5mins is default. Within this time, ETL Server is not able to read your input file. So changing the timeout should help.

Regards.

Hi,
Thanks for the reply. Can you tell me where to make this change please?
Regards,
CK

Go to the top of the page

jjunek

Jedox Team

Posts: 57

Date of registration: Sep 16th 2009

Location: Prague

Occupation: PALO OLAP Server architect

Tuesday, August 14th 2012, 11:31am

Hi CK,

the normal load shouldn't take so long with 20k records.
here are most usual cases why load is slow:
1. loading values when rules with markers are activate
2. loading 0 values
3. splashing
or combination of any these cases. If you can try to eliminate them

regards

Go to the top of the page

tish1

Sage

Posts: 762

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

Wednesday, August 15th 2012, 7:36am

Quoted from "ckosiegbu"

Thanks for the reply. Can you tell me where to make this change please?

I think in components.xml

Robert Tischler
Senior Consultant Vector SW DV GmbH

Unterstützung für Jedox und Palo Projekte - Jedox und Palo Schulungen in Wien - Vector Blog auch über Jedox und Palo

Go to the top of the page

ckosiegbu

Professional

Posts: 14

Date of registration: Apr 10th 2012

Wednesday, August 15th 2012, 11:48am

Quoted from "tish1"

Quoted from "ckosiegbu"

Thanks for the reply. Can you tell me where to make this change please?

I think in components.xml

Thanks Robert, I sent you a private message. Could you please send me an email address/number to reach you on?

Regards,

CK

Go to the top of the page

aschaef2

Intermediate

Posts: 5

Date of registration: Jun 25th 2011

Location: Cologne

Thursday, April 25th 2013, 8:53am

@ Mr Tischler:
Where do I find this file "components.xml" to change the time out time ?

I do have the same error message:
Cannot import Data into Cube ABC: Failed to initialize cube Lidis: Failed to open OLAP connection ABC. Please check your connection specification. Palo Server not responding.

Regars,
AS