Palo 3.2 Community Edition - Release notes

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

  • 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 to compile 64bit bianries.
  • 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,

  • 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.
  • 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.
  • 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
  • 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