topic Re: Data Extraction Time in Alfresco Archive

Data Extraction Time

eswbitto — Tue, 23 Sep 2014 20:34:07 GMT

I have successfully install AAAR and pentaho on a test server (I think and hope). After running the extract.sh file I look at a report and it doesn't show any data at all. Am I not waiting long enough for the data to populated? The reason I ask is this is a test server and I've only created one site

Re: Data Extraction Time

fcorti — Wed, 24 Sep 2014 17:11:04 GMT

Hi ESWBitto,

I think you have some kind of error in the log file.
I suggest you to take a look there because probably something went wrong.

I hope this will help you.

Re: Data Extraction Time

eswbitto — Wed, 24 Sep 2014 18:35:00 GMT

Hello FCorti,

I've looked into all the log files and there's nothing that indicates that there is an issue.

Centos 6.5 VM (virtual box)
Alfresco 4.2.f
Current versions of the BIserver and the data integration.

When setting up the alfresco credentials and the database as well, it works. There is no logs that indicate a communication issue.

I'm frankly stuck on what to try next to trouble shoot this. Usually the logs will help me, but no such luck.

*edit*

I ran the extract again and I noticed there was a message on the command line. I didn't have permission to access the kitchen.sh file. I changed the permission level and ran it again. Now I"m getting another error.

"Error occured while trying to connect to the database"

Invalid JNDI connection AAAR_Kettle:No suitable driver fround for jdbc:mysql://IP address:3306/AAAR_Kettle

Re: Data Extraction Time

fcorti — Thu, 25 Sep 2014 06:16:55 GMT

Hi ESWBitto,

I suggest you to take a look to this link:
http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-prerequites/

There you will find the prerequisites that probably suites for you.

Re: Data Extraction Time

eswbitto — Thu, 25 Sep 2014 15:55:00 GMT

Hello Francesco,

I have looked at that link before and have done everything on it. That's why I am posting now. I can't get any data to import.

When I run the AAAR_Extract.sh from the command line I notice an error there. It says wrong username or password, but I'm not sure where this script is getting that information or if I have to manually add it to the script.

*edit* Here is the full output of what is shown.


A.A.A.R. - Alfresco Audit Analysis and Reporting
Import procedure version 2.0.
Author: Francesco Corti (all rights reserved)
Date: 01 January, 2014

Disclaimer:
We can't be responsible for any damage done to your system,
which hopefully will not happen.

Tip:
Want to reduce the time of execution?
Edit this script and change 'JOB_NAME' and 'GET_PARENTS' variables.
If you don't know how, look at the FAQ at http://fcorti.com.

You are going to execute this command:
./kitchen.sh /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=false /log="/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /level:Basic

Press <enter> to start import.


Tip:
Want to reduce the time of execution?
Edit this script and change 'JOB_NAME' and 'GET_PARENTS' variables.
If you don't know how, look at the FAQ at http://fcorti.com.

You are going to execute this command:
./kitchen.sh /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=false /log="/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /level:Basic

Press <enter> to start import.

2014/09/26 10:51:38 - Kitchen - Logging is at level : Basic logging
2014/09/26 10:51:38 - Kitchen - Start of run.
2014/09/26 10:51:38 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
Processing stopped because of an error:
Incorrect password or login

ERROR: Kitchen can't continue because the job couldn't be loaded.

Extraction complete!

Log file has been generated in the file below:
/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log

Check for ERRORS in the log.
If you can't find them, everything has gone alright.
Please, remember to schedule the command periodically or to execute it manually.

Tip:
You can schedule this command using the silent execution with the command below:
/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/./AAAR_Extract.sh silent

Want to save the reports in pdf format directly in Alfresco?
It's time to execute the 'AAAR_Publish' script.

Enjoy A.A.A.R.!

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

Re: Data Extraction Time

fcorti — Fri, 26 Sep 2014 06:16:51 GMT

Hi ESWBitto,

It's not a problem of login/password but a problem of driver.
Did you install the mysql driver in Pentaho?

Re: Data Extraction Time

fcorti — Fri, 26 Sep 2014 06:18:17 GMT

Hi ESWBitto,

It's not a problem of login/password.
The error says you don't have the mysql driver installed in Pentaho.
Di you install it?

Re: Data Extraction Time

eswbitto — Mon, 29 Sep 2014 20:27:29 GMT

I put a mysql-connector-java-5.1.32-bin.jar into
In /data-integration/lib
In /biserver-ce/tomcat/webapps/pentaho/WEBINF/lib

I may or may not have the right driver for it. I think I do.

Re: Data Extraction Time

eswbitto — Wed, 01 Oct 2014 20:56:48 GMT

I finally got it working!

So what I initally did was installed Java using the yum repository. Which was version 8. I went back to basics and deleted everything and started from scratch. Installed alfresco first…Then the BI server then the data integration. Put in the mysql drivers and installed java version 7 according to the video you have on your site. It all is working now and I'm getting reports on a development server. Woot!

Re: Data Extraction Time

fcorti — Thu, 02 Oct 2014 07:34:58 GMT

🙂

Re: Data Extraction Time

sandeepreddy1 — Thu, 16 Jun 2016 06:12:42 GMT

Hai Francesco,

When I run the AAAR_Extract.sh from the command line I notice an error there. It says wrong username or password, but I'm not sure where this script is getting that information or if I have to manually add it to the script.
i am using PEntaho 6.1 version and alfresco 5.1

####—–####

You are going to execute this command:
./kitchen.sh /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=false /log="/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /level:Basic

Press <enter> to start import.

Tip:
Want to reduce the time of execution?
Edit this script and change 'JOB_NAME' and 'GET_PARENTS' variables.
If you don't know how, look at the FAQ at http://fcorti.com.

You are going to execute this command:
./kitchen.sh /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_parents=false /log="/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /level:Basic

Press <enter> to start import.

2014/09/26 10:51:38 - Kitchen - Logging is at level : Basic logging
2014/09/26 10:51:38 - Kitchen - Start of run.
2014/09/26 10:51:38 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
Processing stopped because of an error:
Incorrect password or login

ERROR: Kitchen can't continue because the job couldn't be loaded.

Extraction complete!

Log file has been generated in the file below:
/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log

Check for ERRORS in the log.
If you can't find them, everything has gone alright.
Please, remember to schedule the command periodically or to execute it manually.

Tip:
You can schedule this command using the silent execution with the command below:
/opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/script/./AAAR_Extract.sh silent

Want to save the reports in pdf format directly in Alfresco?
It's time to execute the 'AAAR_Publish' script.

Enjoy A.A.A.R.!

Help me out please