topic Re: AAAR installed, I followed this steps in Alfresco Archive

AAAR installed, I followed this steps

bisana — Sun, 23 Feb 2014 05:03:47 GMT

Hi All, Thanks to "Francesco " for his support, after repeated try I was able to install AAAR. I am going to write down the steps which I followed, so that new comers for Pentaho or BI area gets help from this thread.———-I have installed CE edition on a Linux systemUsed normal user to install it —-B

Re: AAAR installed, I followed this steps

emorenofer — Wed, 12 Mar 2014 13:33:06 GMT

I'm in the same point!…Do you know what is the next step?…When I execute AAAR_Extract.sh I get the following error:

2014/03/12 13:29:33 - Kitchen - Logging is at level : Basic logging
2014/03/12 13:29:33 - Kitchen - Start of run.
ERROR: No repository provided, can't load job.
ERROR: Kitchen can't continue because the job couldn't be loaded.

Extraction complete!

I know that it is because I didn't config the data-integration, but I don't know how I can put this configuration…against my Alfresco Server.

Help?

Thanks!

Re: AAAR installed, I followed this steps

emorenofer — Thu, 13 Mar 2014 07:22:36 GMT

When I execute /opt/data-integration/spoon.sh, I see the selecction of repository or bd of repository I don't know (see attach image)

What We need to config here? Repository of Alfresco? BD of Pentaho? Create something?

I think that after create this, AAAR_Extract.sh will be ok?

Grr…

Thanks!

Re: AAAR installed, I followed this steps

emorenofer — Thu, 13 Mar 2014 11:13:33 GMT

Extract of pentaho.log inside TOMCAT directory…

