22 Feb

How to manually install a Pentaho Sparkl application

installerDuring the past days, I have received some contacts describing problems during the installation of the A.A.A.R. application from the Pentaho marketplace. After some investigations, the issue seems to be connected to the sourceforge links that have recently changed its format.

To solve the problem, some of you asked me how to manually install A.A.A.R., and I have added a more generic tutorial on how to manually install a Sparkl application. The tutorial has been added to the collection of the Spark tutorials. I hope that you find it useful.

24 Nov

Discover the documents stored into your Alfresco sites… interactively!

Thank to the requests of some A.A.A.R. users, a brand new report showing the documents stored in every Alfresco site, has been developed. The report is interactive in the way you see below.

Report12_menu

Below a preview of the report for a test case.

Report12

The report will be part of the incoming AAAR v2.2 but if you want to use it or customize it, you can download from github in the PostgreSql version or the MySql version.

Enjoy your analytics.

13 May

Win your free copy of the Pentaho Reporting video course

pentaho reporting video courseHold a chance to win free download link of the Pentaho Reporting video course, just by commenting this post!

_

For the contest we have 2 download copies of Pentaho Reporting video course, to be given away to 2 lucky winners.

How you can win:

To win your copy of this video course, all you need to do is come up with a comment below highlighting the reason “why you would like to win this video course”.

Duration of the contest & selection of winners:

The contest is valid for 2 weeks, until the 27-th of May, and is open to everyone. Winners will be selected on the basis of their comment posted, from the author… yes, it’s me! 🙂

About the video course:

If you are a Java developer or IT professional who wants to assemble custom reporting solutions with Pentaho Reporting, this video course is ideal for you. Master the advanced concepts within Pentaho Reporting such as sub-reports, cross-tabs, data source configuration, and metadata-based reporting.

 A practical video guide, which dives directly into report generation using various techniques, offering you all of the tips and tricks needed to understand Pentaho Reporting. Learn how to create, modify, implement code, and publish professional reports that will boost your business enterprise to a completely new level.

pentaho_reporting_video_course

So, don’t be shy: leave a comment here below!

27 Jan

Pentaho Reporting video course from Pack Publishing

pentaho_reporting_video_courseFinally the Pentaho Reporting video course has been released!

This is a complete video course mainly based on the Pentaho Reporting 3.5 for Java Developers book. The video course is composed by 8 different sectionsmore than 40 videos and has more than 1 hour and half of duration.

Packt Publishing

26 Nov

New A.A.A.R. Alfresco audit analysis and reporting v1.5 release

A.A.A.R.

A new version 1.5 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a smarter installation wizard and the compliance to the recent Pentaho 5 release (the compliance with Pentaho 4 still remain). This version makes the adoption of A.A.A.R. solution very easy and (quite) ready for the inclusion in the Pentaho marketplace. Stay tuned for new updates!

Below some useful links:

21 Oct

New A.A.A.R. Alfresco audit analysis and reporting v1.4 release

A.A.A.R.

A new version 1.4 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a brand new logo and a complete re-styling of the reports layout.

This version introduces the settings useful to an impressive improvement, recently presented at Pentaho Community Meeting in Portugal, regarding the AAAR Analytics. Stay tuned for the details!

Here some useful links:

01 Aug

Speaking at Alfresco Summit 2013 in Barcelona about A.A.A.R. … come to meet me!

2013-11-06 Alfresco - Speaking Barcelona

Next 5th-6th-7th of November in Barcelona come to the Alfresco Summit to see Alfresco Audit Analysis and Reporting solution. During the speech, the 6th of November, will be presented three different solutions including integrations between Alfresco and Open Source reporting tools like Pentaho.and JasperSoft.

At Alfresco Summit, you will discover how to put your content to work, collaborate beyond corporate walls and join our thriving community building new applications that transform the way great work is done in today’s organizations.

Want to know the complete agenda? Click here!

Want to see the speech page? Click here!

alfresco summit 2013

29 Jul

A.A.A.R. v.1.3.1 for MySql, patch to v1.3

mysql-logoThe released patch for MySql installations is a minor change that could have impact in some cases when you apply A.A.A.R. v.1.3 to a big audit repository on Alfresco, with a relevant history (more than two years).

Many thanks to Senzo Dlamini (Department of Science and Technology) for the contribution and the interesting test case that he shared during past weeks.

Where to download the patch

To download the patch you can simply access to the download page on Google Code.

Content of the installation package

The installation package is simply a zip file containing:

  • The ‘AAAR_Kettle_patch.sql’ script.
  • The ‘readme.txt’ file containing the link to this post.

Howto install the patch

The patch is simply a sql script you have to execute on the AAAR_Kettle database to take effect. To reach that goal you can execute the command below.

mysql –uroot –p<password> < “<patch folder>AAAR_Kettle_patch.sql”

Now you can execute again the A.A.A.R. in the way you did before.

Further details

The problem solved by the patch has been added to the A.A.A.R.’s FAQ page but for further details or different cases, please contact me.

23 Jul

New FAQ: CmisRuntimeException with an Internal Server Error running A.A.A.R. with Solr Indexing

During the past months few users emailed me to ask for a support becausealfresco-pentaho they received an ‘Internal Server Error’ while running the A.A.A.R. v1.3. I would like to thank them for the energy they put to solve the problem and specially Gabriele Barbara that wrote the post I share below. The current post has been added to the A.A.A.R.’s FAQ hoping will help someone else.

Gabriele Barbara say:

Using the latest version of A.A.A.R. (v1.3) on Alfresco Community 4.2.c, Windows platform and MySQL database, you could get an error message.

ERROR 19-05 13:33:54,593 - Cmis Input documents before last update - Unxpected Error
ERROR 19-05 13:33:54,593 - Cmis Input documents before last update – org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Internal Server Error

After running:

kitchen.bat /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=true /level:Basic

The problem appears when the job goes to step “get nodes” (if in fact you are running

kitchen.bat /rep:"AAAR_Kettle" /job:"Get audit" /dir:/Alfresco /user:admin /pass:admin /level:Basic

 the job ends properly) and seems to be linked to the “SOLR SSL certificate”.

If in the file ‘<Alfresco>/tomcat/shared/classes/alfresco-global.properties’ there is the line:

index.subsystem.name=solr

You can solve the problem by following these steps:

  • Shutdown Tomcat
  • Comment out the line below and replace with:
index.subsystem.name=lucene
index.recovery.mode=FULL
  • Save the file
  • Start Tomcat
  • Modify again  the file ‘<Alfresco>/tomcat/shared/classes/alfresco-global.properties’ changing as described 
index.recovery.mode=AUTO
  • Save the changes and close the file

Now if you try again to run from the command line: 

kitchen.bat /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=true /level:Basic

the execution of the job should be finished properly.