I have discovered that it is possible to corrupt a Palo database via loading a new dimension via ETL. When the data is corrupted, anytime that the database is accessed, the Palo server will crash. To avoid this problem, when loading a new dimension from a csv text file, or a MySQL relational database or another Palo database, or any other source, ensure that the options matches with the data being loaded (refer screenshot below). Try to avoid using options with the default mode. In my case, I was loading a dimension from another Palo database, and in that dimension, one of the elements had attributes, but the rest did not. This resulted in an error when the ETL loaded the first element with the attribute, but could not properly load the other elements that did not have attributes. Read on about my approach to correct a corrupted database.

We can actually use PALO Spreadsheet to communicate to mySQL, although there are only limited functions available. And of course, being PALO, there is no documentations what-so-ever on this. What I'm going to blog this time is an example on how to access mySQL database from a PALO Spreadsheet. Here goes.

1. Create a new Spreadsheet.

Sebagai pengguna blog Wordpress, menguruskan komentar dan membalasnya adalah sangat mudah, Namun, bagaimana jika anda boleh menguruskan dan membalas komentar dari desktop anda?

WP Komen Notifier adalah sebuah aplikasi open source yang ditulis dalam QT / C++ untuk Linux dan Windows, yang membolehkan anda untuk mengurus komentar baru dan membalasnya dari desktop anda. Selain itu, ia berupaya memudahkan kerja anda untuk mengedit, memadam spam ataupun komentar.

The leave page confirmation has been implemented in Palo ramp-up version. It is triggered by javascript event handler onbeforeunload. The JavaScript window.onbeforeunload() event is fired just before the web page is unloaded.

Google now hosted full range data visualization API.

To take a look what Google Visualization API, pls visit http://code.google.com/apis/ajax/playground/#geo_map

Note: geo map chart, unlike regular Google Maps could visualize a heat map. 

This is a short guide on how to allow access to Palo on ports 7777 and 85 via the iptables firewall for Centos 5 or RedHat Enterprise Linux 5 via a terminal interface. This is only necessary if you cannot connect to the server ports when browsing. Port 7777 is necessary for accessing Palo OLAP, while port 85 is necessary for the Palo Web Administration. In the following instructions, a '#' means a terminal prompt.

This error occured when you try to start palo. It appear a few second after start script executed.

Error:
chinook-bin: extlibs/boost/include/boost/thread/pthread/condition_variable.hpp:29: boost::condition_variable::~condition_variable(): Assertion `!pthread_cond_destroy(&cond)' failed.

It seems that here is the place for ‘HOW TO’ to everyone to share informative knowledge. Well I have something to share as well. It is about ‘How To Grab A Data or Anything From Website using Xpath’.

If in case you have no other solutions (whereas your clients couldn’t provide you not even a single source of data that might be important to your project), but they only have a website that they could provide. Do not worry; I have the solution on that.

Step #1 : Installation