AAAR Extract Script Problem

dcambier — Sun, 19 Oct 2014 17:12:29 GMT

i just install AAAR today but AAAR_Extract.sh doesn't work :david@david-ThinkPad-X230-Tablet:/opt/pentaho/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script$ ./AAAR_Extract.shA.A.A.R. - Alfresco Audit Analysis and ReportingImport procedure version 2.0.Author: Francesco Corti (all righ

Re: AAAR Extract Script Problem

eswbitto — Mon, 20 Oct 2014 15:47:45 GMT

I think there could be a number of issues, but the most possible would be either your communication with the database is not going through OR you haven't installed the driver for the database. Are you using mysql?

Re: AAAR Extract Script Problem

dcambier — Mon, 20 Oct 2014 19:07:49 GMT

I found the problem with the help of Francesco.
i checked the log :


2014/10/20 17:16:57 - _installPostgreSql - Démarrage exécution entrée [Check Db connections]
2014/10/20 17:16:57 - _installPostgreSql - Démarrage exécution entrée [Recreate databases]
2014/10/20 17:16:58 - _installPostgreSql - Démarrage exécution entrée [Restore AAAR_DataMart]
2014/10/20 17:17:02 - _installPostgreSql - Démarrage exécution entrée [Restore AAAR_Kettle]
2014/10/20 17:17:31 - Restore AAAR_Kettle - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : PDI a rencontré une erreur durant l'ex�cution de cette tâche : 
2014/10/20 17:17:31 - Restore AAAR_Kettle - Couldn't execute SQL: SET statement_timeout = 0;
2014/10/20 17:17:31 - Restore AAAR_Kettle - SET lock_timeout = 0;
2014/10/20 17:17:31 - Restore AAAR_Kettle - SET client_encoding = 'UTF8';
2014/10/20 17:17:31 - Restore AAAR_Kettle - SET standard_conforming_strings = on;
2014/10/20 17:17:31 - Restore AAAR_Kettle - SET check_function_bodies = false;
2014/10/20 17:17:31 - Restore AAAR_Kettle - SET client_min_messages = warning;
‍‍‍‍‍‍‍‍‍‍‍‍‍

So i commented the line "SET lock_timeout = 0;" in the sql script and after the installation works fine.
Thanks a lot
David

topic Re: AAAR Extract Script Problem in Alfresco Archive

AAAR Extract Script Problem

Re: AAAR Extract Script Problem

Re: AAAR Extract Script Problem