AAAR Dimension update 3 issues

[jsimonet]

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...

Regards

Jeremie

[jsimonet]

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.

[fcorti]

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.

[jsimonet]

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.

[jsimonet]

Hello,

I posted the Publish issues here:  

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

[jsimonet]

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.

[fcorti]

Sorry, I don't get the issue.

[jsimonet]

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.

[jsimonet · Accepted solution]

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

[fcorti]

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