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/’ there is the line:

You can solve the problem by following these steps:

  • Shutdown Tomcat
  • Comment out the line below and replace with:
  • Save the file
  • Start Tomcat
  • Modify again  the file ‘<Alfresco>/tomcat/shared/classes/’ changing as described 
  • 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

PCM13 – Pentaho Community Meetup 2013 on 5th of October in Sintra (Portugal)

The next 4th, 5th and 6th of October 2013 you cannot miss the 6th edition of the Pentaho Community Meetup (#PCM13). Today is not known the final place, but it will be in Sintra. It’s about 30km away from Lisbon (Portugal).

pcm13_logoThis is a community event and includes anyone that has a passion for Pentaho (being EE or CE users) and want to see the huge ammount of amazing stuff that other people build around the world. This is not a sales event. We usually go deep in technicall stuff, showing the latest news of what’s being developed in the Pentaho ecosystem, and lot’s of focus in real world use cases.

Many thanks from all of us to Pedro Alves and Pentaho that organize the event.

Agenda for the 3 days:

  • Friday evening: Networking and drinks.
  • Saturday: Main presentation day.
  • Sunday Morning: Networking and sightseeing.

As usual, all the presentations will happen on Saturday, 5th of October, but the event starts on friday evening – yes, everyone knows that the main idea of the event is fun, sun, networking and drinks. So we’ll be meeting on friday evening. Totally optional, like the last day, but… I wouldn’t miss it if I were you. 😉

I’ll be there with a nice surprice (stay tuned to know it) and if you are interested to the event you can register from the event page. Don’t waste your time, 100 people is the limit.


Francesco Corti

A.A.A.R. is ready for the Cloud


Use it now!

If you are interested in Alfresco Audit Analysis and Reporting (A.A.A.R.) and don’t want to waste your (precious) time to understand, install, configure and develop, A.A.A.R. is ready for the Cloud with a full installation on a virtual machine you can download and run without any restriction.

So, don’t install it but use it!

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

New release!

Release 1.3

Thanking to interest on the solution, a new version 1.3 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with the full support to the analysis of the repository structure.

Here some useful links:

It’s official! Pentaho Reporting video course for Packt Publishing Limited


I am going to start to develop the Pentaho Reporting video course for Packt Publishing Limited a modern publishing company, producing cutting-edge books, eBooks, and articles for communities of developers, administrators, and newbies alike.

Pentaho Reporting 3.5 for Java DevelopersThe video course is mainly based on the Pentaho Reporting 3.5 for Java Developers book, will be composed by 8 different sections, more than 40 videos and will have 2 hours (circa) of duration.

Interesting experience!

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

New release!

Release 1.2

Thanking to the contribution of some users with interesting practical cases, a new version 1.2 of the A.A.A.R. – Alfresco audit analisys and reporting has been released.

Here some useful links for the interested of you.

A.A.A.R. Alfresco audit analysis and reporting frequently asked questions

Thanking to the contribution of some users a new FAQ page for A.A.A.R. (Alfresco audit analysis and reporting) has been released. I’m sure will be usefull for most of the people are currently using the solution, in P.O.C., production environment or only to see how it works.

Waiting for your feedback to make it grow up… 🙂