A.A.A.R. – Install A.A.A.R.

With this task you are going to install the A.A.A.R. Application into your environment. Below the description of the tasks to develop.

Access to Pentaho User Console as administrator (otherwise you will not have permits to access to configuration dashboards). Click on Tools -> App Builder and a dashboard will appear. Now press the AAAR start icon (the right arrow in the AAAR content box) and the administration dashboard will appear. Now you can access to the ‘Configure’ button.

ATTENTION: If you see an error instead of the dashboards, try to read if this is the case. In this post you will find the solution on how to go ahead and avoid the issue.

AAAR wizard configure

Set the requested parameters and save the configuration but don’t forget to specify the informations requested for the Data Mart and PDI (Kettle). If you prefer you can check the configuration set in the file ‘<biserver-ce>/pentaho-solution/system/AAAR/endpoints/kettle/conf/AAAR_Configuration.xml’. Now it’s time to access to the Install dashboard. Below the dashboard you are going to see.

AAAR wizard install

Press the ‘Install’ big button and install it using the ‘install’ button at the bottom of the page.

ATTENTION: This task creates two new database schema called AAAR_DataMart and AAAR_Kettle. Every installation invoked drop and re-create the two schemas.

After the installation, before going ahead, please check the log. The log is fully described in ‘<biserver-ce>/tomcat/logs/catalina.out’ or ‘<biserver-ce>/pentaho-solution/system/AAAR/endpoints/kettle/logs/AAAR.log’. Please, pay lot of attention because not all the error messages are real errors but you have to check everything has been properly executed to make all the solution works.

Before use the A.A.A.R., stop and start again Pentaho and access to the item of the menu Tools -> AAAR.

AAAR_Install_5

Below a brief video of the task described.

Now that everything succeed you will be able to access to the reports, dashboards analytics but are still empty the very first time. Of course, to populate the AAAR data mart (the analytic database) you have to extract the data as described here.

Do you prefer to manually install A.A.A.R. or do you want to scale the solution for a better performance? Take a look at the A.A.A.R. Manual Installation guide written and tested by Vincenzo Sorrentino.

<< Get A.A.A.R. | Up to How-to install | Benchmark >>

I like A.A.A.R.

