nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ERROR - Alfresco Audit Analysis and Reporting Plugin (A.A.A.R.)

joseph

Hello everyone,

I am trying to install the Alfresco Audit Analysis and Reporting Plugin (A.A.A.R.) version 4.5 on Pentaho 7.0 and I get an error.

Reviewing the error log shows the following line:

2016-12-15 17:16:42,054 ERROR [org.pentaho.di] 2016/12/15 17:16:42 - Abort job - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35 .36 by buildguy): Plugin did not contain ID

Please, I would like to know how to solve this problem. Or be able to know how to install old versions manually.

Thank you very much.

Find more posts tagged with

Comments

ddraper

‌ Tagging you in this thread as you may be able to help here!

fcorti

Thank you Dave Draper‌.

Hi Jose,

As you can see, I did not announce the 4.5 version because I want to test it more with the new 7 version. In any case I'll go through it in the next days and let you know here.
Please keep me in the loop with your tests, I'm always interested. 😉

joseph

Hello Francesco and Dave,

Thank you very much for replying, I would like to know which versions of AAAR and Pentaho are compatible, and which are the direct download links to be able to implement them.

Thank you very much.

fcorti

Hi Jose, below the right place to check.

http://fcorti.com/alfresco-audit-analysis-reporting/aaar-description-of-the-solution/aaar-alfresco-pentaho/

joseph

Thank you very much! Currently I have installed the version of Alfresco CE 5.0.d, according to the list that you sent me the correct version to be able to install is:

- Pentaho 6.1
- AAAR 4.4

You could help me by indicating the download links for each of the products.

Thank you so much for all your support!

fcorti

Sorry Jose, but the Alfresco CE 5.0.x is supported on aaar 4.5.

In any case you are free to choose the preferred environment according to the compatibility matrix.

On the other side, I always suggest to move to the latest version, always more stable and enhanced.

Anyway... if you want to find the pentaho‌ releases, you can find them at Pentaho - Browse Files at SourceForge.net.

As described in the installation documentation (http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-prerequites/ ) you need:

Pentaho Data Integration (Pentaho - Browse /Data Integration at SourceForge.net ).
Pentaho Business Analytics Platform (Pentaho - Browse /Business Intelligence Server at SourceForge.net ).

Last but not least, I would like to share that in the latest days I'm experiencing some issues with the automatic downloads from SourceForge, using the Pentaho Marketplace.

This is to say that you can:

Manually download the aaar‌ 4.5 from here https://sourceforge.net/projects/aaar/files/v4.5/AAAR_v4.5.zip/download
Extract the zip file into the "<pentaho-server>/pentaho-solutions/system" folder and restart Pentaho Server.
Follow the documentation again from here: http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-get/

Please let me know how it goes...

joseph

Hi Francesco,

We are currently working with Alfresco and we are considering using A.A.A.R but we have the following problem in an Alfresco site with 35000 members:

The activities that appear in our dashlet "My Activities" don't last too long because when a user generates a new activity, a new feed entry is created for each user that belongs to the site. This is the reason why once the table that contains the feed entries is full, the older entries end up being deleted.

Because of this problem we are worried that we might lose information, so we want to know if A.A.A.R read the activities in real time or if they are migrated and stored.

I'll be waiting for your answer.

Thanks in advance.

fcorti

Hi,

I suppose you are talking about the Alfresco audit trail, when you mention "activity".

If my assumption is correct, Alfresco trace all the audits in a (huge) table and AAAR extract all the data in a batch, usually during the night time (or once a week, depending on your needs).

I imagine the issue in your case is the dashlet extraction, not the audits tracked into the audit trail (I suggest you to investigate and be sure about it).

I would like to submit to your attention this post, talking about how to face (and solve) the "audit explosion" with AAAR.

How to solve the audit data explosion in Alfresco

I hope this will help you.

joseph

Hi Francesco,

Thank you very much for all your help!

We have successfully installed pentaho and downloaded A.A.A.R and i was wondering:

If there is a way to restrict the access to A.A.A.R to a group of users of Alfresco so that consumers don't have access to this.
If the info the users see can be restricted only to the sites or groups they are members of. For example, the site manager of site A will only see the info related to the site A while the site manager of site B will see info only related to site B
If it's possible to create reports that are available to a certain group of users and other reports that are only available to other group of users.

I'll be waiting for your answer.

Thanks in advance

fcorti

Hi,

Below the answers.

1) Yes, Pentaho BA Server has a very good approach and features on permits, role and authorisations. I'm pretty sure you will find everything you will need on that.

2) I receive a lot of question on "slicing" data depending on the logged user. In principle it is possible and all the data structures are well defined to execute this feature. In addition, I experimented how to develop this in AAAR. The bad news is that I did not have the time (and effort) to do it. If you will be committed to help on this, it will be great. 🙂

3) Yes, exactly using the reply at point n.1. 🙂

joseph

Thanks Francesco!

I was trying the A.A.A.R Dashlet and the links aren't working.

I read in your blog " Alfresco menu to A.A.A.R. dashboards, reports and analysis " and I was wondering if I just have to add to the alfresco-global.properties file:

aaar.pentaho.protocol=http aaar.pentaho.host=localhost aaar.pentaho.port=8082 aaar.pentaho.context=pentaho aaar.pentaho.user=admin aaar.pentaho.password=password aaar.pentaho.application=aaar

Or if I also need to download Pentaho Transparent Authentication in order to make the links work.

I'm currently using A.A.A.R 4.5 with Pentaho 7 and Pentaho Transparent Authentication isn't available for Pentaho 7.

Thanks!

fcorti

Hi Jose,

You are quite close to the solution. 🙂

Quoting the page you linked:

