nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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?

Find more posts tagged with

Comments

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

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>

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

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.

fcorti

Thank you Oliviera for sharing your experience.
For sure without the repositories.xml, the AAAR doesn't work correctly.
To create the file from a vanilla installation of Pentaho Data Integration, you can run Kettle for the first time, even without using it at all.

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

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

anuj0990

This is very useful information shared here. I am really thankful for this. <a href=http://www.99th.co.in >99th.co.in</a>