Products Fixtures generation Error: The entity ID field for the "catalog_data_exporter_products_cl" table wasn't found.

[lucafuser]

Both simple products and configurable products fixtures generation goes on error during CLI command : The entity ID field for the catalog_data_exporter_products_cl table wasn't found. Verify the field and try again.

Preconditions (*)

1. Vanilla Magento Enterprise on Prem. 2.4.6-p4
2. Catalog Service module installed

   composer require magento/catalog-service=^3.0.1

Steps to reproduce (*)

1. Run CLI command setup:perf:generate-fixtures with existing profile file path:

   bin/magento setup:perf:generate-fixtures setup/performance-toolkit/profiles/ee/medium.xml

Expected result (*)

1. For simple products: Generating simple products... done
   For configurable products: Generating configurable products... done

Actual result (*)

1. For simple products: Generating simple products... The entity ID field for the "catalog_data_exporter_products_cl" table wasn't found. Verify the field and try again.
   For configurable products: Generating configurable products... The entity ID field for the "catalog_data_exporter_products_cl" table wasn't found. Verify the field and try again.

[sofia-doofinder]

hello @lucafuser did you find any way to avoid this error?

Thank you

[lucafuser]

Hi @sofia-doofinder on 2.4.6-p4 EE, one year ago I applied this workaround to skip _cl tables:

diff --git a/setup/src/Magento/Setup/Model/FixtureGenerator/SqlCollector.php b/setup/src/Magento/Setup/Model/FixtureGenerator/SqlCollector.php
--- a/setup/src/Magento/Setup/Model/FixtureGenerator/SqlCollector.php	
+++ b/setup/src/Magento/Setup/Model/FixtureGenerator/SqlCollector.php
@@ -96,7 +96,16 @@
      */
     public function getSql()
     {
-        return $this->sql;
+        $result = $this->sql;
+
+        try {
+            return array_filter($result, static function ($item) {
+                return !str_ends_with($item[1], '_cl');
+            });
+        } catch (\Throwable $e) {
+            return $result;
+        }
+
     }
 
     /**

[duhon]

Hello @lucafuser, apologies for the delay.

This is an issue I already fixed here in 2023, but for reasons unknown to me, the fix is not fully effective. As a result, an internal task was created for the performance generator developers. In this repository, we cannot resolve this issue any further than what has already been done.