2014-03-13 11:09:52,378 INFO [org.pentaho.di] 2014/03/13 11:09:52 - installFromConfiguration - Start of job execution
2014-03-13 11:09:52,381 INFO [org.pentaho.di] 2014/03/13 11:09:52 - installFromConfiguration - Starting entry [_installFromConfiguration]
2014-03-13 11:09:52,411 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [Checks if files exist]
2014-03-13 11:09:52,413 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [_readConfigurationInVariables]
2014-03-13 11:09:52,415 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _readConfigurationInVariables - Loading transformation from XML file [file:///opt/biserver-ce/pentaho-solutions/system/AAAR/endpoints/kettle/_readConfigurationInVariables.ktr]
2014-03-13 11:09:52,475 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _readConfigurationInVariables - Dispatching started for transformation [_readConfigurationInVariables]
2014-03-13 11:09:52,556 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Data Grid.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2014-03-13 11:09:52,634 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Get data from XML.0 - Finished processing (I=22, O=0, R=0, W=484, U=0, E=0)
2014-03-13 11:09:52,793 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,798 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 2.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,800 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 3.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,802 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 4.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,803 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 5.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,806 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 6.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,810 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 7.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,812 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 8.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,813 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 9.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,815 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 10.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,830 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 11.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,832 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Setting environment variables…
2014-03-13 11:09:52,832 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable AAARExportGetParents to value [false]
2014-03-13 11:09:52,832 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable AAARExportType to value [Get all]
2014-03-13 11:09:52,833 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoAuditLimit to value [50000]
2014-03-13 11:09:52,833 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoFtpPath to value [alfresco]
2014-03-13 11:09:52,833 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoFtpPort to value [21]
2014-03-13 11:09:52,833 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoHost to value [172.30.1.52]
2014-03-13 11:09:52,833 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoLogin to value [admin]
2014-03-13 11:09:52,834 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoPassword to value [SiPeT9Ce]
2014-03-13 11:09:52,834 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoPort to value [8080]
2014-03-13 11:09:52,834 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable alfrescoProtocol to value [http]
2014-03-13 11:09:52,834 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseBin to value [/usr/bin]
2014-03-13 11:09:52,834 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseHost to value [localhost]
2014-03-13 11:09:52,835 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseLogin to value [postgres]
2014-03-13 11:09:52,835 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databasePassword to value [postgres]
2014-03-13 11:09:52,835 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databasePort to value [5432]
2014-03-13 11:09:52,835 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaAAAR to value [AAAR_DataMart]
2014-03-13 11:09:52,836 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaKettle to value [AAAR_Kettle]
2014-03-13 11:09:52,836 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseSchemaMain to value [postgres]
2014-03-13 11:09:52,836 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 12.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,837 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable databaseType to value [PostgreSql]
2014-03-13 11:09:52,837 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable kettlePath to value [/opt/data-integration]
2014-03-13 11:09:52,837 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable kettleVersion to value [5]
2014-03-13 11:09:52,838 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Set variable pentahoAAARPath to value [/public/AAAR]
2014-03-13 11:09:52,838 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 13.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,839 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 14.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,841 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 15.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,843 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 16.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,845 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 17.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,846 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 18.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,848 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 19.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,850 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 20.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,852 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 21.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,854 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Stream lookup 22.0 - Finished processing (I=0, O=0, R=23, W=1, U=0, E=0)
2014-03-13 11:09:52,855 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Finished after 1 rows.
2014-03-13 11:09:52,856 INFO [org.pentaho.di] 2014/03/13 11:09:52 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2014-03-13 11:09:52,861 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [Check databaseType = 'PostgreSql']
2014-03-13 11:09:52,863 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _installFromConfiguration - Starting entry [_installPostgreSql]
2014-03-13 11:09:52,892 INFO [org.pentaho.di] 2014/03/13 11:09:52 - _installPostgreSql - Starting entry [Check Db connections]
2014-03-13 11:09:53,108 ERROR [org.pentaho.di] 2014/03/13 11:09:53 - Checks if files exist - ERROR (version 5.0.1-stable.148b6fef6a996547f0a83bc49a869d75ef55b8ca, build 1 from 2013-11-15_14-00-42 by buildguy) : Cannot connect to database [${databaseSchemaMain}] (connection [PostgreSql]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException:
2014/03/13 11:09:53 - Checks if files exist - Error occured while trying to connect to the database
2014/03/13 11:09:53 - Checks if files exist -
2014/03/13 11:09:53 - Checks if files exist - Error connecting to database: (using class org.postgresql.Driver)
2014/03/13 11:09:53 - Checks if files exist - Invalid URL: jdbcostgresql://localhost:5432/postgres
2014/03/13 11:09:53 - Checks if files exist -
2014/03/13 11:09:53 - Checks if files exist - ]
2014-03-13 11:09:53,109 INFO [org.pentaho.di] 2014/03/13 11:09:53 - _installPostgreSql - Finished job entry [Check Db connections] (result=[false])
2014-03-13 11:09:53,111 INFO [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [_installPostgreSql] (result=[false])
2014-03-13 11:09:53,111 INFO [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [Check databaseType = 'PostgreSql'] (result=[false])
2014-03-13 11:09:53,112 INFO [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [_readConfigurationInVariables] (result=[false])
2014-03-13 11:09:53,112 INFO [org.pentaho.di] 2014/03/13 11:09:53 - _installFromConfiguration - Finished job entry [Checks if files exist] (result=[false])
2014-03-13 11:09:53,117 INFO [org.pentaho.di] 2014/03/13 11:09:53 - installFromConfiguration - Finished job entry [_installFromConfiguration] (result=[false])
2014-03-13 11:09:53,117 INFO [org.pentaho.di] 2014/03/13 11:09:53 - installFromConfiguration - Job execution finished

Pay attention with error connect to Database Tomcat…mmm…I've installed postgres with default credential, I've not modified nothing….mmmm….I don't know…

Maybe this, help you…

Re: AAAR installed, I followed this steps

emorenofer — Mon, 17 Mar 2014 16:33:48 GMT

Ouch…I had problems with ProgreSQL and default user, perfect!

Re: AAAR installed, I followed this steps

fcorti — Tue, 18 Mar 2014 20:55:56 GMT

Hi Emilio,

Nothing to do here.
Please, don't use Spoon to configure AAAR.
I suggest you to follow (as close as possibile) the instructions <a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/">here</a>.

Re: AAAR installed, I followed this steps

fcorti — Tue, 18 Mar 2014 20:58:36 GMT

Hi Emilio,

I suggest you to follow the instructions <a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/aaar-install/">here</a>.

Re: AAAR installed, I followed this steps

macmarket — Sun, 18 May 2014 01:02:00 GMT

Hi Francesco, first I'd like o give you my best congrats due to your work about AAAR…

Well, since I'm a MacManiac, I decided to run Alfresco at one of my MacPros Xeon Octacore 2.26… looks a really great machine to take care of the job and its really fast and stable… well, I follow all the steps you suggested here to have to Pentaho running, and I had it running, but only when I turn off the Alfresco's TomCat, and let only the PostGreeSQL Server Running… so, I really ant to know if its possible to install de Pentaho under the same TomCat that I already have supporting my Alfresco. They are having a conflict, but I didn't find a Pentaho .war version to install in my previous TomCat. Any suggestion?

Re: AAAR installed, I followed this steps

fcorti — Sun, 18 May 2014 06:29:11 GMT

Hi Eduardo,

Thank you for the feedback about AAAR.
I would like you to ask if the need of "one tomcat" into your machine is mandatory.
If you release this requirement you could have another tomcat running, for example, into the 8081 port and everything will work well: Alfresco on the 8080 port and Pentaho on the 8081 port.

I hope this will help you.

Re: AAAR installed, I followed this steps

macmarket — Sun, 18 May 2014 12:44:00 GMT

Hi Francesco, its not mandatory… I've tried before to change the ports of Pentaho to 8081 and I followed some instructions I found in internet but it didn't work… do you have the complete instructions about how to change the Pentaho ports to 8081? I followed this ones: <strong> http://wiki.pentaho.com/display/COM/Run+bi-server+in+another+port+and+address </strong> but I think it's not up to date. Thanks in advance…

Re: AAAR installed, I followed this steps

macmarket — Sun, 18 May 2014 13:30:43 GMT

Hi Francesco… I've just changed the Pentaho ports to 8081, and you can take a look at the screenshot I'm putting here its running, BUT, only when the Alfresco's Tomcat is stopped… Looks like I'm having a conflict between the Alfresco's built-in TomCat and the Pentaho's built-in ones…

Re: AAAR installed, I followed this steps

fcorti — Sun, 18 May 2014 18:19:20 GMT

Hi Eduardo,

Looks good!
I cannot understand the conflict you mention, but in theory it should work.
I always use this configuration in my development enviroments. 😉

Re: AAAR installed, I followed this steps

macmarket — Mon, 19 May 2014 00:52:38 GMT

When I turn the Alfresco's Tomcat Server ON, looks like it blocks the Pentaho's Tomcat Server, even at port 8081.

The Alfresco has its own TomCat server which control all the WAR files from the Alfrescos. The Pentaho has its own Tomcat server too… even changing the port of Pentaho to 8081, I cannot have the 2 TomCats running together… looks like when one of them is up, the other stops…

I put a picture of my server screen now, with the Alfresco's Tomcat Server Running, and the Pentaho's not being available… some minutes ago, with the Alfresco's Tomcat stopped, I was able to connect Pentaho's server… 😕

Re: AAAR installed, I followed this steps

macmarket — Mon, 19 May 2014 00:53:48 GMT

Re: AAAR installed, I followed this steps

iblanco — Thu, 19 Jun 2014 13:50:19 GMT

Eduardo:

To be able to make both tomcats work at same time I changed 3 ports in Pentaho's Business Intelligence Server.
Edit /biserver-ce/tomcat/conf/server.xml and change the mentions to port 8080 (the default HTTP connector), mentions to port 8009 (An AJP connector) and finally look for a mention to port 8005 as a SHUTDOWN port. Add 1 to all of them and you should be done.
Those are the defaults ports in Tomcat and if you don't change them in one of the tomcats stranges things happen.

Good luck.

Re: AAAR installed, I followed this steps

sandeepreddy1 — Thu, 09 Jun 2016 12:17:16 GMT

Hai alfresco forum,

How to get and install CDA, CDE and AAAR In pentaho Marketplace without internet connection in Redhat, can anyone help me out please