topic Re: About "AAAR_Extract" cannot work successfully in Alfresco Forum

About "AAAR_Extract" cannot work successfully

wm1994 — Sun, 05 Feb 2017 11:12:59 GMT

Hi Francesco,I'm following your steps to install A.A.A.R,every step goes successfully.But when I use it,it tells me "no data found"(I've already upload some datas on alfresco),and I have runned "AAAR_Extract",But nothing has changed,and "AAAR_Extract.bat"was drop out immediately! I check "pentaho-so

Re: About "AAAR_Extract" cannot work successfully

fcorti — Sun, 05 Feb 2017 11:40:17 GMT

Hi ‌,

Please check the catalina.out file into the penatho server installation.
I think you will find an error during the installation process.

If you can, I suggest to move to a linux based platform.
Let me know how it goes.

Cheers.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Sun, 05 Feb 2017 13:15:27 GMT

I can only find the log file "catalina" in " pentaho-server\tomcat\logs" ,I have uploaded it, is it right? If it's right,there is no error in that file.

Unn.. and I don't have linux platform around.... only windows,with this issue..What should I do?

thank you a lot.

Re: About "AAAR_Extract" cannot work successfully

fcorti — Mon, 06 Feb 2017 07:18:40 GMT

Yes, I was talking exactly about catalina.out file in the logs folder of the pentaho server.
Please:
- stop Pentaho server,

- remove the catalina.out file,

- restart the pentaho server again

- install AAAR as described here: A.A.A.R. - Install A.A.A.R. - Francesco Corti

- stop Pentaho server,

- check into the catalina.out for errors and share it here using this site: Pastebin.com - #1 paste tool since 2002!

Then we will see what happened.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Mon, 06 Feb 2017 16:11:25 GMT

Hi Francesco,

I finished what you said，but because of network or VPN limitations,I cannot open the site " Pastebin.com - #1 paste tool since 2002!"，So I have to upload " catalina.out " on this page. Please check the Attachment above. I feel sorry about that.

Thank you for help. 🙂

Re: About "AAAR_Extract" cannot work successfully

fcorti — Tue, 07 Feb 2017 06:34:45 GMT

No problem.

From the log I can see a problem in your settings.

In particular in:

2017/02/06 20:24:32 - Set Variables.0 - Set variable kettlePath to value [/opt/data-integration]

Please setup the correct path (this is the default path and works for linux)) for the Pentaho Data Integration using the wizard and repeat the installation.

Then execute again the extraction.

I hope this help you.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Tue, 07 Feb 2017 16:32:40 GMT

Hi Francesco,

Are there any other problems? I have modified " /opt/data-integration " into the right path ("D:\aaar_毕设\data-integration") , But there are still errors in the logs file, and re-installation was failed again...

I have updated the "catalina.out" in this page. Please check the Attachment again.

Thanks again for your help 🙂

Re: About "AAAR_Extract" cannot work successfully

fcorti — Wed, 08 Feb 2017 06:36:12 GMT

Hi,

Ok, now it's time to check the AAAR_DataMart datasource is correctly setup into the Pentaho Console.

Open the Pentaho User Console and access to the data source using the top left item on the screen called "Manage Datasources".

Inside of it you should see a AAAR_DataMart data source if not, please let me know.

If you will find it, execute the AAAR_Extract.bat from the terminal (you find the script into the script folder into the AAAR module folder).

Then share the catalina.out again.

Cheers.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Wed, 08 Feb 2017 08:10:18 GMT

Hi Francesco,

Inside of "Manage Datasources" I could see " AAAR_DataMart "

Then I stoped the pentaho-server and restart it again.When I try to execute the AAAR_Extract.bat from the terminal,it likes the first time, quickly quit, and nothing happened.And it seems that execute AAAR_Extract.bat has not been written to " catalina.out ". This is the latest catalina.out file. (I have updated in this page).

This image is when I open the " AAAR_extract.bat". I noticed the text inside "/user:admin /pass:admin /param....." My Alfresco login password is "password" not "admin",is it related to "AAAR_extract.bat" drop out immediately？

Thanks

Re: About "AAAR_Extract" cannot work successfully

fcorti — Wed, 08 Feb 2017 08:16:41 GMT

The rapid execution of the batch, means an error happens at the very beginning.

The error is shown in clear, if you execute the bat from the terminal (avoid double clicking on the file please).

Please reach the description of the error and then we will face it.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Wed, 08 Feb 2017 10:26:04 GMT

OK,after I modified "pass:admin" into "passassword",I execute the bat from the terminal.The following results were obtained.I have uploaded it in this page, and named it "AAAR_Extract log".

Re: About "AAAR_Extract" cannot work successfully

fcorti — Thu, 09 Feb 2017 06:55:09 GMT

The log is clear:
Incorrect password or login

The requested login and password are the one of the Kettle repository and should be "admin"/"admin".
The reason of the issue is elsewhere... please check again.

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Thu, 09 Feb 2017 07:13:44 GMT

Hi Francesco,

Right ,When I modified password into "admin", everything worked successfully! The data also appeared like the picture shows!

Does this mean that the installation is no problem?

Extremely grateful for these days of help 🙂

Re: About "AAAR_Extract" cannot work successfully

fcorti — Thu, 09 Feb 2017 07:18:13 GMT

Congratulations!
You AAAR installation is running perfectly (also into your Windows environment).
What you see here is the actions from you audits.

If you change the view in the top left list, you will see the repository and workflow view.

Enjoy!

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Thu, 09 Feb 2017 07:41:51 GMT

Yeah!Cheers! Thank you very much for your help these days,and from which I have learned a lot.I will show the greatful of "AAAR" to the people around me! And I'm a chinese,if you have the opportunity to come to China,Please leave me a message.I‘m very glad to entertain you and show you around.

Thanks again for your help! 🙂

Re: About "AAAR_Extract" cannot work successfully

fcorti — Thu, 09 Feb 2017 08:05:14 GMT

Thank you for your feedback and really appreciated your contribution to the project, talking about it around.
Ohhh, I would love to come to China. Let's see in the future... who knows. 🙂

Re: About "AAAR_Extract" cannot work successfully

wm1994 — Thu, 09 Feb 2017 08:13:09 GMT

Okey.I will waiting for you 🙂

Re: About "AAAR_Extract" cannot work successfully

amar7295 — Tue, 18 Aug 2020 04:44:17 GMT

hi Francesco,

is it compulsory to install Postgre/MySQL while installing Pentaho and Alflytics?

thanks and regards,

Amar.