Exception in renovator tool <pre>java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32767 characters</pre>

sindhuja55 commented 3 months ago

Required Information

[ ] AEM Version, including Service Packs, Cumulative Fix Packs, etc: _6.5.20__
[ ] ACS AEM Commons Version: _6.6.0
[ ] Reproducible on Latest? yes

Expected Behavior

Using Acs commons MCP renovator, to fetch the unreferenced assets and download the report in Excel

Actual Behavior

Unreferenced assets report was generated but while downloading the report it throws an exception.

Steps to Reproduce

When a single image is referenced in multiple pages and in multiple locales the cell size would overflow in "Referred in" column. Allowed cell size is 32,767. The following exception would be encountered

java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32767 characters

I found related issue has been fixed for tag report below https://github.com/Adobe-Consulting-Services/acs-aem-commons/issues/2146

Can this be fixed for renovator tool for assert report?

Thanks

Links

Links to related assets, e.g. content packages containing test components

sindhuja55 commented 2 months ago

Hi @klcodanr, @badvision,

Can you please let me know if this can be fixed in the upcoming release.

sindhuja55 commented 2 months ago

Hi @davidjgonzalez Can you let us know if this issue can be fixed in upcoming release. Actually we are planning to upgrade acs commons. If this this issue can be fixed we can wait until this and upgrade later

Adobe-Consulting-Services / acs-aem-commons