topic Location of CleanAlfPropTablesPostExec.sql in Alfresco Forum

Location of CleanAlfPropTablesPostExec.sql

vanson — Wed, 06 Feb 2019 10:47:06 GMT

I want to modify "CleanAlfPropTablesPostExec.sql". Please can someone help me find the location of this file.

Re: Location of CleanAlfPropTablesPostExec.sql

afaust — Thu, 07 Feb 2019 20:47:12 GMT

That script (and its DB-specific variants) can be found in this folder structure.

Though I would generally advise against using that script on large datasets (ironic, since I originally provided that script as a contribution), due to its brute force approach. I nowadays tend to use an incremental approach.

Re: Location of CleanAlfPropTablesPostExec.sql

vanson — Mon, 11 Feb 2019 10:36:04 GMT

Thanks for the reply. Have added the addons. Please dyu have any logs I can track to know is working?

Re: Location of CleanAlfPropTablesPostExec.sql

afaust — Mon, 11 Feb 2019 21:28:45 GMT

Sure - as you can see in the default log4j configuration of the addon, there are a couple of loggers that you can modify to get more/less logging (the ${project.artifactId} placeholder needs to be replaced with "de.acosix.alfresco.audit.repo"). For full detail, you may want to set both the job and DAO ("de.acosix.alfresco.audit.repo.dao") loggers to full on TRACE level. Since that may create a lot of log output, you may only want to activate TRACE level temporarily - this can be done at runtime e.g. via the OOTBee Support Tools, otherwise you'd have to restart the server for every change.

Re: Location of CleanAlfPropTablesPostExec.sql

vanson — Thu, 14 Feb 2019 06:47:10 GMT

Thank you.