Once the dashlet is available into your dashboard, the last task is to configure the access to the analytics (and the list of available analytics itself). To do it, simply modify the AAAR.get.config.xml file you can find in the path described below.
<alfresco>/tomcat/webapps/share/WEB-INF/classes/alfresco/web-extension/site-webscripts/com/fcorti/AAAR/components/dashlet/AAAR.get.config.xml

For the transparent authentication you are right, it is not working on Pentaho 7 yet and it is not imported in the AAAR v4.5.

I'm waiting to have the time to migrate it to the latest version and... looking for help on this. 😉

joseph

Hi Francesco,

I was wondering if there is a way to get the name of the users or categories. Because currently I just have the username of the users.

Thanks !

fcorti

Hi Jose,

With AAAR 4.5 you don't have those informations extracted.
Alflytics 5.0 (Alflytics will be the new name of the solution) is going to extract:

- Full info about users (full names, emails, organization, etc.)

- Categories and tags for documents and folders.

joseph

That would be amazing because the usernames I have are codes and I would like to make my reports more friendly

I just have two questions about Alflytics 5.0:

Will it be compatible with Alfresco 5.0.d?
When would that new version be released?

fcorti

Hi Jose,

Alflytics 5 will be compatible with Alfresco 5.2+ because it is going to use the new REST API and it won't require any installation/customisation on the Alfresco side (it will be easily tested/used also in production environments without customisations/stops).

I plan to release it before the BeeCon (end of April) and submit a presentation showing the new stuff around... of course don't know if it will be accepted at the moment. 🙂

joseph

Hi Francesco,

I've been able to create my own reports but until know I don't know how can I edit the Main Dashboard so it shows other types of graphics and data.

How can I do that?

Thanks

fcorti

Hi Jose,

To modify the dashboards the right place is the "browser" using the Pentaho User Console.

Form the Pentaho home, select the browse option.

It will open the Pentaho repository.

Then dive into the "/public/AAAR' folder.

There you can find three files with "main" name and different extension.

All the three files define the dashboard.

Edit the file with the CDE icon (main.cde) and a UI will be opened.

Once you will be there, it's a regular Petaho development, strictly related to a javascript development.

I hope this will help you.

joseph

Thanks Francesco

I also wanted to know if there is a way to send a parameter from Alfresco to my report. For example:

I'm on the site A in Alfresco and I click in Documents Report in my AAAR Dashlet. When I see the report, theres only data of the site A because the name of the site was send as a parameter to my report.

I know how to create reports with parameters but I wanted to know if there was a way to send a parameter from Alfresco to the report so when I open my report, I won't have to chose a site from the combo box with all the sites .

Thanks

fcorti

Nice question.

And the answer is positive.

I mean:

The Pentaho dashboards (developed using the Pentaho CTools, in particular using the CDE tool) are called directly using an URL.

In the URL you specify the dashboard and you can optionally specify the parameters.

This feature is extremely powerful if you want to "drill down" data from one dashboard to another or if you want to create a customized user experience. In your use case, the source is Alfresco (you can use for example the value for a property) and create a customized user experience into a target dashboard.

To have some examples you can take a look directly into the AAAR source code for Dashboards.

I frequently use this approach and it works perfectly.

As alternative you can check into the Pentaho forums: what you are trying to do is a regular use of the Pentaho Dashboards.

os_cerna

Hello Francesco,

I also wanted to know how this can be done in a particular case.

I have a report(AAAR_Menu.report.bibliotecaArchivos) that needs to change parameters depending on which site it is called, I have looked into the AAAR source code for Dashboards and made this changes to the AAAR.get.js file, especially on the getAnalyticGroupSettings function:

function getAnalyticGroupSettings(dashletConfig, groupType) {

if (typeof dashletConfig != "xml") {
return [];
}

var result = [];
for each (var link in dashletConfig.link)
{
if(link.@labelId.toString()==="AAAR_Menu.report.bibliotecaArchivos"){

var siteName=Alfresco.constants.SITE;
var posF=siteName.lastIndexOf("/");
var posI=siteName.indexOf("site")+5;
siteName=siteName.slice(posI,posF);
result[result.length] = {
type : groupType,
icon : link.@icon.toString(),
label : link.@labelId.toString(),
url : link.@url.toString().concat("?sitio=",siteName),
groups : link.@permits.toString().split(",")
};
}else{
result[result.length] = {
type : groupType,
icon : link.@icon.toString(),
label : link.@labelId.toString(),
url : link.@url.toString(),
groups : link.@permits.toString().split(",")
};
};
}

return result;
}

As you see i wanted to get the current site name via an Alfresco constant but when i run Alfresco this error appears: 03110001 Failed to execute script 'classpath*:alfresco/web-extension/site-webscripts/com/fcorti/AAAR/components/dashlet/AAAR.get.js': 03110000 ReferenceError: "Alfresco" is not defined. (file:/C:/Alfresco/tomcat/webapps/share/WEB-INF/classes/alfresco/web-extension/site-webscripts/com/fcorti/AAAR/components/dashlet/AAAR.get.js#15)

I think the issue is that i am trying to get data that is within client-side Javascript and using it on a server-side Javascript, but really i do not know how to do it.

Thanks a lot

fcorti

Hi Oscar,

Really interesting use case.

My suggestion is to leave the AAAR.get.js as is, because in this way you modify the whole application to manage a particular case.

Instead, are you aware you can pass a parameter directly to the dashboard?

AAAR is full of these examples.

My suggestion is to define the call, with the parameter included, directly on the Aflresco side, and the n everything will be transparent on the Pentaho side.

If you want to see an example, check the Audit dashboard... it where the parameters are used during the navigation (but you can find a lot of example in there).

I hope it helps.