topic unable to load A.A.A.R. transform data in Alfresco Archive

unable to load A.A.A.R. transform data

rocketboy2000 — Thu, 30 Oct 2014 02:44:22 GMT

hi there,having a heck of a time getting A.A.A.R. installed on windows 7, pentaho community 5.2 and alfresco community 5.finally, getting to the point where AAAR_Install.bat is, I believe, attempting to load the transformation and I'm getting the following:2014/10/29 18:12:14 - _installPostgreSql -

Re: unable to load A.A.A.R. transform data

eswbitto — Thu, 30 Oct 2014 18:30:21 GMT

What version of Java are you running?

Re: unable to load A.A.A.R. transform data

rocketboy2000 — Thu, 30 Oct 2014 22:14:59 GMT

sorry I didn't include that… 7u55 64bit.

Re: unable to load A.A.A.R. transform data

eswbitto — Fri, 31 Oct 2014 15:44:02 GMT

The only two issues that I had when starting out with AAAR is making sure I had the right java version and also the right driver for the connection.

Re: unable to load A.A.A.R. transform data

fcorti — Sun, 02 Nov 2014 08:13:40 GMT

Hi Charlie,

Please confirm you have a problem during the installation process.
And again: please confirm you are installing AAAR using the web interface and not the AAAR_Install script.

The problem seems to be on the Pentaho side, when the installation process try to upload the sample reports in the Pentaho repository.

Re: unable to load A.A.A.R. transform data

fcorti — Sun, 02 Nov 2014 19:35:30 GMT

Tested in the Windows environment… and it works!
So, the problem is elsewhere… please let us know some further details to understand (and solve) the problem.

Re: unable to load A.A.A.R. transform data

rocketboy2000 — Sun, 02 Nov 2014 22:44:44 GMT

thanks so much for the response.

ok, so I've backed up a bit and am relying on the AAAR install interface. the install seems to go fine as I can see the databases it creates.

this is what I'm getting when I attempt the extract:


Please, enter the <data-integration> path (es.:C:\data-integration): C:\Pentaho\data-integration

You are going to execute this command:
Kitchen.bat /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:get_pare
nts="false" /log="C:\Pentaho\biserver-ce\pentaho-solutions\system\AAAR\endpoints\kettle\script\..\lo
gs\AAAR.log" /level:Basic

Press any key to continue . . .

DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk1.7.0_71
DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jdk1.7.0_71\bin\java.exe

C:\Pentaho\data-integration>"C:\Program Files\Java\jdk1.7.0_71\bin\java.exe"  "-Xmx512m" "-XX:MaxPer
mSize=256m" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=" "-DKETTLE_USE
R=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=
" -jar launcher\pentaho-application-launcher-5.2.0.0-209.jar -lib ..\libswt\win64  -main org.pentaho
.di.kitchen.Kitchen /rep:"AAAR_Kettle" /job:"Get all" /dir:/Alfresco /user:admin /pass:admin /param:
get_parents "false" /log "C:\Pentaho\biserver-ce\pentaho-solutions\system\AAAR\endpoints\kettle\scri
pt\..\logs\AAAR.log" /level:Basic
2014/11/02 14:26:54 - Kitchen - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy
) : Command Line Options
2014/11/02 14:26:55 - Kitchen - Start of run.
2014/11/02 14:26:55 - RepositoriesMeta - Reading repositories XML file: C:\Users\Charlie\.kettle\rep
ositories.xml
[Fatal Error] :-1:-1: Premature end of file.
Processing stopped because of an error:
!Kitchen.Error.NoRepDefinied!

Error reading information from file:
Premature end of file.


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

is the installer supposed to write something to the users .kettle directory? a repositories.xml file? I've noted that the AAAR app is having troubles writing to my file system… for example, the config form is unable to make changes to the AAARConfiguration.xml file. I've had to populate that myself.

what are we supposed to find in the .kettle directory?

thanks again.
charlie

Re: unable to load A.A.A.R. transform data

rocketboy2000 — Mon, 03 Nov 2014 01:12:15 GMT

I got it all working… not sure exactly what the glitch was but… i backed out of everything and i found that if i ran the install while running everything "as administrator" in windows 7 then the install works.

thanks for everyones attention to this!

Re: unable to load A.A.A.R. transform data

vikash — Fri, 28 Nov 2014 06:02:17 GMT

Hi fcorti,

can you suggest me how to make a java call to pentaho Api which will upload Report in Alfresco,

I was not able to understand from where i will start

thanks

Re: unable to load A.A.A.R. transform data

fcorti — Fri, 28 Nov 2014 08:13:04 GMT

Hi Vikash,

I suppose you need to process a prpt report stored into the Pentaho repository and receive in output a PDF (or similar) and, finally, you would like to upload the result into Alfresco, isn't it?
If yes, you can take a look at the 'Report all' job in AAAR using the spoon UI (you have to install it to examine it).
This is a Pentaho Data Integration job that develop exactly this.

To complete the answer I tell you that Pentaho is able to make the job/transformations published as REST services.
All the jobs/transformations in this folder (except for the one with the underscore):
https://github.com/fcorti/alfresco-audit-analysis-reporting/tree/master/endpoints/kettle
Are published as REST services in Pentaho.

Finally, you can call the REST from Java in the way you want. 😉

I hope this helps you.