A.A.A.R. – How to use A.A.A.R.

Once A.A.A.R. has been installed with success, you can start Alfresco analysis and use it according to the instructions described directly in the wizard. Below the description of the tasks.

Access to Pentaho User Console (starting from here you don’t need to be as administrator). Click on Tools -> AAAR and press the ‘Use’ button.


As you can see there are three subtasks:

  • Extract audit data and repository informations from Alfresco into the A.A.A.R. Data Mart. This task is mandatory to make the A.A.A.R. properly work.
  • Publish static reports directly into your Alfresco in different formats (pdf, xlsx, txt, cvs, ecc.). You can jump this task if you want to have interactive reporting.
  • Analytics to use your data inside dashboards, interactive reports, free analysis.

Some advanced configurations are described in the page dedicated to that topic… but they are only some examples. 🙂 Let me know if you think about something different to include in future releases.

<< Description     |     Up to A.A.A.R. home     |     A.A.A.R. Extract >>

I like A.A.A.R.

15 thoughts on “A.A.A.R. – How to use A.A.A.R.

  1. Avatar

    Hello Francesco,
    I’ve been very interested by your work on Alfresco, but I cannot make it work.
    I have followed every step of your guide successfully so far, but I am not able do the import.

    The two main errors I get are :
    WARN 07-05 17:26:39,910 – Unable to load Hadoop Configuration from file:///D:/data-integration/plugins/pentaho-big-data-plugin/hadoop-configurations/mapr”. For more information enable debug logging.

    And strangely, the password authentication fails with the user “postgres”.

    Could you possibly be able to guide me on this matter? I would really like to see what your work can do.

    Thanks in advance!


    • Francesco Corti

      Hi Edouard,

      Thank you for the interest.
      I’m going to help you for sure. 🙂

      First of all the WARN messages are not a problem but only warnings without any consequences. In this case, for example, the hadhoop module is not used at all.

      The other problem, the password authentication in postgres, is a severe problem to be solved.

      Unfortunately I can’t understand from your message which is the wrong configuration so I ask you to try again with the guide and, if you receive a new error, write me privately and I’ll help you to understand the problem.

      During the last months I received lot of interest in the solution and I helped many people like you. 🙂

      Let me know how it goes…

      • Avatar

        Hi Francesco,

        Thanks for your answer.

        I followed your guide using Alfresco 4.2.c when i got the errors, and I still did not find the source.
        I am now trying to do it again using 4.0.b, maybe the newest version was not compatible?

        I’ll get back to you if I encounter the same problems.
        How can I contact you privately?

  2. Francesco Corti

    Hi Edouard,

    I suggest you to try the new 1.3 version, starting from the “Get audit” job.
    I’m quite sure also Alfresco 4.0.b version should work because AAAR is really indipendent from the source.
    I’m interested on your test so, write me at fcorti at gmail.com.
    Please, send me the full log of the execution and we’ll discuss on it.

  3. Avatar

    Hi Francesco.

    Just to simplify, which command I can use to import all the possible data, and then the command to generate all the reports?

    Thank you.

    • Francesco Corti

      Hi Douglas,

      To import audit data and repository composition, use this command:
      ./kitchen.sh /rep:”AAAR_Kettle” /job:”Get all” /dir:/Alfresco /user:admin /pass:admin /level:Basic

      To generate report in Alfresco, use this command:
      ./kitchen.sh /rep:”AAAR_Kettle” /job:”Report all” /dir:/Alfresco /user:admin /pass:admin /level:Basic


  4. Avatar

    Ciao Francesco,

    When extracting and looking at the AAAR.log file, I found a few errors of that kind :
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – select
    cmis:lastModificationDate >= TIMESTAMP ‘2001-01-01T00:00:00.000+00:00’
    and (
    cmis:lastModificationDate > TIMESTAMP ‘2001-01-01T00:00:00.000+00:00’
    or (
    cmis:lastModificationDate = TIMESTAMP ‘2001-01-01T00:00:00.000+00:00’
    and cmis:name >= ”
    order by
    cmis:lastModificationDate asc,
    cmis:name asc
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – Unexpected document! Received: something unknown
    2014/08/01 18:29:34 – Cmis Input modified folder.0 –
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at it.francescocorti.kettle.cmisinput.CmisInputMeta.getFields(Unknown Source)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at it.francescocorti.kettle.cmisinput.CmisInput.processRow(Unknown Source)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at java.lang.Thread.run(Thread.java:745)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – Caused by: org.apache.chemistry.opencmis.commons.exceptions.CmisConnectionException: Unexpected document! Received: something unknown
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.parse(AbstractAtomPubService.java:596)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.getRepositoriesInternal(AbstractAtomPubService.java:777)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.bindings.spi.atompub.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:65)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.bindings.impl.RepositoryServiceImpl.getRepositoryInfos(RepositoryServiceImpl.java:85)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:109)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at org.apache.chemistry.opencmis.client.runtime.SessionFactoryImpl.getRepositories(SessionFactoryImpl.java:96)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at it.francescocorti.kettle.cmisinput.CmisSessionFactory.getNewSession(Unknown Source)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at it.francescocorti.kettle.cmisinput.CmisSessionFactory.getSession(Unknown Source)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – at it.francescocorti.kettle.cmisinput.CmisInputMeta.getSession(Unknown Source)
    2014/08/01 18:29:34 – Cmis Input modified folder.0 – … 4 more

    Any idea what they are due to and how to fix them ?

    Grazie !

    • Francesco Corti

      This problem is always due to connection problems.
      Could be a misconfiguration of the connection parameters (url, ports, ecc.).
      Could be a firewall or some kind of connection.
      I suggest you to double check everything.

      • Avatar

        HI again Fancesco,

        This seems to be an alfresco bug on my version of alfresco (4.1.5 EE). 🙁
        See https://issues.alfresco.com/jira/browse/MNT-9534

        When trying to connect in CURL to the CMIS server, it always a ‘HTTP 302 moved temporarily’ message :
        I:>curl -X GET -u admin:alfresco -v http://l07lavapp117:80/alfresco/cmisatom
        * Adding handle: conn: 0x4f3180
        * Adding handle: send: 0
        * Adding handle: recv: 0
        * Curl_addHandleToPipeline: length: 1
        * – Conn 0 (0x4f3180) send_pipe: 1, recv_pipe: 0
        * About to connect() to l07lavapp117 port 80 (#0)
        * Trying…
        * Connected to l07lavapp117 ( port 80 (#0)
        * Server auth using Basic with user ‘admin’
        > GET /alfresco/cmisatom HTTP/1.1
        > Authorization: Basic YWRtaW46YWxmcmVzY28=
        > User-Agent: curl/7.33.0
        > Host: l07lavapp117
        > Accept: */*
        < HTTP/1.1 302 Déplacé Temporairement
        * Server Apache-Coyote/1.1 is not blacklisted
        < Server: Apache-Coyote/1.1
        < Set-Cookie: JSESSIONID=759E049561D6A7A805513BA476BD9781; Path=/alfresco
        < Location: http://l07lavapp117/alfresco/faces/jsp/login.jsp?_alfRedirect=%2Falfresco%2Fcmisatom
        < Content-Length: 0
        < Date: Wed, 13 Aug 2014 08:45:09 GMT
        * Connection #0 to host l07lavapp117 left intact

        I'll test your solution again after an upgrade …

        Cheers and thx for the support

      • Avatar


        Just giving a few more feedbacks about CMIS connection troubles. After facing connection issues (see post on this thread), I updated Alfresco from 4.1.5 EE to 4.1.8 EE to get the https://issues.alfresco.com/jira/browse/MNT-9534 bug fixed.
        Now when I connect to curl -X GET -u admin:alfresco -v http://l07lavapp117:80/alfresco/cmisatom, I get a HTTP/1.1 401 Non-Autorisé !
        But if I turn off SSO (ntlm.authentication.sso.enabled=false), it works !
        So my goal is now to dynamically turn off sso before running AAAR-extract.bat,, which can be done by means of JMX… this is a workaround, in case it can help someone out there (and hoping alfresco is aware of the CMIS/SSO problem and has fixed it in the 4.2 release)


Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.