nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Enormous table alf_prop_link, what is this?

robertocappa

On my Alfresco 4.0d database schema, the alf_prop_link table has reached a very very large size, but there are no so many documents in the system.

I suspected this was related to old audit data, so I've used the Audit clean API. The audit_entry was empty after the cleaning procedure, but the big table was not changed.

Anyone can help me about the meaning of this table?

I am astonished that a popular document system like Alfresco has no documentation about DB Tables a and Columns.

Thanks.

Find more posts tagged with

Comments

7joeblack8

Have you tried to delete permanently images through the Alfresco Explorer?

robertocappa

Sorry, I'm not familiar with this concept. What do you mean exactly with "images"?

7joeblack8

i mean, u could try to delete permanently the document and restart alfresco.
Maybe after all this procedure it will rebuild indexes and delete old properties data.

robertocappa

No, I've already tried to force clean, and rebuild indexes, but there is not changes in this table. By the way, the row count is exactly the same since months, also if documents where added/removed.

mariolebrun

That table is linked to Alfresco audit services. We are using alfresco 3.4d (migrating slowly to 4.2e) and that table will stop growing if you modify your alfresco-global.properties file. You just have to modify

# Audit service
audit.enabled=true
audit.dod5015.enabled=true

to
# Audit service
audit.enabled=false
audit.dod5015.enabled=false

of course you will loses auditing capabilities but for us it wasn't an issue !

Hope it will help !