GetCounters error

[jsimonet]

Hello Everyone,

I am having some issues with the GetCounter Alfresco API being called form AAAR_Extract.

This is my database connection properties in alfresco-global.properties:

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=[I removed]
db.name=alfresco
db.url=jdbcostgresql://[changed to address of server]:5432/${db.name}
# Note: your database must also be able to accept at least this many connections. Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

I have also attached log file.

Can someone help me out please?

[fcorti]

Hi Jèrèmie,

Looking at your log file, the first issue I see is about an error 400 accessing to the following URL.

http://52.59.226.105:8080/alfresco/service/AAAR/getCounters?counter=auditTrail&application=alfresco-... 

I don't think the error here is related to the access to the DB.

Instead, I think there are some issue with the endpoint.

Assuming the ip address is public, I can have access to http://52.59.226.105:8080/share but not to http://52.59.226.105:8080/alfresco...

I suggest to check this.

Let us know how it goes.

[jsimonet]

Hello,

Thanks for the reply. I am now using DNS name instead of ip address. Still getting the error, but the extraction end correctly. The endpoint is on Amazon, maybe there are some issues resolving the ip address. I also changed the Global file for alfresco to reflect the changes. I am now launching the Publish.

Thanks for the help. Ignoring this error as long as I can publish.

Will update as I go along

[jsimonet]

Hi,

I am still getting the GetCounters errors but Pentaho reports are working even so. Maybe I will try to check the error later or if someone else is having the solution. Its not a blocking factor right now.

[fcorti]

Hi Jeremie, 

The GetCounter affects the data quality check and you are right: it does not affect the data extraction.