- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-27-2017 04:26 AM
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
- Labels:
-
Alfresco Content Services
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 09:09 AM
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.
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2017 01:14 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2017 07:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2017 01:16 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2017 01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 12:15 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 01:54 AM
Sorry, I don't get the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 03:47 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 09:09 AM
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.
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-20-2017 06:19 AM
Ehi, thank you for sharing the result.
Yes, on Amazon you can have the static IP paying a fee.