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

[rocketboy2000]

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 - Starting entry [Upload main]
2014/10/29 18:12:14 - Upload main - Loading transformation from XML file [file:///C:/Pentaho/biserve
r-ce/pentaho-solutions/system/AAAR/endpoints/kettle\_pentahoUploads.ktr]
2014/10/29 18:12:14 - _pentahoUploads - Dispatching started for transformation [_pentahoUploads]
2014/10/29 18:12:14 - Create target folder and upload file.0 - ERROR (version 5.2.0.0, build 1 from
2014-09-30_19-48-28 by buildguy) : Error initializing UserDefinedJavaClass:
2014/10/29 18:12:14 - Create target folder and upload file.0 - ERROR (version 5.2.0.0, build 1 from
2014-09-30_19-48-28 by buildguy) : org.codehaus.janino.CompileException: Line 11, Column 8: Imported
 class "org.pentaho.platform.web.http.api.resources.RepositoryImportResource" could not be loaded
2014/10/29 18:12:14 - Create target folder and upload file.0 - ERROR (version 5.2.0.0, build 1 from
2014-09-30_19-48-28 by buildguy) : Error initializing step [Create target folder and upload file]
2014/10/29 18:12:14 - _pentahoUploads - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by
buildguy) : Step [Create target folder and upload file.0] failed to initialize!
2014/10/29 18:12:14 - Upload main - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buil
dguy) : Unable to prepare for execution of the transformation
2014/10/29 18:12:14 - Upload main - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buil
dguy) : org.pentaho.di.core.exception.KettleException:
2014/10/29 18:12:14 - Upload main - We failed to initialize at least one step.  Execution can not be
gin!
2014/10/29 18:12:14 - Upload main -
2014/10/29 18:12:14 - Upload main -
2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:11
49)
2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.trans.Trans.execute(Trans.java:607)
2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(Jo
bEntryTrans.java:1062)
2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.job.Job.execute(Job.java:716)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

etc.. etc…

2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.job.Job.execute(Job.java:598)
2014/10/29 18:12:14 - Upload main -     at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobE
ntryJobRunner.java:71)
2014/10/29 18:12:14 - Upload main -     at java.lang.Thread.run(Thread.java:745)
2014/10/29 18:12:14 - _installPostgreSql - Finished job entry [Upload main] (result=[false])
2014/10/29 18:12:14 - _installPostgreSql - Finished job entry [Set repository] (result=[false])
2014/10/29 18:12:14 - _installPostgreSql - Finished job entry [Set JNDI for AAAR_Kettle 2] (result=[
false])
‍‍‍‍‍‍‍‍‍‍

we're really excited to get this tool up and running! any assistance is most appreciated!

Charlie

[eswbitto]

What version of Java are you running?

[rocketboy2000]

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

[eswbitto]

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.

[fcorti]

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.

[fcorti]

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.

[rocketboy2000]

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

[rocketboy2000]

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!

[vikash]

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

[fcorti]

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.