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:

Advertisements

PDI CMIS Input plugin v1.1 for Pentaho 5

CMISInputA new version of the PDI CMIS Input plugin has been released in the Google code website. The request to update the Pentaho marketplace to this new version has been pulled and is waiting for approval. Soon the new version will be available also there.

The main changes are:

Enjoy!

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:

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

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.

Francesco Corti

News: CMIS Input plugin released in the official Pentaho marketplace

Do you want to extract informations from your ECM using a standard?

Do you want to know documents, types, metadata and everything is relevant from your Alfresco?

The CMIS Input plugin has been released in the official Pentaho Data Integration marketplace. Below the video showing the use of the marketplace from the Pentaho Data Integration (Kettle).

Pentaho marketplace

(Pentaho marketplace screenshot)

(Matt Caster video)

CMISInput