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.

18 Jul

Alfresco Summit 2013, 5-7th of November in Barcelona to put your content to work

The next 5th, 6th and 7th of November 2013 you cannot miss the annual edition of the European Alfresco Summit (in past called DevCon) that this year will be in Barcelona (Spain).

You should come to Alfresco Summit if:

  • alfresco logoYou are an Alfresco customer looking to share your story, learn from others, and see the latest product innovations from Alfresco
  • You are an IT decision maker trying to understand how agile ECM solutions like Alfresco can improve business processes and information management
  • You are a developer who installs, configures, and customizes Alfresco and you need technical details directly from Alfresco’s Engineers
  • You are driving a content management project, and want to learn best practices from experienced ECM practitioners
  • You want to see the future of ECM that is hybrid, mobile and firewall free

What to expect:

  • Demos of new products and features
  • Customer use cases spanning government, finance, healthcare, public sector, media, business services sectors, and more
  • Networking with partners and customers from small companies to Fortune 500’s leading the way on the Alfresco Platform
  • Pre-conference training: Find out how to use Alfresco with hands on exercises, or introduce your team to development with Alfresco
  • Pre-conference Hack-a-Thon: Build something fun with other developers
  • Business sessions: Discuss market trends, hear from industry analysts, and see Alfresco in action with customer case studies
  • Technical sessions: Dive deep into the details, learn from leading developers and Alfresco engineers

Many thanks from all of us to Alfresco that organize the event.

I’ll be there with a nice surprice (stay tuned to know it) and if you are interested to the event you can see the complete agenda here. Don’t waste your time, meet us in Barcelona.

15 Jul

Alfresco 4 E.C.M. Implementation book from Packt Publishing

Alfresco 4 Enterprise Content Management ImplementationTalking with people, most of the time with technical skills, I often talk about the absence of a complete and updated book or guide about Alfresco ECM. Unfortunately I was not able to suggest one single read and most of the time we compare a huge collection of (old) books, sites, articles, tutorials, guides and blogs. The reason is clear: Alfresco has been improved in a lot of functionalities and very fastly during the last two years and this 4th version is the most complete, integrated and powerfull.

packt-publishingToday the music has changed and a new book has been published from Packt Publishing with title ‘Alfresco 4 Enterprise Content Management Implementation‘. The authors are very skilled and well known professionals and I personally like to remember one of them involved as technical reviewer: Piergiorgio Lucidi.

First of all I’m going to (buy and) read the brand new book but I’m confident that after this read I will tell that starting from today a unique and complete read is possibile, to understand Alfresco. 😉

Waiting for your opinion…

09 Jul

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.

pcm13_banner