Uncategorized

Pentaho: Installation

Posted on

Complete Pentaho Installation on Ubuntu, Part 2 http://jaapjansma.nl/2016/05/11/installing-pentaho-6-1-community-edition-on-ubuntu/#comment-36   After installation and reboot of the server, it needs to be manually restarted executing the following command: /opt/biserver-ce/start-pentaho.sh   Additionally, to access the server, just go to the following URL on your browser: http://your.server.name:8080   To Start/Stop the server as in Jasper you do the following:   […]

Apache

Apache: Change Default Not Found Image

Posted on

This is globally controlled by apache, or locally controlled by your .htaccess file (which basically changes the local apache configurations on local folders). Just add the following code to your .haccess file and¬†adjust as per your requirements   RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_URI} \.(gif|jpg|jpeg|png)$ RewriteRule .* /var/www/html/malla-supply/img/p/en.jpg [L]   To do it Programatically […]

PostgreSQL

PgSQL: Cannot Alter Character Length because of Dependant Views

Posted on

  SQL error: ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view rv_warehouseprice depends on column "sku" In statement: ALTER TABLE "adempiere"."m_product" ALTER COLUMN "sku" TYPE character varying(50) I've read some documentation and the only apparent solution is to delete all the related views and then […]