You are not logged in.

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.

dominik_l

Jedox Team

  • "dominik_l" is male
  • "dominik_l" started this thread

Posts: 375

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

1

Monday, August 8th 2011, 10:29am

Palo 3.2 Community Edition - Release notes

Dear Palo Community,
as we are releasing the Palo 3.2 Community edition today, in addition to the What's new document, please have a look at the following notes for this release:

- for Updates of existing installations, we recommend uninstalling the old versions, then installing the new version into a fresh directory and afterwards migrating your databases and, for Palo Web, storage directories. As the System database has a partially changed structure,, we recommend using the new System database and migrating your existing Users / groups etc. "manually" (.e.g. via ETL)
- one of the new properties in the System DB is the "inactive" property for users groups and roles. While this property is needed internally for Palo Web, chaning the setting for a given User / Group / Role will NOT disable this user (this is only available in the Premium Edition)
- when installing Palo Web, the link in the Windows Start Menu will always point to the adress "http://localhost:8081", but you can manually edit the link
- when installing Palo for Excel, if you chose to leave the OLAP interface empty (=bind to all interfaces), the created default connection in the Excel-Addin will not work (it will not set a host adress). You can edit the connection via the Modeller.
- by default, Palo Web uses a Palo user called "_internal_suite" with the same password to connect to the OLAP server. We recommend changing this user's password, then adapting the necessary config files (palo_config.xml, config.php)
- there will not be a "Palo"-Ribbon in Excel version 2007 and 2010; you will find the Palo menu in the "Addins" ribbon
- the 64bit versions are "Premium only" and not included in the Open Source version. You can use the source code from SF.net to compile 64bit bianries.

Posts: 5

Date of registration: Aug 5th 2011

  • Send private message

2

Tuesday, August 9th 2011, 12:25pm

- there will not be a "Palo"-Ribbon in Excel version 2007 and 2010; you will find the Palo menu in the "Addins" ribbon
Is there a reason for this behavior? Personally, I really miss the ribbon in the new release...

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

3

Wednesday, August 10th 2011, 4:54pm

Problem with migrating from Palo Web 3.1 to 3.2

Hi Dominik,

"What`s new"-Information sound very pleasant.

However, migrating my database to new installation, I'm facing heavy problems.

# "Setup Guide" is different from your above recommendation - hopefully "Setup Guide" will follow reality.
# In first try, I did follow the "Setup Guide":
+ after stopping services from relevant folders a backup was made
+ in new installation folders from which I made a backup were deleted and backed folders copied into new installation
- result: web core service could not be started, access through web is not possible (as expected)
+ via "Palo for Excel" user "_internal_suite" was added
- view "#_user_user_properties" and "#_user_group" show no data, only #NV, so dead end is reached

# With second try I did follow your recommendation:
+ folder "palo/data/system" was deleted and original folder from 3.2-installation imported
+ access through web interface and "Palo for Excel" is working
- in "Palo for Excel" views can be inserted, but show no data (#NV)
- in "Palo Web" access to files from backup is not possible ("file is not existing"); creating new files (spreadsheets) fails

Any idea, how to migrate
- database
- files
- users and rights
economically (defining ETL import/export means work of about a week)
respectively what my mistake was?

Thank`s for assistance,

Mark

dominik_l

Jedox Team

  • "dominik_l" is male
  • "dominik_l" started this thread

Posts: 375

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

4

Wednesday, August 10th 2011, 5:39pm

Hi,

1) the "file doesn't exist" error means Palo Web can't locate the specific file you're trying to open. I see two possible causes, depending on wether or not you migrated the "storage" directory from your old installation:
a) storage directory was migrated. In this case I'd assume the reason is that the old installation had a different install path than the new one. The storage path is saved in the fgrp databases (which you migrated, I reckon) and thus, Palo Web still looks at the old place. What you can do:
- Move the storage directory to the old location (if necessary, create parent directories)
- try to open files
- if it works, you can again migrate storage to the new location (or some other) by changing the Properties of "root folders" in Palo Web Studio. (Note: changing path in those properties will only work if the currently set path is actually correct)

b) storage directory was not migrated. In this case:
- migrate storage to new installation.

Of course you could have c), being combination of a) and b) ;)

2) the #NV errors in Excel probably mean that something with Excel Addin installation didn't work correctly. You can check wether the log file (PaloXLAddin.log) contains errors.

dominik_l

Jedox Team

  • "dominik_l" is male
  • "dominik_l" started this thread

Posts: 375

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

5

Wednesday, August 10th 2011, 5:45pm

As for different migration method: you could try to write e.g. a php-script that creates new properties in the System database itself (this would mean the ste_...rights objects, and the "inactive" property for users / groups, and roles). This script would basically modify your existing System DB to work with the new version.

By the way: the setup guide only concerns the Update of older versions to the 3.2 Premium version, not the Community Version.

MJV

Master

  • "MJV" is male

Posts: 32

Date of registration: Aug 30th 2010

  • Send private message

6

Thursday, August 11th 2011, 8:21am

Good morning dominik,
thank you for quick answer. I have a look and will response.

Mark

vmikrin

Trainee

Posts: 2

Date of registration: Aug 26th 2011

  • Send private message

7

Sunday, October 9th 2011, 4:22pm

- there will not be a "Palo"-Ribbon in Excel version 2007 and 2010; you will find the Palo menu in the "Addins" ribbon
Is there a reason for this behavior? Personally, I really miss the ribbon in the new release...
Dear Dominik,

Please reply to this question. I also confused with absense of ribbon in new release..

Thank you.

  • "realquo" is male

Posts: 267

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

8

Monday, October 17th 2011, 8:03pm

Seconded

  • "Pommie" is male

Posts: 412

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

  • Send private message

9

Tuesday, March 6th 2012, 5:18pm

And rather late - thirded.

The open source version originally seemed like a great way to get people to work with Palo and see how good it can be. That seemed like a reality when I first began to use the product 3 years or so ago.

Now it the O/S version seems like a very poor relation.
Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

Posts: 87

Date of registration: Dec 2nd 2007

  • Send private message

10

Wednesday, March 7th 2012, 12:05pm

I agree with Pommie. CE is very important point on decision process to commercial Jedox version. I hope the new CE version will be as soon as possible. 30 day test on Jedox is not enough to develop some first usable part of supporting system for controlling for example. It is better to see and to show how good it is, how reliable and then makes sense to invest into Jedox commercional version. We will see....

Lubomir Divis
www.ei-advisor.com

bfrancis

Intermediate

Posts: 16

Date of registration: Nov 13th 2012

  • Send private message

11

Wednesday, December 12th 2012, 10:11am

The open source version is definitely due for an update soon!

Similar threads

Rate this thread