topic Re: AAAR Installed, but 'No repository provided, can't load job.' in Alfresco Archive

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

kossel — Tue, 01 Apr 2014 14:20:07 GMT

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 getERROR: No repository provided, ca

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

fcorti — Tue, 01 Apr 2014 16:05:51 GMT

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.

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

kossel — Wed, 02 Apr 2014 18:40:00 GMT

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>

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

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

fcorti — Thu, 03 Apr 2014 06:22:19 GMT

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.

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

oliviera — Thu, 03 Apr 2014 09:21:18 GMT

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.

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

fcorti — Thu, 03 Apr 2014 17:48:54 GMT

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.

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

kossel — Thu, 03 Apr 2014 21:02:00 GMT

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?

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

fcorti — Fri, 04 Apr 2014 05:51:56 GMT

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.

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

kossel — Fri, 04 Apr 2014 23:27:00 GMT

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

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

fcorti — Sat, 05 Apr 2014 14:46:00 GMT

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.

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

harvey — Fri, 25 Apr 2014 21:34:02 GMT

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

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

anuj0990 — Tue, 06 May 2014 05:22:23 GMT

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