AAAR Dimension update 3 issues

cancel
Showing results for 
Search instead for 
Did you mean: 
jsimonet
Active Member II

AAAR Dimension update 3 issues

Jump to solution

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

1 Solution

Accepted Solutions
jsimonet
Active Member II

Re: AAAR Dimension update 3 issues

Jump to 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=jdbcSmiley Tongueostgresql://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=jdbcSmiley Tongueostgresql://ec2-99-99-999-999.eu-central-1.compute.amazonaws.com:5432/AAAR_Kettle
AAAR_Kettle/user=postgres
AAAR_Kettle/password=XXX

View solution in original post

9 Replies
jsimonet
Active Member II

Re: AAAR Dimension update 3 issues

Jump to solution

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
Alfresco Employee

Re: AAAR Dimension update 3 issues

Jump to solution

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
Active Member II

Re: AAAR Dimension update 3 issues

Jump to solution

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
Active Member II

Re: AAAR Dimension update 3 issues

Jump to solution

Hello,

I posted the Publish issues here:  

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

jsimonet
Active Member II

Re: AAAR Dimension update 3 issues

Jump to solution

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
Alfresco Employee

Re: AAAR Dimension update 3 issues

Jump to solution

Sorry, I don't get the issue.

jsimonet
Active Member II

Re: AAAR Dimension update 3 issues

Jump to solution

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
Active Member II

Re: AAAR Dimension update 3 issues

Jump to 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=jdbcSmiley Tongueostgresql://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=jdbcSmiley Tongueostgresql://ec2-99-99-999-999.eu-central-1.compute.amazonaws.com:5432/AAAR_Kettle
AAAR_Kettle/user=postgres
AAAR_Kettle/password=XXX
fcorti
Alfresco Employee

Re: AAAR Dimension update 3 issues

Jump to solution

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