We did an upgrade from version 2.4.3 to the version 2.4.6-p1 and we started to have a problem on cloud environments (production and staging, but mostly on production) but not locally.
So, the steps to reproduce are being these:
-
Go to System > Import page, select product and Add/Update.
-
Click on upload button and select the csv (simple csv with 7 simple products and 7 grouped products). I get an error: “The source file moving process failed”
-
Refresh the page
-
Do all again, the error “The source file moving process failed” doesn’t show up anymore.
-
Click in Check Data
-
Upload
-
The error of the image( General system exception happened: Integrity constraint violation… shows up).
>SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails[At this moment, all products are being created but with not data, only sku)
-
Try import again, same steps
-
Now there is success and all products have their info populated.
This is an annoying issue cause it’s happening only on production and sometimes on staging but never on local environments.
We have tried a few things like:
- Create new admin users
- Validated all csv fields including website_id, websites, etc…
- Enabled old media gallery admin option (to solve the “The source file moving process failed” issue)
- Checked the disk space of all nodes 5 – Checked all special characters on csv (There is no special characters)
- I also checked the constraints, there is no duplicate keys.