Troubleshooting MonetDB for Instaview
Instaview loads ETL models, dimensional schema, and data in a MonetDB-based database. When a new Instaview project is created or an existing one is opened, the MonetDB server is started. Most issues that can occur relate to the way that Pentaho controls MonetDB.
Connection Errors
Connection errors sometimes occur if there are MonetDB port conflicts. This sometimes occurs if you have installed Instaview in the past using one method, then reinstalled it using a different method. Check the share.xml file and modify the MonetDB port number in the Agile BI section so that it is not 50000, but another number such as 50006. Exit from Instaview and Spoon and try to start them both again.
General Errors
The Monetdb server is started when a new Instaview project is created or an existing one is opened. The server is shutdown when the project is closed. Pentaho provides scripts to start and stop the server. These scripts are located in the data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/instaview/scripts directory.
For testing or debugging, these scripts can be run with no arguments passed in. However, defaults are used for parameters that are not passed in. Each operating system has different defaults, the configuration definitions in the previous examples drive the values passed in to these scripts when executed from within PDI/Instaview. When running the scripts, take care to pass in the correct values, otherwise the database may not start up properly. Open the script in a text editor before calling it to determine what parameters you might need. Here are some example paramaters. None of the parameters are required, but are key if you stray from the default configurations.
For Windows
startMonetDb.bat DB_NAME MONETDB_INSTALL_DIR
Parameter | Default Value |
---|---|
DB_NAME | pentaho-instaview |
MONETDB_INSTALL_PATH | MONETDB_INSTALL_DIR environment variable |
For Mac or Linux
./startMonetDb.sh DB_NAME DB_FARM_LOCATION MONETDB_CMD MONETDBD_CMD MONETDB_PORT PASSPHRASE
Parameter | Mac Default Value | Linux Default Value | Comment |
---|---|---|---|
DB_NAME | pentaho-instaview | ||
DB_FARM_LOCATION | $HOME/.kettle/instaview/dbfarm | $HOME/.kettle/instaview/dbfarm | |
MONETDB_CMD | /usr/local/monetdb/bin/monetdb | /usr/bin/monetdb | |
MONETDBD_CMD | /usr/local/monetdb/bin/monetdbd | /usr/bin/monetdbd | |
MONETDB_PORT | 50000 | 50000 | To avoid port conflicts, this port number is sometimes changed to 50006. |
PASSPHRASE | monetdb | monetdb | Required for remote control of Monetdb |
Also, check the AgileBI shared connection in PDI that Instaview creates and uses to talk to Monetdb. You can open this connection in PDI and test or explore it. This connection is used by the templates. If you open the .ktr file used by Instaview you can run it that way as long as Monetdb is running.