41 thoughts on “A.A.A.R. – Install A.A.A.R.

  1. It’s great work. It’s what I’m looking for and perhaps i can contribute :). I try to install it with Alfresco CE 4.2.c but not yet successfull, from acces denied for user alfresco dan can’t find job : Get all. Following step by step your instruction but I get confused about the user and password. In this page, in table dm_dim_alfresco is login and password column match with the admin login to the Alfresco Explorer?
    I appreciate for your reply. Thank’s a lot.

    • Francesco Corti

      Thank you spreilukis!
      Your contribution is definetely appreciated.
      Yes, login and password here are the Alfresco’s login and password used to retrieve the audit data. For the first connection I suggest you to use the administrator’s login but for a more correct approach you should use another user.
      Saying that, is your Alfresco’s installation replying to the 1121 port like the example describes?
      If not, discover which the correct port and change the ‘alfresco_port’ field in the table.
      If you have problems, write me privately and we’ll solve.

  2. Hello Francesco,

    I installed it via marketplace and the only thing I can see are the icons – there’s no Configure-, Install- & Use-Button. I couldn’t figure out, what’s the reason for this. I even tried different browsers.
    Maybe you know what’s responsible for this?

    Best regards
    Nicolai

  3. Francesco Corti

    Hi Nicolai,

    What you see is not correct!
    Seems to be an error on the installation process…
    I tried again in my development environments, with the last Pentaho releases, and everything seems to be correct.
    Please, check the catalina.out log file.
    Let me know in my private email and I’ll support you.

    • Ciao francesco,

      I was having exactly the same problem as Nicolai (no Configure-, Install- & Use-Button).
      Updating “Community Graphics Generator” and “Community Dashboards Framework” in the “installed plugins” tab and restaring pdi seem to have solved the problem for now.
      Buttons are back.

      Cheers

    • Ciao francesco,

      I was having exactly the same problem as Nicolai (no Configure-, Install- & Use-Button).
      Updating “Community Graphics Generator” and “Community Dashboards Framework” in the “installed plugins” tab and restaring pdi seem to have solved the problem for now.

      Buttons are back !

      Cheers

  4. Hello Franchesco,

    I installed everething necessary for AAAR on Ubuntu 12.10.
    Alfresco Community 4.2.e
    biserver-ce-5.0.1-stable
    pdi-ce-5.0.1.A-stable
    and AAAR 2.0 from Marketplace

    Audit turned on about two month ago.

    When I tried to do AAAR_Extract.sh I have got an error:

    2014/03/17 15:26:33 – Modified Java Script Value.0 – ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : UnexpectedError:.
    2014/03/17 15:26:33 – Modified Java Script Value.0 – ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.OutOfMemoryError: Java heap space
    …………
    …………
    2014/03/17 15:26:34 – Kitchen – Processing ended after 2 minutes and 56 seconds (176 seconds total).

    all pdf files are empty.

    Can you help me?

    Regards, Ivan

    • Francesco Corti

      Hi Robin,
      During the installation of the AAAR, two different databases are defined: AAAR_Kettle and AAAR_DataMart. The table ‘dm_dim_alfresco’ is a table stored in the AAAR_DataMart.

  5. Hi Francesco,

    Do you have to install pentaho server separately from alfresco? As I see from the screen shot both are using port 8080.

    • Francesco Corti

      Hi Julius,
      It is not mandatory to install Pentaho in a different server… but would be preferable for scalability.
      Of course if you choose to install Pentaho in the same Alfresco server, you have to pay attention to the tomcat’s port and conflicts in general.
      I hope this help you.

      • Thank you for the prompt response. I will follow your advise.

        I tried the latest version (2.1). Did not find it in the marketplace so I got it from sf. Using win 8.1 on a firefox browser, I seem to have an error when I try to open from tools > AAAR. It just keeps loading with the icon and gets stuck. Tried it on a win 7 using ie/chrome, I was able to load the configure, install and use pages but when I try to install using the button at the bottom of the page (described above) an error occurs. Resorted to manual installation instead. Now I am stuck on the “_pentahoUploads” file. From the log, I get “repository not created.” It seems that it does not upload the reports on the server or is this the purpose of the script? (Sorry but i am a novice in JAVA). If you could please help me resolve the error in my installation.

  6. Francesco Corti

    Hi Julius,
    The most important issue is the Pentaho version.
    With Pentaho v5.0.0 or v5.0.1 the correct AAAR version is the v2.0.
    With Pentaho v5.1.0 the correct AAAR version is the v2.1.
    Thank to your comment, I discovered a problem on the Pentaho v5.0.1 version where the AAAR v2.0 is not presented as valid download. Tomorrow in the morning the problem will be solved.
    Until then, you can manually download the right version directly in sourceforge.
    Cheers.

  7. Ciao Francesco,

    In the step “1. Configure”, I set the database (MySql) :
    – type, host, port login,password
    – bin path : I:mysqlbin (I’m on windows server)
    – pdi path : I:pdi-ce-5.1.0.0-752data-integration

    I save and then go to “2. Install” and click install

    I have the confirmation message telling everything went fine (and to refresh the CDA cache, which I do).

    But when I go to mysql I don’t have the new “AAAR_DataMart” and “AAAR_Kettle” created in the show databases command.
    The catalina.out is normal.
    The AAAR.log contains a single line saying “dummy”

    Any clue ?

    Grazie !

    • Hi again,

      this was due to an access not granted to mysql (pentaho.log showed me the error).
      Using mysql’s root user, it turned out good…

      Maybe there’s a security configuration missing on your documentation. In any case, the confirmation dialog pops saying Install is done, even when it failed creating the database…

      Cheers

      • Francesco Corti

        Hi,

        Yes, sure… the errors are logged in the catalina.out.
        Did you installed the mysql as root?
        If yes, this is the problem because lot’s of installation has been developed with this approach (not only by me).
        Let us know how it goes… 😉

  8. 2. Install issue (chainging ports) :

    If you change the pentaho http ports to make them different from alfresco’s 8080, say you choose 8081 for bi server, then in the install procedure, at some point there’s an error because it tries to access a url with the 8080 port.
    Here’s an extract from the pentaho.log file :
    2014/08/01 16:27:38 – REST DELETE.0 – Can not result from [http://localhost:8080/pentaho/plugin/data-access/api/connection/deletebyname?name=AAAR_DataMart]
    2014/08/01 16:27:38 – REST DELETE.0 – java.net.ConnectException: Connection refused: connect

    to solve the problem I had to stick to orginal ports in pentaho and change alfresco’s…

    Any clue on how to fix this in pentaho (that is to say : how to properly override the default ports) ?

    grazie !

  9. Hello Francesco,

    I am having problems installing AAAR on Ubuntu 14.04.1, Pentaho 5.2, MySql and Java version “1.7.0_65”.

    The error log:

    2014/10/30 12:48:55 – _installMySql – Starting entry [Upload main]
    2014/10/30 12:48:55 – Upload main – Loading transformation from XML file [file:///opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/_pentahoUploads.ktr]
    2014/10/30 12:48:55 – _pentahoUploads – Dispatching started for transformation [_pentahoUploads]
    2014/10/30 12:48:55 – Create target folder and upload file.0 – ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Error initializing UserDefinedJavaClass:
    2014/10/30 12:48:55 – Create target folder and upload file.0 – ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.codehaus.janino.CompileException: Line 11, Column 8: Imported class “org.pentaho.platform.web.http.api.resources.RepositoryImportResource” could not be loaded

    Tried to install it on Pentaho 5.1 also using Java 1.8, but I end up with the same problems. 🙁

    Your help is much appreciated.

    Thanks

    • Francesco Corti

      Hi Mark,
      You are the second user in the past couple o days that report me this problem… I’m going to check in my development environment and back to you with an answer.
      Please stay tuned… 🙂

      • Francesco Corti

        Hi (again) Mark,
        I have just installed the AAAR v2.1 with Pentaho 5.2 on a Linux Ubuntu 14.04 LTS platform and everything it’s ok with the installation process.
        I have personally tested many times the AAAR with Pentaho 5.1 so… maybe something different is on your environment.
        Do you use a Windows environment?
        Please write privately to try to discover (and solve) your problem.

  10. hi,

    I am having some troubles in setting up the Data Mart (database) connection settings

    i am using mysql as a connection, and there is no place to add the database where the app should connect to.

    did i miss something?

    thanks

    • Francesco Corti

      Hi Sharik,
      The AAAR installation process defines the database connection for you, automatically.
      If you have this problem I think the installation fails.
      I suggest you to read carefully to the catalina.out.

  11. Hi Francesco,

    following A.A.A.R. compatibility matrix (my alfresco version is 4.2.f) i’ve installed manually AAAR 2.1 on Pentaho 5.2 because in marketplace there is no way to install this version of AAAR.
    When i click on the “install” button there is a javascript error and the installation not start: “undefined is not a function”. The error occurs on file “dashboards/admin/install.cdfde” on line: if (!pentahoUrlValue.contains(window.location.port)) …

    Commenting out this line then the installation starts but an error occours in Pentaho log:

    17:23:31,374 ERROR [ConnectionServiceImpl] ConnectionServiceImpl.ERROR_0004 – Unable to add connection name : connection name was AAAR_DataMart caused by DatasourceMgmtService.ERROR_0001 – Error occurred during saving the datasource AAAR_DataMart. Cause: exception while creating file with name “AAAR_DataMart.kdb”

    Reference number: c678ce85-905b-4a2c-b85e-95d2acbc8d2e
    org.pentaho.platform.dataaccess.datasource.wizard.service.ConnectionServiceException: ConnectionServiceImpl.ERROR_0004 – Unable to add connection name : connection name was AAAR_DataMart caused by DatasourceMgmtService.ERROR_0001 – Error occurred during saving the datasource AAAR_DataMart. Cause: exception while creating file with name “AAAR_DataMart.kdb”

    Is AAAR 2.1 compatible with Pentaho 5.2 ?
    Can you suggest us the correct environment for alfresco 4.2.f ?

    Thanks

  12. Hello, Francesco!

    First of all I should say that you’ve done a great product! But, following your tutorials I’ve encountered some problem. While performing the “Install” step there is an error in the catalina.log:

    Unzip CMIS Input plugin – ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Target folder can not be found. Please check that the target folder exists.

    So, the question is about this missing folder. Where should it be, and how it should be created?

    Thanks!

    • Francesco Corti

      Hi Boris,
      Thank you for the feedback.
      The issue you face, could happen if your Pentaho Data Integration is a brand new installation, never started, or if you configure the wrong data-integration path in the settings.
      I suggest you to execute the spoon.sh script and then try again the AAAR installation.
      If it does not resolve your problem, please double check the PDI (Kettle) tab and the path you set in the field.
      I hope it helps you.

  13. Hey Francesco. How are you?

    I’m installing AAAR now, and I noticed there is no more the “Sparkl” menu.
    You should replace the Sparkl item with “App Builder”, which is the same now with the Pentaho 6.1.
    The change I’m talking about is inside the text bellow:

    Access to Pentaho User Console as administrator (otherwise you will not have permits to access to configuration dashboards). Click on Tools -> Sparkl

    • Francesco Corti

      Ciao Douglas,

      Everything is fine and I hope the same for you. 🙂
      Many thanks for the correction… that is definitely true: Sparkl item has been removed in Pentaho 6.x.
      Correction done!

  14. Hi Francesco,

    I’m following your steps to install A.A.A.R,every step goes successfully.But when I use it,it tells me “no data found”(I’ve already upload some datas on alfresco),and I have runned “AAAR_Extract”,But nothing has changed,and “AAAR_Extract.bat”was drop out immediately!
    I check “pentaho-solutions\system\AAAR\endpoints\kettle\logs\AAAR”,but it shows “dummy”! So I guess maybe I made a mistake during the installation,when I try to press the button “install A.A.A.R.” to re-install A.A.A.R. it shows me “ConnectionServiceImpl.ERROR_0004 – Unable to add connection name : connection name was AAAR_DataMart cause by null”

    Can you help me?

    Regards,jackie

    • Francesco Corti

      The installation is not properly done.
      Please check catalina.out for further details.
      For further support please post a question at community.alfresco.com.
      I’ll be happy to give you support there.

  15. Hi Francesco,

    I’m following your steps to install A.A.A.R,every step goes successfully.But when I use it,it tells me “no data found”(I’ve already upload some datas on alfresco),and I have runned “AAAR_Extract”,But nothing has changed,and “AAAR_Extract.bat”was drop out immediately!
    I check “pentaho-solutions\system\AAAR\endpoints\kettle\logs\AAAR”,but it shows “dummy”! So I guess maybe I made a mistake during the installation,when I try to press the button “install A.A.A.R.” to re-install A.A.A.R. it shows me “ConnectionServiceImpl.ERROR_0004 – Unable to add connection name : connection name was AAAR_DataMart cause by null”

    Can you help me?

    Regards,Meng

    • Francesco Corti

      Hi Meng,
      If you installed AAAR as described in this page, you probably have an issue in the installation process.
      Please check catalina.out for further details.
      For further support please post a question at community.alfresco.com.
      I’ll be happy to give you support there.
      Cheers.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.