Thursday, January 23, 2014

remember if Alfresco Audit Analysis and Reporting plugin installed

Installed Alfresco Audit Analysis and Reporting with branch Limited
This plugin requires CDA and CDE installed in the Pentaho BIServer and has been developed using Sparkl. All the configurations, logs, sources and scripts are stored in the AAAR folder. Several actions are performed during installation, in particular: - Creation of 2 database schema (one as Kettle repository and one as AAAR Data Mart). - Creation of a new JDBC data source in the Pentaho Server. - Creation of a repository structure with dashboards and reports installed inside. - Update of script stored into the file system.

how to remove WARNING: Security role name PENTAHO_ADMIN

INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>

add following configuration before close   </security-constraint>

        <description>security role</description>

after installation of Pentaho Repository Synchronizer using Marketplace

Installed Pentaho Repository Synchronizer with branch Trunk
This plugin copies a version of libpensol.*.jar to the server's WEB-INF/lib. It's possible that on Windows boxes there's an error upgrading the repositorySynchronizer. If that happens, stop the server and delete the WEB-INF/lib/libpensol.* jar file(s)

how to hide .CDA files

To hide the .CDA files, its no use to the end user to see the datasource in the treeview so edit:


And comment the lines between:


Wednesday, January 22, 2014

MySQL server version for the right syntax to use near OPTION SQL_SELECT_LIMIT

mysql> select VERSION();
| VERSION()    |
| 5.6.13-log |
1 row in set (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10' at line 1

mysql>  select VERSION();
| VERSION()  |
| 5.5.11     |
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)Older versions of MySQL employed SET OPTION, but this syntax is   deprecated in favor of SET without OPTION.

You should just use SET SQL_SELECT_LIMIT=10; instead.
Incompatible Change: The obsolete OPTION modifier for the SET   statement has been removed.

Thursday, January 9, 2014

Setting up Pentaho Report Designer for OpenERP

In order to generate reports from OpenERP v7 you need to have Pentaho Report Designer downloaded from Pentaho’s website and unzipped on your computer. The package is a binary package which doesn’t need installation on your computer and hence you can run it from the folder where you unzipped it.
Here are the steps that you can follow to setup and run Pentaho Report Designer to Connect to OpenERP v7 and create reports:
  1. Pentaho Report Designer v3.9.1 is available from here. Download the package which is suitable to your computer architecture. For Windows Download
  2. You need Java JDK Version 1.6.0 and above. You can download java from and install it on your computer.
  3. Once Java is fully installed run the file named “set-pentaho-env.bat” from Pentaho folder. This will setup your environment and then click on “report-designer.bat”. Pentaho Report Designer should run now. Close it now and move on to the next step.
  4. Report Designer is not yet ready to connect to OpenERP server. For that you need to download the following packages
    1. PRD OpenERP Data Source for v3.9
    2. PRD OpenERP Data Source Editor for v3.9
    3. OpenERP Java Report Helper (v0.10.0)
    4. OpenERP Java API v 1.2.0
    5. Apache XMLRPC Binary Libraries v3.1.3
  5. Once you have downloaded the above packages. Copy all the jar files from point 4.1 to 4.4 to the lib directory of Pentaho Report Designer lib directory.
  6. Extract Apache XML RPC Binary Package and copy the xmlrpc-client-3.1.3.jar, xmlrpc-common-3.1.3.jar and ws-commons-util-1.0.2.jar from the extracted lib directory to Pentaho Report Designer lib directory.
  7. Done!! you can now run PRD again by running the “report-designer.bat” file and start developing reports for OpenERP.

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...