OOTB users to CSV exports not working

[AndreaHgy]

Required Information

• [ ] AEM Version, including Service Packs, Cumulative Fix Packs, etc: AEM 6.5 SP17
• [ ] ACS AEM Commons Version: 6.0.14
• [ ] Reproducible on Latest? yes

Concerned path: Tools > ACS AEM Common > CSV Exporters > Users to CSV Exporter issue => We have the possibility to create specific exports to identify and extract users according to their role. This allows us to track activity on the platform.

When creating a report, we select the roles to be extracted. Then, report can be downloaded. => Lately we were creating a report, and selecting the roles to be extracted. Normally the report should be available then to download, but we are having a lot of lag issues, and the interface becomes unresponsive, and the browser pages stop to respond.

Do you know what the issue might be? Thank you!

[Cooper57138]

@YegorKozlov , is there a pressing need to perform this sort operation?

https://github.com/Adobe-Consulting-Services/acs-aem-commons/blob/master/bundle/src/main/java/com/adobe/acs/commons/exporters/impl/users/UsersExportServlet.java

This sorting is being done for every user record and with increasing number of users, it could contribute significantly to the performance overhead.

[Cooper57138]

@AndreaHgy , any idea how many records we are trying to export here ?

[mbenhlima]

hello we have arround 213K users (active and not active users). But the export is working on PROD and not on stage environment (where the infrastructure is less performant). So can you confirm it's the root cause? and how can we debug it or be sure what the cause is?