topic Re: Alfresco limits for import of peer-to-peer associations in Alfresco Forum

Alfresco limits for import of peer-to-peer associations

miroslav — Wed, 02 Jun 2021 07:53:14 GMT

Hello,

I want to import a large number of peer-to-peer associations (more than a thousand associated nodes to primary file) in one transaction and the operation is rollbacked. No errors in the log. The import took several minutes.

Is there some Alfresco limit I could exceed (transaction time, number of peer-to-peer associations)?

Thank you.

Re: Alfresco limits for import of peer-to-peer associations

afaust — Wed, 02 Jun 2021 13:15:45 GMT

There is absolutely no hard limit in Alfresco for the number of associations or duration of transactions. But speaking from experience, peer-to-peer association handling is one of the areas with generally poor performance that scales excessively with larger numbers of associations due to being based solely on a query-all-and-match-via-regex approach, instead of supporting targeted by-qname-id retrievals. So I would not be surprised if an import of a high number of association triggers an implicit read- or operation timeout set by the JDBC driver or on the DB server.

Re: Alfresco limits for import of peer-to-peer associations

miroslav — Fri, 04 Jun 2021 11:51:00 GMT

The problem was in the names of the files that were inserted in one transaction. There was a space in the filename. replace operation ended with "primary node does not exist" error.

Re: Alfresco limits for import of peer-to-peer associations

EddieMay — Wed, 09 Jun 2021 09:10:01 GMT

Hi @miroslav

Great that you got a solution and thanks for updating your thread.

Best wishes,