AAAR Installed, but 'No repository provided, can't load job.'

[kossel]

Hi I have alfresco running for several months without problem. Now I wish to count documents viewed time by user.
I installed AAAR following this guide after press install the database is created correctly without erros.

but when I try to run the aaar_extract.bat I get

ERROR: No repository provided, can't load job.

What does it mean? can someone kindly explain me what does repository mean?

[fcorti]

Hi kossel,

The repository is a database used by Pentaho to store jobs and transformations… if this explanation does means nothing for you, doesn''t matter. 😉
The relevant information for you is that the installation process has failed in your environment.

I suggest you to repeat the '1.Configure' and 2.'Install' steps and check the AAAR.log file, because you have for sure some kind of errors. 😉

I hope this suggestion will help you.

[kossel]

For somehow the AAAR.log is empty :s
I double checked the outputn when I run "install"

the only 3 errors shows are:
unable to create log directory /tmp/fileserver

and

- set variables - Couldn't execute SQL: SET statement_timeout = 0

and

- set variables - ERROR syntax error at or near "EXTENSION"


are they fatal? I found that they just create 2 empty database one call AAAR_DataMart and AAAR_Kettle, but without tables.

my AAARConfiguration.xml is

<?xml version="1.0" encoding="UTF-8"?>
<AAAR>
 <parameter name="AAARExportType" value="Get all"> </parameter>
 <parameter name="AAARExportGetParents" value="false"> </parameter>
 <parameter name="alfrescoAuditLimit" value="50000"> </parameter>
 <parameter name="alfrescoFtpPath" value="alfresco"> </parameter>
 <parameter name="alfrescoFtpPort" value="21"> </parameter>
 <parameter name="alfrescoHost" value="127.0.0.1"> </parameter>
 <parameter name="alfrescoLogin" value="admin"> </parameter>
 <parameter name="alfrescoPassword" value="admin.password"> </parameter>
 <parameter name="alfrescoProtocol" value="https"> </parameter>
 <parameter name="alfrescoPort" value="8443"> </parameter>
 <parameter name="databaseBin" value="D:\Alfresco\postgresql\bin"> </parameter>
 <parameter name="databaseType" value="PostgreSql"> </parameter>
 <parameter name="databaseHost" value="127.0.0.1"> </parameter>
 <parameter name="databaseLogin" value="postgres"> </parameter>
 <parameter name="databasePassword" value="posgres.admin.pass"> </parameter>
 <parameter name="databasePort" value="5432"> </parameter>
 <parameter name="databaseSchemaAAAR" value="AAAR_DataMart"> </parameter>
 <parameter name="databaseSchemaKettle" value="AAAR_Kettle"> </parameter>
 <parameter name="databaseSchemaMain" value="postgres"> </parameter>
 <parameter name="kettlePath" value="D:\pdi-ce-5.0.1.A-stable\data-integration"> </parameter>
 <parameter name="kettleVersion" value="5"> </parameter>
 <parameter name="pentahoAAARPath" value="/public/AAAR"> </parameter>
</AAAR>

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

[harvey]

maybe the versión of your database doesn't support "EXTENSION", i had this problem whit postgreSQL 9.0.2, and when i tried with 9.1 or 9.2 that error disappears

[fcorti]

Hi kossel,

The configuration file seems to be correct.
The empty databases are a clear message that something fails!
In particular during the restore (because the process is able to create the databases but was not able to restore them).

The restore process is developed writing a file in the temp directory and executing it… I cannot avoid that the problem is due to the tmp problem.
Please, try to solve it and retry…

If you don't succeed, write me privately with the complete log and I'll give a support.

Thanks.

[oliviera]

Actually, the error is happening, because the file ~/.kettle/repositories.xml is missing… At least this is how I resolved the problem. I don't remember how It has been created in all my different test.

I'm using a MySQL DB, so you have the JNDI protocol in the connection part.

When this file is missing, AAAR_Extract.sh complains about missing repositories. with this file, the scripts executes with no problem.

<?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>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope this helps.

[kossel]

Thanks for both replys, I will try to solve the empty database first.

As you noticed, I'm running in Windows Environment so maybe \tmp\fileserver is not a valid path… I couldnt find where is this path specified.

and for the repositories.xml where it should be in windows environment? c:\user\fileserver\.kettle\repositories.xml?

[fcorti]

Hi Kossel,

The installation package automatically recognizes the operating system.
Probably a problem could be there.
Please, let me know the exact version of operating system and I try to check.

You can create the empty repository.xml file with the requested folders, simply starting kettle using spoon.bat for the first time after installation.

[kossel]

Hi

Its windows server 2008 R2, I even tried to reinstall AAAR, but all paths are linux like(including AAAR_extract.bat is using linux like paths..). very strange

[fcorti]

Hi Kossel,

The AAAR_*.sh/bat files are written during the save process of the configuration dashboard.
If you check those file in the vanilla installation you will be probably confused.
Try to check after it after the configuration process.

The only check of the operating system is developed during the installation process, in particular during the restore of the databases (2 to be exact).
If the problem is there, you should see an error in the log trail otherwise the problem is elsewhere.

I hope this will help you.