Regarding AAAR setup issue for Alfresco 5.1.1 and Pentaho 7

[paritoshchandor]

Hello Francesco,

My Alfresco version is 5.1.1

Pentaho version is 7

A.A.A.R version is 4.5.

I am trying to setup AAAR for Alfresco.I was able to get the "AAAR" option in the "Tools" Menu on Pentaho.  

But it is throwing the following error when "AAAR" page come up.It does not show the configuration option in the screen.  "14:59:12,206 ERROR [RepositoryResource] Repository file [ublic:AAAR:main.wcdf] not found"

 I am attaching the snapshot as well as the console error.

It does not throw any error in the pentaho.log.  

Kindly help me with the same.  

Thanks and regards,

Paritosh Chandorkar

[paritoshchandor]

Hello Francesco,

I have added the reply to your solution:

The url is

https://community.alfresco.com/message/811086-regarding-aaar-setup-issue-for-alfresco-511-and-pentaho-7?q=AA

The reply is as follows:

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Hello Francesco,

My understanding is AAAR_DataMart and AAAR_Kettle should be used

automatically while installation.I read that in one of the forum

comments..Both arent happening when I am installing AAAR on pentaho 7.

Instead I am getting the error

"Warning! *Please, check logs ignoring errors with description

'...Folder/File exists, failing.'.*"

Even when i create the schema AAAR_DataMart in MySQL it does not work.

Installation is not working properly.Extraction script succeeds but

AAAR.log does not get updated.

Publishing script runs into the error:

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

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

org.pentaho.di.core.exception.KettleFileException:

Unable to list jar files in plugin folder 'plugins'

*Could not find files in

"file:///C:/Pentaho7/pdi-ce-7.0.0.0-25/data-integration/plugins".*

*Could not find files in

"file:///C:/Pentaho7/pdi-ce-7.0.0.0-25/data-integration/plugins".*

Kindly help me with installation extraction and publishing actions of the

AAAR

Please Note: Attaching the latest catalina.bat for your reference.

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Thanks and regards,

Paritosh Chandorkar

[fcorti]

Hi Paritosh,

The AAAR_DataMart and AAAR_Kettle databases are not used during the installation but are created during the installation.

If the installation does not create the two databases for you, the installation fails for some reasons we have to discover.

The right place to discover the error is the Pentaho catalina.out file.

The error you share describes something about a corruption of the Pentaho repository.

[paritoshchandor]

Hello Francesco,

Thanks for the reply.

In my case, AAAR_DataMart and AAAR_Kettle databases are not getting created during installation.

I have checked catalina.log file but could not locate the exact error.I have attached the catalina.log files for your reference.

Please can you give me the steps to set up repository in PDI for Pentaho 7.

I have no idea why the current repository is corrupted.Can you help me here as well.

Thanks and regards,

Paritosh Chandorkar

[fcorti]

Hi Paritosh,

In both the log files you have an issue related to the Pentaho repository, having an issue with the version history.
The strange thing is that I cannot see nothing in the log about the installation task.
Did you press the "Install AAAR" button as described in the page below?

http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/