AAAR_Etract.sh is failing due to connection

[manirangasamy]

Hi Francesco ,

I am facing problem while executing the AAAR_Extract.sh.

I am using mysql and I used AAAR_Manual_Installation.pdf

Pentaho Combined Server 7.0.0.0-25 Distribution

mysql  Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1

Pentaho and Alfresco are not same servers.

Below is the repositories.xml

]# cat /oracle/app/pentaho/data-integration/repositories.xml
<?xml version="1.0" encoding="UTF-8"?>
<repositories>
  <connection>
    <name>AAAR_Kettle</name>
    <type>MYSQL</type>
    <access>JNDI</access>
    <database>AAAR_Kettle</database>
  </connection>
  <repository>
    <id>KettleDatabaseRepository</id>
    <name>AAAR_Kettle</name>
    <description>AAAR_Kettle</description>
    <connection>AAAR_Kettle</connection>
  </repository>
</repositories>

and

<?xml version="1.0" encoding="UTF-8"?>
<AAAR>
 <parameter name="AAARGetAudit" value="true"> </parameter>
 <parameter name="AAARGetNodes" value="true"> </parameter>
 <parameter name="AAARGetWorkflows" value="true"> </parameter>
 <parameter name="alfrescoAuditLimit" value="50000"> </parameter>
 <parameter name="alfrescoFtpPath" value="alfresco"> </parameter>
 <parameter name="alfrescoFtpPort" value="121"> </parameter>
 <parameter name="alfrescoHost" value="http://x.x.x.x"> </parameter>
 <parameter name="alfrescoLogin" value="admin"> </parameter>
 <parameter name="alfrescoNodeLimit" value="50000"> </parameter>
 <parameter name="alfrescoPassword" value="welcome1"> </parameter>
 <parameter name="alfrescoProtocol" value="http"> </parameter>
 <parameter name="alfrescoPort" value="8080"> </parameter>
 <parameter name="alfrescoType" value="Alfresco_5_1"> </parameter>
 <parameter name="databaseBin" value="/usr/bin"> </parameter>
 <parameter name="databaseType" value="mySql"> </parameter>
 <parameter name="databaseHost" value="localhost"> </parameter>
 <parameter name="databaseLogin" value="root"> </parameter>
 <parameter name="databasePassword" value="xxxxx"> </parameter>
 <parameter name="databasePort" value="3303"> </parameter>
 <parameter name="databaseSchemaAAAR" value="AAAR_DataMart"> </parameter>
 <parameter name="databaseSchemaKettle" value="AAAR_Kettle"> </parameter>
 <parameter name="databaseSchemaMain" value="root"> </parameter>
 <parameter name="kettlePath" value="/opt/data-integration"> </parameter>
 <parameter name="kettleVersion" value="6"> </parameter>
 <parameter name="pentahoAAARPath" value="/public/AAAR"> </parameter>
</AAAR>

I am getting below error while executing AAAR_Extract.sh and log file says "dummy". I am not sure what is wrong with connection. Please guide me in troubleshooting.

 sh AAAR_Extract.sh

A.A.A.R. - Alfresco Audit Analysis and Reporting
Import procedure version 4.2.
Author: Francesco Corti (all rights reserved)
Date: 21 February 2016
Documentation and tips: http://fcorti.com.

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

You are going to execute this command:
./kitchen.sh /rep:AAAR_Kettle /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_audit=true /param:get_nodes=true /param:get_workflows=true /log="/oracle/app/pentaho/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log" /levelebug

Press <enter> to start import.

#######################################################################
WARNING:  no libwebkitgtk-1.0 detected, some features will be unavailable
    Consider installing the package with apt-get or yum.
    e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
#######################################################################
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
14:51:21,421 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
14:51:21,528 INFO  [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 1 at /oracle/app/pentaho/data-integration/./syst ***
***   em/karaf/caches/kitchen/data-1                                        ***
*** Karaf Port:8802                                                         ***
*** OSGI Service Port:9051                                                  ***
*******************************************************************************
May 15, 2017 2:51:22 PM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2017/05/15 14:51:22 - Kitchen - Logging is at level : Debug
2017/05/15 14:51:22 - Kitchen - Repository and username supplied
2017/05/15 14:51:22 - Kitchen - Start of run.
2017/05/15 14:51:22 - Kitchen - Allocate new job.
2017/05/15 14:51:22 - Kitchen - Parsing command line options.
2017/05/15 14:51:22 - Kitchen - Loading available repositories.
2017/05/15 14:51:22 - RepositoriesMeta - Reading repositories XML file: /oracle/app/pentaho/data-integration/repositories.xml
2017/05/15 14:51:22 - RepositoriesMeta - We have 1 connections...
2017/05/15 14:51:22 - RepositoriesMeta - Looking at connection #0
2017/05/15 14:51:22 - RepositoriesMeta - Read at connection: AAAR_Kettle
2017/05/15 14:51:22 - RepositoriesMeta - We have 1 repositories...
2017/05/15 14:51:22 - RepositoriesMeta - Looking at repository #0
2017/05/15 14:51:22 - RepositoriesMeta - Read at repository: AAAR_Kettle
2017/05/15 14:51:22 - Kitchen - Finding repository [AAAR_Kettle]
2017/05/15 14:51:22 - Kitchen - Allocate & connect to repository.
Processing stopped because of an error:
Error connecting to the repository!
Error occurred while trying to connect to the database
Access denied for user 'root'@'xxxxxx.com.xxx' (using password: YES)
ERROR: Kitchen can't continue because the job couldn't be loaded.

Extraction complete!

Log file has been generated in the file below:
/oracle/app/pentaho/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/script/../logs/AAAR.log

[fcorti]

Hi,

Using spoon, you have a "connect" button on the top right of the user interface.

Click the button you should have already a "AAAR_Kettle" connection.

Clicking this, you will be required to write login and password to connect to the repository (admin/admin).

Once done, a repository explorer will be available to you.

Open the transformation (name and path are above), modify the javascript source code and save.

That's all!

You can execute the extraction again.

Cheers.

[manirangasamy]

Thank you Francesco. Finally, I am able to locate the button. It was quit challenging to locate the button. 🙂 . Someone raised as bug in spoon and closed the bug with screenshoot :-). I got it from there.

Next challenge is while click on repository manager, it was throughing an error due to xulrunner compatibility.  I updated the version recommended in the forum. Now, error is vanished but blank window appearing. I understand this not issues with AAAR. Did you come across such problem?  Will updating firefox help ? or any suggestion to open repository manager?

Regards

Mani

[fcorti]

Mmmm, really strange.

I did not experience a similar issue in the past, sorry.

Are you using spoon on windows?

[manirangasamy]

I am using spoon on Linux

[fcorti]

Did you install this?

sudo apt-get install libwebkitgtk-1.0-0

How to install Pentaho Data Integration 7 (aka Kettle) - Francesco Corti 

[manirangasamy]

Hi Francesco,

I am trying to compile and build webkitgtk from The WebKitGTK+ Project . I am going nut by get dependency after dependency while I am trying it.

I would like to ask one question, is it possible to edit the script using windows environment and load  the repository in linux environment or is there any other way to edit script.in repository and deploy into linux (RHEL 5)

Regards

Mani

[fcorti]

You should not need to compile it.
Please note that you could install PDI on a different server/environment respect to the Pentaho BA server.