Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign...

[sentry-io]

Sentry Issue: SHIPTOWN-STAGING-K

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`guineys_products_management`.`inventory_reservations`, CONSTRAINT `inventory_reservations_product_sku_foreign` FOREIGN KEY (`product_sku`) REFERENCES `products` (`sku`) ON DELETE CASCADE ON U)
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 46, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::App\Modules\ActiveOrdersInventoryReservations\src\Listeners\{closure}
    'custom_uuid' => ReservationsService::getUuid($orderProduct),
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 50, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::handle
    });
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Observers/ConfigurationObserver.php", line 12, in App\Modules\ActiveOrdersInventoryReservations\src\Observers\ConfigurationObserver::updated
    ConfigurationUpdatedEvent::dispatch($configuration);
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Http/Controllers/Api/Modules/ActiveOrdersInventoryReservationsController.php", line 23, in App\Modules\ActiveOrdersInventoryReservations\src\Http\Controllers\Api\Modules\ActiveOrdersInventoryReservationsController::update
    $configuration->update($request->validated());
  File "/app/Http/Middleware/AddHeaderAccessToken.php", line 22, in App\Http\Middleware\AddHeaderAccessToken::handle
    return $next($request);
...
(70 additional frame(s) were not displayed)

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`guineys_products_management`.`inventory_reservations`, CONSTRAINT `inventory_reservations_product_sku_foreign` FOREIGN KEY (`product_sku`) REFERENCES `products` (`sku`) ON DELETE CASCADE ON U)
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 46, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::App\Modules\ActiveOrdersInventoryReservations\src\Listeners\{closure}
    'custom_uuid' => ReservationsService::getUuid($orderProduct),
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 50, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::handle
    });
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Observers/ConfigurationObserver.php", line 12, in App\Modules\ActiveOrdersInventoryReservations\src\Observers\ConfigurationObserver::updated
    ConfigurationUpdatedEvent::dispatch($configuration);
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Http/Controllers/Api/Modules/ActiveOrdersInventoryReservationsController.php", line 23, in App\Modules\ActiveOrdersInventoryReservations\src\Http\Controllers\Api\Modules\ActiveOrdersInventoryReservationsController::update
    $configuration->update($request->validated());
  File "/app/Http/Middleware/AddHeaderAccessToken.php", line 22, in App\Http\Middleware\AddHeaderAccessToken::handle
    return $next($request);
...
(70 additional frame(s) were not displayed)

Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`guineys_products_management`.`inventory_reservations`, CONSTRAINT `inventory_reservations_product_sku_foreign` FOREIGN KEY (`product_sku`) REFERENCES `products` (`sku`) ON DELETE CASCADE ON U) (SQL: insert into `inventory_reservations` (`inventory_id`, `product_sku`, `warehouse_code`, `quantity_reserved`, `comment`, `custom_uuid`, `updated_at`, `created_at`) values (7736646, 45, NES, 1, Order #1000310526, module_active_orders_inventory_reservations;order_id:347256;order_product_id:615695, 2024-03-19 13:28:15, 2024-03-19 13:28:15))
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 46, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::App\Modules\ActiveOrdersInventoryReservations\src\Listeners\{closure}
    'custom_uuid' => ReservationsService::getUuid($orderProduct),
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Listeners/ConfigurationUpdatedEventListener.php", line 50, in App\Modules\ActiveOrdersInventoryReservations\src\Listeners\ConfigurationUpdatedEventListener::handle
    });
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Observers/ConfigurationObserver.php", line 12, in App\Modules\ActiveOrdersInventoryReservations\src\Observers\ConfigurationObserver::updated
    ConfigurationUpdatedEvent::dispatch($configuration);
  File "/app/Modules/ActiveOrdersInventoryReservations/src/Http/Controllers/Api/Modules/ActiveOrdersInventoryReservationsController.php", line 23, in App\Modules\ActiveOrdersInventoryReservations\src\Http\Controllers\Api\Modules\ActiveOrdersInventoryReservationsController::update
    $configuration->update($request->validated());
  File "/app/Http/Middleware/AddHeaderAccessToken.php", line 22, in App\Http\Middleware\AddHeaderAccessToken::handle
    return $next($request);
...
(67 additional frame(s) were not displayed)