A.A.A.R. – Analyze workflow instances

If you want to analyze your workflow instances in Alfresco, starting from the A.A.A.R. v3.1 you can do it. Unfortunately the services available natively in Alfresco are not enough for this purpose but there is an easy way out to have a complete analytics also of this business element.

By default, A.A.A.R. v3.1 is able to extract all the workflow definitions, the workflow instances and, of course, to analyze them. But there is no solution to define which are the documents affected by the workflow instances and to know which documents are related to the specific instances of workflows.

To solve this issue, an AMP package has been developed to create the requested services for this purpose. Below is described the installation tutorial of this AMP package. Please remember that this package is OPTIONAL and requested only if you want to know which are the documents related to each of the workflow instances.

1. Download the Alfresco services for A.A.A.R.

Alfresco services for A.A.A.R. are released as an AMP package, easy to install and customize. You can download the aaar-repo-v...amp package from SourceForge at the link below.


Of course, choose the right distribution depending on your Alfresco version. Once the amp file is downloaded, copy it into the amps folder into your Alfresco installation environment.

2. Apply the Alfresco AMP file

Now it’s time to open a terminal and stop Alfresco from the installation folder, with the command below.

./alfresco.sh stop

Please note that the command described are for Linux based operating system but nothing changed (extentions apart) for the Windows based operating systems. But let’s go ahead. To apply the AMP file to your installation simply execute the command below.

cd bin

The system will require to you to press the enter button for few times… don’t worry! 😉

3. Start Alfresco

Last but not least, it’s time to start Alfresco again. Open a terminal and start Alfresco from the installation folder, with the command below.

./alfresco.sh start

Nothing apparently changes and you can check the services are correctly installed by accessing to the link below using your browser.


To confirm the correct installation you should see what is described below.


4. Extract data using AAAR_Extract script

Now that everything has been properly set, you can extract the data to analyze into the AAAR Data Mart.  To understand better how to extract data from you Alfresco instances into AAAR, please read here.

<< Alfresco menu   |  Up to Advanced use and config  |  Custom properties >>

I like A.A.A.R.

4 thoughts on “A.A.A.R. – Analyze workflow instances

  1. Avatar


    I use Alfresco 4.2.e and I had problem with the rescue of the workflow instance information, the “AAAR_Extract.sh” only get the workflows definition and not the workflows instances, I get the next error in the console:

    HTTP – ERROR (version, build 1 from 2015-02-02_12-17-08 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 500 for URL: http://localhost:8088/alfresco/service/api/workflow-instances?state=completed&completedAfter=2000-01-01T00:00:00.000+00:00

    I have come to the conclusion that if I add an exclusion, the API not shot an error 500. The following URL responds with the workflows instances completed:


    I excluded the workflow instances invitation for sites. But this does not matter, I can include only “jbpm$wcmwf:*” [I don’t use jbpm] and the URL it works (I don’t understand this).

    The solution for the correct extraction? I edit the line 12659 of the file AAAR_Kettle_v5.sql (for Alfresco 4.2):

    url || url_workflow_instances_suffix || ”?exclude=state=completed&completedAfter=” || (select coalesce(max(end_date_id),”2000-01-01”::date) from dm_dim_workflow_instances where alfresco_id = dm_dim_alfresco.id) || ”T00:00:00.000+00:00” as workflow_instances_completed_url,


    url || url_workflow_instances_suffix || ”?exclude=activiti$activitiInvitationModerated,activiti$activitiInvitationNominated&state=completed&completedAfter=” || (select coalesce(max(end_date_id),”2000-01-01”::date) from dm_dim_workflow_instances where alfresco_id = dm_dim_alfresco.id) || ”T00:00:00.000+00:00” as workflow_instances_completed_url,

    and the extraction of workflow information is working now :). I only added a new exclusion “activiti$activitiInvitationModerated,activiti$activitiInvitationNominated”, but this exclusion does not matter, I add any extraction and is working anyway. Apparently the URL requires exclusion. I only tried with Alfresco 4.2.

    Pablo V.

  2. Avatar


    I’m Launching

    and getting error:
    “status” :
    “code” : 400,
    “name” : “Bad Request”,
    “description” : “Request sent by the client was syntactically incorrect.”

    “message” : “03260026 FATAL: database \”${db.name}\” does not exist”,
    “exception” : “”,
    Can someone help?

    Or where should I post that?


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.