Error while trying t o run AAAR_Extract.sh

[bisana]

Hi All
When 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 entry [Get Alfresco audit]
2014/02/23 12:39:02 - Get Alfresco audit - Dispatching started for transformation [Get Alfresco audit]
2014/02/23 12:39:02 - stg_audits.0 - Connected to database [AAAR_DataMart] (commit=1000)
2014/02/23 12:39:02 - Load file content in memory.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2014/02/23 12:39:02 - Modified Java Script Value.0 - Optimization level set to 0.
2014/02/23 12:39:03 - Modified Java Script Value.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
2014/02/23 12:39:03 - Modified Java Script Value.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2014/02/23 12:39:03 - Modified Java Script Value.0 - Javascript error:
2014/02/23 12:39:03 - Modified Java Script Value.0 - SyntaxError: illegally formed XML syntax (script#25(eval)#10)

‍‍‍‍‍‍‍‍‍‍‍‍

What would have made the error coming, how could we solve it
Guidance and advice requested
thanks
Joseph John

[fcorti]

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.

[bisana]

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

[fcorti]

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&l...
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.

[bisana]

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