Help

AAAR 4.5: problem with the installation.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
arak
Active Member
‎22 Apr 2017 2:46 PM

AAAR 4.5: problem with the installation.

Hi,

I use Alfresco CE 5.1.e, Pentaho 7, Postgres 9.4 and AAAR 4.5. My installation of AAAR ends with this:

2017/04/21 15:35:43 - _installPostgreSql - Starting entry [Success]
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Success] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Upload olap] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Upload reports] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Upload main] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Set repository] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Set JNDI for AAAR_Kettle 2] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Set JNDI for AAAR_DataMart 2] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Set JNDI for AAAR_Kettle] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Set JNDI for AAAR_DataMart] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Alfresco FTP] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Alfresco connection] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Restore AAAR_Kettle] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Restore AAAR_DataMart] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Recreate databases] (result=[true])
2017/04/21 15:35:43 - _installPostgreSql - Finished job entry [Check Db connections] (result=[true])

2017/04/21 15:35:43 - _pentahoAddDatasource - Loading transformation from XML file [file:///opt/pentaho-server/pentaho-solutions/system/AAAR/endpoints/kettle/_pentahoAddDatasource.ktr]
2017/04/21 15:35:43 - _pentahoAddDatasource - Dispatching started for transformation [_pentahoAddDatasource]
2017/04/21 15:35:43 - Data Grid.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2017/04/21 15:35:43 - AAAR_Repository.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2017/04/21 15:35:43 - AAAR_AuditTrail.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2017/04/21 15:35:43 - Add root to file.0 - Optimization level set to 9.
2017/04/21 15:35:44 - Append streams.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
2017/04/21 15:35:44 - Get trasformation root.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
2017/04/21 15:35:44 - Add root to file.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
2017/04/21 15:35:44 - Generate multipart entity.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
2017/04/21 15:44:12 - HTTP Post.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Because of an error, this step can't continue:
2017/04/21 15:44:12 - HTTP Post.0 - Can not result from [http://xxx.xxx.xx.xxx:8084/pentaho/plugin/data-access/api/mondrian/postAnalysis]
2017/04/21 15:44:12 - HTTP Post.0 - Connection timed out
2017/04/21 15:44:12 - HTTP Post.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/04/21 15:44:12 - HTTP Post.0 - Can not result from [http://xxx.xxx.xx.xxx:8084/pentaho/plugin/data-access/api/mondrian/postAnalysis]
2017/04/21 15:44:12 - HTTP Post.0 - Connection timed out
2017/04/21 15:44:12 - HTTP Post.0 -
2017/04/21 15:44:12 - HTTP Post.0 -     at org.pentaho.di.trans.steps.httppost.HTTPPOST.callHTTPPOST(HTTPPOST.java:308)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.pentaho.di.trans.steps.httppost.HTTPPOST.processRow(HTTPPOST.java:454)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.lang.Thread.run(Thread.java:745)
2017/04/21 15:44:12 - HTTP Post.0 - Caused by: java.net.ConnectException: Connection timed out
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.PlainSocketImpl.socketConnect(Native Method)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.Socket.connect(Socket.java:589)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.Socket.connect(Socket.java:538)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.Socket.<init>(Socket.java:434)
2017/04/21 15:44:12 - HTTP Post.0 -     at java.net.Socket.<init>(Socket.java:286)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.pentaho.di.trans.steps.httppost.HTTPPOST.requestStatusCode(HTTPPOST.java:318)
2017/04/21 15:44:12 - HTTP Post.0 -     at org.pentaho.di.trans.steps.httppost.HTTPPOST.callHTTPPOST(HTTPPOST.java:211)
2017/04/21 15:44:12 - HTTP Post.0 -     ... 3 more
2017/04/21 15:44:12 - HTTP Post.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2017/04/21 15:44:12 - _pentahoAddDatasource - Transformation detected one or more steps with errors.
2017/04/21 15:44:12 - _pentahoAddDatasource - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Errors detected!
2017/04/21 15:44:12 - _pentahoAddDatasource - Transformation is killing the other steps!
2017/04/21 15:44:13 - REST DELETE.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Because of an error, this step can't continue:
2017/04/21 15:44:13 - REST DELETE.0 - Can not result from [http://xxx.xxx.xx.xxx:8084/pentaho/plugin/data-access/api/connection/deletebyname?name=AAAR_DataMart]
2017/04/21 15:44:13 - REST DELETE.0 - java.net.ConnectException: Connection timed out
2017/04/21 15:44:13 - REST DELETE.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleException:
2017/04/21 15:44:13 - REST DELETE.0 - Can not result from [http://xxx.xxx.xx.xxx:8084/pentaho/plugin/data-access/api/connection/deletebyname?name=AAAR_DataMart]
2017/04/21 15:44:13 - REST DELETE.0 - java.net.ConnectException: Connection timed out
2017/04/21 15:44:13 - REST DELETE.0 -
2017/04/21 15:44:13 - REST DELETE.0 -     at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:251)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.pentaho.di.trans.steps.rest.Rest.processRow(Rest.java:475)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.lang.Thread.run(Thread.java:745)
2017/04/21 15:44:13 - REST DELETE.0 - Caused by: com.sun.jersey.api.client.ClientHandlerException: java.net.ConnectException: Connection timed out
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.client.apache.DefaultApacheHttpMethodExecutor.executeMethod(DefaultApacheHttpMethodExecutor.java:213)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.client.apache.ApacheHttpClientHandler.handle(ApacheHttpClientHandler.java:175)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.api.client.filter.HTTPBasicAuthFilter.handle(HTTPBasicAuthFilter.java:105)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.api.client.Client.handle(Client.java:652)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.api.client.WebResource.handle(WebResource.java:682)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.api.client.WebResource$Builder.delete(WebResource.java:601)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.pentaho.di.trans.steps.rest.Rest.callRest(Rest.java:181)
2017/04/21 15:44:13 - REST DELETE.0 -     ... 3 more
2017/04/21 15:44:13 - REST DELETE.0 - Caused by: java.net.ConnectException: Connection timed out
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.PlainSocketImpl.socketConnect(Native Method)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.Socket.connect(Socket.java:589)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.Socket.connect(Socket.java:538)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.Socket.<init>(Socket.java:434)
2017/04/21 15:44:13 - REST DELETE.0 -     at java.net.Socket.<init>(Socket.java:286)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
2017/04/21 15:44:13 - REST DELETE.0 -     at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
2017/04/21 15:44:13 - REST DELETE.0 -     at com.sun.jersey.client.apache.DefaultApacheHttpMethodExecutor.executeMethod(DefaultApacheHttpMethodExecutor.java:210)
2017/04/21 15:44:13 - REST DELETE.0 -     ... 10 more
2017/04/21 15:44:13 - REST DELETE.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2017/04/21 15:44:13 - _pentahoAddDatasource - Transformation detected one or more steps with errors.
2017/04/21 15:44:13 - _pentahoAddDatasource - Transformation is killing the other steps!
2017/04/21 15:44:13 - _pentahoAddDatasource - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Errors detected!
2017/04/21 15:44:13 - _installFromConfiguration - Finished job entry [_pentahoAddDatasource] (result=[false])
2017/04/21 15:44:13 - _installFromConfiguration - Finished job entry [_installPostgreSql] (result=[false])
2017/04/21 15:44:13 - _installFromConfiguration - Finished job entry [Check databaseType = 'PostgreSql'] (result=[false])
2017/04/21 15:44:13 - _installFromConfiguration - Finished job entry [_readConfigurationInVariables] (result=[false])
2017/04/21 15:44:13 - _installFromConfiguration - Finished job entry [Checks if files exist] (result=[false])
2017/04/21 15:44:13 - installFromConfiguration - Finished job entry [_installFromConfiguration] (result=[false])
2017/04/21 15:44:13 - installFromConfiguration - Job execution finished
....

Anyway, I'm try to extract the data, and I got more errors (I attach the errors that I found [Extract_Errors]). In addition, the Pentaho console triggers other errors (I attach the errors found [Pentaho_Errors]).

Finally, i'm try to see if a report was generated in the graphical environment, and I get errors with the interface:



And this:



Thanks for any guide or help.

Greetings,
Pablo.
Pentaho_Errors.zip
Extract_Errors.zip
0 Kudos
4 Replies
fcorti
Alfresco Employee
‎22 Apr 2017 4:13 PM

Re: AAAR 4.5: problem with the installation.

Hi Arak,

The log file says 'Connection timed out' trying to connect to http://XXX.XXX.XXX.XXX:9999.

The issue seems to be related to a network configuration.

I hope it helps you.

0 Kudos
arak
Active Member
‎22 Apr 2017 9:15 PM

Re: AAAR 4.5: problem with the installation.

Hi Francesco,

Thanks for your answer, this may be the problem. This IP is the public address where Pentaho, Alfresco is installed and all the tools required for AAAR, maybe it should point to "localhost" instead of the public IP, but I do not know where to make that configuration so that it points only to "localhost". In the previous step of setting up AAAR I set "localhost", but for some reason, at the end of the installation, it points to public IP.

Any idea?

Greetings.

0 Kudos
fcorti
Alfresco Employee
‎23 Apr 2017 9:12 AM

Re: AAAR 4.5: problem with the installation.

The IP address is extracted automatically from the URL of your browser.

I can see three alternatives:

1) You run the installation using the localhost (from the server). This could be a problem is you don't have the user interface into your server.

2) You can run the AAAR_Install.sh script from the server. This server execute the installation process in the same way but from the command line.

3) You manually install AAAR using the document below.

alfresco-audit-analysis-reporting/AAAR_Manual_Installation.pdf at master · fcorti/alfresco-audit-ana... 

I hope it helps you.

0 Kudos
arak
Active Member
‎28 Apr 2017 3:12 PM

Re: AAAR 4.5: problem with the installation.

Hi Francesco,

Thanks for your help, I execute the AAAR_Install.sh from the server and it works.

Greetings,

Pablo Arak.

Alfresco Content Services Forum

Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.

Related links:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.