topic Re: AAAR Dimension update 3 issues in Alfresco Forum

AAAR Dimension update 3 issues

jsimonet — Thu, 27 Apr 2017 08:26:59 GMT

Hi,I am having some issues with AAAR extraction. its failing. Please find attached log.Can anyone help me on that? Thanks.I have been tryning to get something on the dashboards for weeks now...RegardsJeremie

Re: AAAR Dimension update 3 issues

jsimonet — Wed, 10 May 2017 17:14:12 GMT

I am still having same issues during extraction which takes 1h for me. If anyone got the same issue. Let me know. I really need some help here.

Re: AAAR Dimension update 3 issues

fcorti — Mon, 15 May 2017 11:57:00 GMT

Hi Jeremie,

The first error is about getCounter and you can ignore, is not a blocking issue.

The second error (severe error) says your AAAR_Kettle repository is corrupted.

I suggest you to reinstall AAAR again or replace the AAAR_Kettle database.

I hope this will help you.

Re: AAAR Dimension update 3 issues

jsimonet — Tue, 16 May 2017 05:16:16 GMT

Reinstalled changed ip to DNS and modified global file to reflect same instead of using localhost, except fot the first parameters which I left as localhost. Now trying to publish. Ignoring this error, for now.

Re: AAAR Dimension update 3 issues

jsimonet — Tue, 16 May 2017 05:23:39 GMT

Hello,

I posted the Publish issues here:

If you can check please I'm stuck...

Re: AAAR Dimension update 3 issues

jsimonet — Fri, 19 May 2017 04:15:12 GMT

I believe my repository got corrupted again getting Dimension 3 update issues...Reinstalled AAAR. I examined the Mapping but could not understand a thing. Its taking an ID and then filling the dates table. If someone can explain how it I can avoid this.

I will try to re-install my kettle repository.

Re: AAAR Dimension update 3 issues

fcorti — Fri, 19 May 2017 05:54:07 GMT

Sorry, I don't get the issue.

Re: AAAR Dimension update 3 issues

jsimonet — Fri, 19 May 2017 07:47:47 GMT

I am getting the same error as attached in the log file again. I believe my repository is corrupted. I did a re-install as last time you suggested but this time its not working...trying to solve this issue.

Re: AAAR Dimension update 3 issues

jsimonet — Fri, 19 May 2017 13:09:58 GMT

I re-installed Pentaho server. It was not able to re-create the Kettle repository connection where Installing AAAR (As per log). Now trying extraction. Installation went smoothly. There was a wrong connection also in C:\pdi-ce-7.0.0.0-25\data-integration\simple-jndi\jdbc.properties.

One problem with amazon is that sometimes the Public address changes on the VMs.

# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_DataMart.
AAAR_DataMart/type=javax.sql.DataSource
AAAR_DataMart/driver=org.postgresql.Driver
AAAR_DataMart/url=jdbcostgresql://ec2-99-99-999-999.eu-central-1.compute.amazonaws.com:5432/AAAR_DataMart
AAAR_DataMart/user=postgres
AAAR_DataMart/password=XXX

# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_Kettle.
AAAR_Kettle/type=javax.sql.DataSource
AAAR_Kettle/driver=org.postgresql.Driver
AAAR_Kettle/url=jdbcostgresql://ec2-99-99-999-999.eu-central-1.compute.amazonaws.com:5432/AAAR_Kettle
AAAR_Kettle/user=postgres
AAAR_Kettle/password=XXX

Re: AAAR Dimension update 3 issues

fcorti — Sat, 20 May 2017 10:19:26 GMT

Ehi, thank you for sharing the result.
Yes, on Amazon you can have the static IP paying a fee.