AnsweredAssumed Answered

AAAR 4.5: problem with the installation.

Question asked by arak on Apr 22, 2017
Latest reply on Apr 28, 2017 by arak

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.

Outcomes