AnsweredAssumed Answered

AAAR Report Extraction and Publish error

Question asked by bagodu on Apr 4, 2018
Latest reply on Apr 17, 2018 by fcorti

Hi Team ,

 

Could you please help me on resolving the below issue , I was Extracting and Publishing the AAAR report , I ran the command manually , but below error was showing while Extracting (./AAAR_Extract.sh) 

 

2018/04/04 15:33:01 - Modified Java Script Value.0 - Stopped while putting a row on the buffer
2018/04/04 15:33:01 - Modified Java Script Value.0 - Stopped while putting a row on the buffer
2018/04/04 15:33:01 - Modified Java Script Value.0 - tran_Status found. Checking transformation status while script execution.
2018/04/04 15:33:01 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=1, W=13001, U=0, E=0)
2018/04/04 15:33:01 - Get Alfresco audit - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Errors detected!
2018/04/04 15:33:01 - Init audit staging - Finished job entry [Get Alfresco audit] (result=[false])
2018/04/04 15:33:01 - Init audit staging - Finished job entry [HTTP] (result=[false])
2018/04/04 15:33:01 - Init audit staging - Finished job entry [jsonPath] (result=[false])
2018/04/04 15:33:01 - Init audit staging - Finished job entry [Clean audit staging] (result=[false])
2018/04/04 15:33:01 - Init audit staging - Finished job entry [Get alfresco connection params] (result=[false])
2018/04/04 15:33:01 - Get audit - Finished job entry [Init audit staging] (result=[false])
2018/04/04 15:33:01 - Get all on a server - Finished job entry [Get audit] (result=[false])
2018/04/04 15:33:01 - Get all on a server - Finished job entry [get_audit] (result=[false])
2018/04/04 15:33:01 - Get all - Finished job entry [Get all on a server] (result=[false])
2018/04/04 15:33:01 - Get all - Finished job entry [Get all source id] (result=[false])
2018/04/04 15:33:01 - Get all - Job execution finished
2018/04/04 15:33:01 - Kitchen - Finished!
2018/04/04 15:33:01 - Kitchen - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Finished with errors
2018/04/04 15:33:01 - Kitchen - Start=2018/04/04 15:29:27.642, Stop=2018/04/04 15:33:01.378
2018/04/04 15:33:01 - Kitchen - Processing ended after 3 minutes and 33 seconds (213 seconds total).

Extraction complete!

 

 

And also on ./AAAR_Publish.sh, it was showing below error message 

 

A.A.A.R. - Alfresco Audit Analysis and Reporting
Export procedure version 4.0.
Author: Francesco Corti (all rights reserved)
Date: 07 November 2015

Disclaimer:
We can't be responsible for any damage done to your system,
which hopefully will not happen.

Please, enter the <data-integration> path (es.:/opt/data-integration): /data/data-integration/

You are going to execute this command:
./kitchen.sh /rep:"AAAR_Kettle" /job:"Report all" /dir:/Alfresco /user:admin /pass:admin /log="/root/.kettle/logs/AAAR.log" /level:Rowlevel

Press <enter> to start import.

Picked up _JAVA_OPTIONS: -Xms1024m -Xmx4048m -Dhttp.proxyHost=IP ADDRESS -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts="IP ADDRESS|localhost|127.0.0.1|10.*.*.*"
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleException:
Unable to create a logging event listener to write to file '/root/.kettle/logs/AAAR.log'
Error creating output file! Parent directory [/root/.kettle/logs] does not exist.

at org.pentaho.di.core.logging.FileLoggingEventListener.<init>(FileLoggingEventListener.java:79)
at org.pentaho.di.core.logging.FileLoggingEventListener.<init>(FileLoggingEventListener.java:56)
at org.pentaho.di.kitchen.Kitchen.main(Kitchen.java:234)
... 5 more
Caused by: java.io.IOException: Error creating output file! Parent directory [/root/.kettle/logs] does not exist.
at org.pentaho.di.core.vfs.KettleVFS.getOutputStream(KettleVFS.java:268)
at org.pentaho.di.core.logging.FileLoggingEventListener.<init>(FileLoggingEventListener.java:77)
... 7 more

 

 

The below error , i have extracted from AAAR.log file ,

 

2017/12/04 21:00:05 - HTTP - Connecting to URL: http://IP Address:8020/pentaho/api/repo/files/:public:AAAR:Reports
:audit_login.prpt
2017/12/04 21:00:05 - HTTP - Start reading reply from webserver.
2017/12/04 21:00:05 - HTTP - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : I was unable t
o save the HTTP result to file because of a I/O error: Connection refused
2017/12/04 21:00:05 - HTTP - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : java.net.Conne
ctException: Connection refused
2017/12/04 21:00:05 - HTTP - at java.net.PlainSocketImpl.socketConnect(Native Method)
2017/12/04 21:00:05 - HTTP - at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
2017/12/04 21:00:05 - HTTP - at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
2017/12/04 21:00:05 - HTTP - at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
2017/12/04 21:00:05 - HTTP - at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
2017/12/04 21:00:05 - HTTP - at java.net.Socket.connect(Socket.java:589)
2017/12/04 21:00:05 - HTTP - at java.net.Socket.connect(Socket.java:538)
2017/12/04 21:00:05 - HTTP - at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
2017/12/04 21:00:05 - HTTP - at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
2017/12/04 21:00:05 - HTTP - at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
2017/12/04 21:00:05 - HTTP - at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
2017/12/04 21:00:05 - HTTP - at sun.net.www.http.HttpClient.New(HttpClient.java:308)
2017/12/04 21:00:05 - HTTP - at sun.net.www.http.HttpClient.New(HttpClient.java:326)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:
1169)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:110
5)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:999)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:933)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1
513)
2017/12/04 21:00:05 - HTTP - at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:14
41)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.entries.http.JobEntryHTTP.execute(JobEntryHTTP.java:533)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:716)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:859)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:859)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.entries.http.JobEntryHTTP.execute(JobEntryHTTP.java:533)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:716)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:859)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:859)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.Job.execute(Job.java:598)
2017/12/04 21:00:05 - HTTP - at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:69)
2017/12/04 21:00:05 - HTTP - at java.lang.Thread.run(Thread.java:745)
2017/12/04 21:00:05 - Report - Finished job entry [HTTP] (result=[false])
2017/12/04 21:00:05 - Report - Finished job entry [Create report info] (result=[false])
2017/12/04 21:00:05 - Report all - Finished job entry [Create and upload report] (result=[false])
2017/12/04 21:00:05 - Report all - Finished job entry [Get all id] (result=[false])
2017/12/04 21:00:05 - Report all - Job execution finished
2017/12/04 21:00:05 - Kitchen - Finished!
2017/12/04 21:00:05 - Kitchen - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Finished with errors

 

Could you please help us on this.@@@@@#@

Outcomes