“Message is added to queue, wait to get your file soon. Make sure your cron job is running to export the file”

The error we encounter when generating CSV files primarily occurs on older versions of Magento. To address this, we typically need to manually execute either the cron or queue run to resolve the issue.

Step 1
php bin/magento cron:run

Step 2
php bin/magento queue:consumers:start exportProcessor

Step 3
Disable the the Add Secret Key to URL option

• In the Magento Admin, navigate to Stores > Configuration > Advanced > Admin > Security.
• Set the Add Secret Key to URLs option to No.
• Click Save Config.
• Clean cache under System > Tools > Cache Management or by running bin/magento cache:clean or in Magento Admin.

As this method, we are not recommending, this because enabling this option is necessary to prevent CSRF attacks:
Cross-site request forgery, also known as a one-click attack or session riding and abbreviated as CSRF

Step 4
To address the issue, we advise updating the env.php block code for the lock by incorporating a prefix.

From


'lock' => [

    'provider' => 'db',

    'config' => [

      'prefix' => ''

    ]

  ],

TO


'lock' => [

    'provider' => 'db',

    'config' => [

      'prefix' => 'lintechops'

    ]

  ],