topic Re: AAAR Reporting Solution in Alfresco Archive

AAAR Reporting Solution

eswbitto — Thu, 12 Dec 2013 18:00:04 GMT

Hey Mr. Corti,About a month ago or close to it I came across your reporting solution add-in for Alfresco. I have to say I'm quite impressed with this solution and know that we can implement it in our business model. So first of all thank you so much for doing this!My question now is AAAR still in de

Re: AAAR Reporting Solution

fcorti — Thu, 12 Dec 2013 21:19:27 GMT

Hi EWSBitto,

First of all thank you for the feedback.

The AAAR is an open source solution with a community release. I don't consider AAAR in a development state but the solution is distributed as is with no warranties or enterprise support from my side. On the other hand, I'm currently receiving good feedback from the community and in the next future, I would like to improve features and applications.

If you and your organization will be agree on that model, I think AAAR could be what you are looking for. From my side, I'm interested on your application to make the AAAR even better.

If you and your organization would prefer an enterprise support on it, please write me privately at fcorti at gmail dot com and I can help you with a suggestion.

Best regards.

Re: AAAR Reporting Solution

reddy414 — Tue, 11 Aug 2015 07:06:00 GMT

Hi Fcorti,
I am configured AAAR reports with alfresco, and i also configured google authentication with alfresco, Login process working fine, but Login users through google authentication not came in audit_login users report, only alfresco users came in that reports.., any solution please help me

Re: AAAR Reporting Solution

fcorti — Wed, 12 Aug 2015 08:05:45 GMT

Hi Reddy414,

There aren't apparent reasons for this behaviour but I suggest to share a more detailed use case.
Please write me privately or leave a issue here:
https://github.com/fcorti/alfresco-audit-analysis-reporting/issues

We'll be back in the forum once the issue will be more clear.

Thank you for you contact.

Re: AAAR Reporting Solution

sandeepreddy — Tue, 08 Sep 2015 07:18:17 GMT

How to trace the login users in alfresco enterprise audit trail…?? , please check this link http://fpaste.org/263490/14413493/ password: Lufana@123 ,http://snag.gy/hgP42.jpg, http://snag.gy/oCevo.jpg . I have integrated google authentication with alfresco and the users can login into alfresco with their google credentials.help me please…?

Re: AAAR Reporting Solution

sandeepreddy — Tue, 08 Sep 2015 07:19:59 GMT

please check this link http://fpaste.org/263490/14413493/ password: Lufana@123 , http://snag.gy/hgP42.jpg , http://snag.gy/oCevo.jpg .

Re: AAAR Reporting Solution

sandeepreddy — Tue, 08 Sep 2015 07:30:17 GMT

Hi Francesco,

-> Whenever i am enetring Api on browser http://localhost:9090/alfresco/service/api/audit/query/alfresco-access?verbose=true&limit=50000 it showing like attachment Text-1.txt

-> Whenever i am enetring Api on browser http://localhost:9090/alfresco/service/api/audit/query/alfresco-access?verbose=false&limit=50000 it showing like attachment Text-2.txt

How to get google users in AAAR Login user Reports, I need your help help me please.

Re: AAAR Reporting Solution

agg — Wed, 14 Oct 2015 08:18:26 GMT

Hi Francesco or everyone!,

After a year of A.A.A.R working perfectly, the customer has reported an error during the data extraction process.
In the log the following error appears:


——————————————————–
2015/10/12 23:04:24 - Modified Java Script Value.0 - Optimization level set to 0.
2015/10/12 23:04:33 - stg_audits.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue: 
2015/10/12 23:04:33 - stg_audits.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2015/10/12 23:04:33 - stg_audits.0 - Error batch inserting rows into table [stg_audits].
2015/10/12 23:04:33 - stg_audits.0 - Errors encountered (first 10):
2015/10/12 23:04:33 - stg_audits.0 - Data truncation: Data too long for column 'values' at row 1
2015/10/12 23:04:33 - stg_audits.0 - 
2015/10/12 23:04:33 - stg_audits.0 - 
2015/10/12 23:04:33 - stg_audits.0 - Error updating batch
2015/10/12 23:04:33 - stg_audits.0 - Data truncation: Data too long for column 'values' at row 1
2015/10/12 23:04:33 - stg_audits.0 - 
2015/10/12 23:04:33 - stg_audits.0 - 
2015/10/12 23:04:33 - stg_audits.0 -    at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:404)
2015/10/12 23:04:33 - stg_audits.0 -    at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
2015/10/12 23:04:33 - stg_audits.0 -    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2015/10/12 23:04:33 - stg_audits.0 -    at java.lang.Thread.run(Unknown Source)
————————————————-
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It seems a problem with the column 'values' and a long data but I need help with that issue.
How can I find the table and increase the column size? (is that the correct solution?).
Thank you!

Re: AAAR Reporting Solution

agg — Thu, 22 Oct 2015 07:58:00 GMT

Hi all,

I solved the issue increasing the height of the column 'values' (Changing from VARCHAR(5000) to VARCHAR(9000)) in the table 'stg_audits'.

I hope it helps to someone!

Re: AAAR Reporting Solution

fcorti — Wed, 04 Nov 2015 13:17:15 GMT

Hi Agg,

Your is the right solution.
In any case, I suggest you to upgrade AAAR to the latest release because this issue has been solved.
In particular, during this days, the v4.0 has been released with a relevant improvement on the extraction job.

Cheers.