cancel
Showing results for 
Search instead for 
Did you mean: 

Error while trying t o run AAAR_Extract.sh

bisana
Champ on-the-rise
Champ on-the-rise
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

4 REPLIES 4

fcorti
Elite Collaborator
Elite Collaborator
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
Champ on-the-rise
Champ on-the-rise
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
Elite Collaborator
Elite Collaborator
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
Champ on-the-rise
Champ on-the-rise
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
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.