topic Re: Error while trying t o run AAAR_Extract.sh in Alfresco Archive

Error while trying t o run AAAR_Extract.sh

bisana — Sun, 23 Feb 2014 08:44:19 GMT

Hi AllWhen I trying to run "AAAR_Extract.sh" from <strong> /opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script </strong>I am getting error, just after it connects to the DB stage, I have pasted the error message here 2014/02/23 12:39:02 - Init audit staging - Starting

Re: Error while trying t o run AAAR_Extract.sh

fcorti — Sun, 23 Feb 2014 09:21:44 GMT

Hi Bisana,

During the extraction the audit trail from Alfresco contains something the importer is not able to parse.
The audit trail is stored in a file that the log describes.
Please, share that file (or send it to me privately) and I'll check in details.

Thanks.

Re: Error while trying t o run AAAR_Extract.sh

bisana — Sun, 23 Feb 2014 10:07:49 GMT

Hi Franceso,
I checked the
<strong>/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log</strong>
I could not find reference the audit trial,
Can you guide me where is the audit trial file kept
thanks
Joseph John

Re: Error while trying t o run AAAR_Extract.sh

fcorti — Mon, 24 Feb 2014 06:33:21 GMT

Yes, Bisana, you are right.
What I wrote is not so clear.
Sorry for that.

The mentioned log (AAAR.log) says where the audit trail is extracted.
In particular you can read something like that:


2014/01/02 19:58:46 - HTTP - Connecting to URL: http://alfresco2.omniasoftware.it:80/alfresco/service/api/audit/query/alfresco-access?verbose=true&limit=100000&fromId=0
2014/01/02 20:00:05 - HTTP - Resource type: application/json;charset=UTF-8, last modified on: Thu Jan 01 01:00:00 CET 1970.
2014/01/02 20:01:14 - HTTP - Finished writing 32536154 bytes to result file [/tmp/AlfrescoAudit_1.json]
‍‍‍‍‍

Please, send me (or share) the AlfrescoAudit_?.json file to understand what is wrong.

Cheers.

Re: Error while trying t o run AAAR_Extract.sh

bisana — Tue, 25 Feb 2014 13:39:13 GMT

Liked to give the feedback,
Thanks to Francesco, with his guidance I was able to make the extract.
The possible reason was that, after audit enabled there was not much activities(NILL) on the DM server
So there was nothing to extract. Now I am trying it with a live system and I can able to extract. Now I will try to publish and see the results
Thanks
Joseph John