GetCounters error

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

GetCounters error

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=jdbcSmiley Tongueostgresql://[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?

4 Replies
Alfresco Employee

Re: GetCounters error

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.

Active Member II

Re: GetCounters error

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

Active Member II

Re: GetCounters error

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.

Alfresco Employee

Re: GetCounters error

Hi Jeremie, 

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