topic Re: AAAR data does not increase in Alfresco Forum

AAAR data does not increase

alexsander_pere — Thu, 30 Nov 2017 19:12:38 GMT

Hello ‌I am conducting the AAAR extraction process. The variables alfrescoAuditLimit and alfrescoNodeLimit are set to the value 50000. When executing the extraction, the 50000 actions are inserted, however when running the second time the data is not incremented. The same data was imported. In the d

Re: AAAR data does not increase

fcorti — Fri, 01 Dec 2017 11:02:00 GMT

Hi Alex,

Usually when this happen is because there is an error in the import job and the batch is not able to correctly get the audit trail in the warehouse.

This could be the reason why at the second run, the extraction get the same data: each time the job checks the extracted data from the warehouse to define what has to be extracted more.

I recommend you to check the Pentaho catalina.out, if you have any error.

I hope this help.

Re: AAAR data does not increase

alexsander_pere — Mon, 04 Dec 2017 17:07:52 GMT

I am sending the process logs.

Since the creation of the AAAR bank, the first execution and the second execution after 1 hour.

I could not identify the reason for not increasing.

Would you help me?

I am also sending my configuration file.

log.tar.gz

Re: AAAR data does not increase

fcorti — Fri, 08 Dec 2017 17:32:25 GMT

Hi Alex,

The log says:

09:40:15,913 ERROR [ConnectionServiceImpl] ConnectionServiceImpl.ERROR_0004 - Unable to add connection name : connection name was AAAR_DataMart caused by null
2017/12/04 09:40:15 - Abort.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Row nr 1 causing abort : [null], [{"changed":true,"connectSql":"","databaseName":"AAAR_DataMart","databasePort":"3306","hostname":"localhost","name":"AAAR_DataMart","password":"...","username":"root","attributes":{},"connectionPoolingProperties":{},"extraOptions":{},"accessType":"NATIVE","databaseType":{"defaultDatabasePort":"3306","extraOptionsHelpUrl":"http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html","name":"MySQL","shortName":"MYSQL","supportedAccessTypes":["NATIVE","ODBC","JNDI"]}}], [409]
2017/12/04 09:40:15 - Abort.0 - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Aborting after having seen 1 rows.

For some reasons the datasource name cannot be added.

The extraction fails because the AAAR is not correctly installed.

You can manually add the data source, if you want.

I hope this will help.