ACSD-67518: Advanced Reporting generates duplicated header rows when the row count exceeds the batch…

Categories

Reports

Components

magento/module-analytics

Origin

adobe-commerce-support

Since QPT

1.1.72

Issue

Advanced Reporting generates duplicated header rows when the row count exceeds the batch size.

Steps to reproduce

1. Go to Stores > Settings > Configuration > General > Advanced Reporting. Verify that Advanced Reporting Service is set to Enable. 1. Generate a large number of customers so the entries during analytics export gets divided and processed in batches (default batch size is 10000). 1. Execute the analytics_collect_data cron manually or wait for it to run as per the configured schedule. 1. Decrypt and extract the generated data.tgz file in pub/media/analytics/. 1. Open customers.csv and observe the number of headers.

Adobe's page lists 2.4.8 - 2.4.8-p2 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.9.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-67518. On Cloud, add ACSD-67518 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-67518/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-67518
• JSON API: /api/v1/patches/ACSD-67518