Ask A Question

Questions

2
ANSWERED

Error on create shipment

Hi, I am doing the following request body: ``` { "allow_courier_fallback": "false", "destination_address_line_1": "test", "destination_address_line_2": "", "destination_city": "Sydney", "destination_company_name": "", "destination_country_alpha2": "AU", "destination_email_address": "test@asa.com", "destination_name": "test", "destination_phone_number": "test", "destination_postal_code": "2020", "destination_state": "NSW", "easyship_shipment_id": "", "is_insured": "false", "items": [ %{ "actual_weight": "23.0", "category": "toys", "declared_currency": "AUD", "declared_customs_value": "45.0", "description": "test", "height": "20.0", "length": "10.0", "sku": "DM5NNR", "width": "12.0" } ], "order_notes": "", "platform_name": "Sheldon", "platform_order_number": "", "selected_courier_id": "f9c03bd5-dec7-4b5b-a3ac-7fa7b9d01674", "taxes_duties_paid_by": "Sender", "total_actual_weight": "" } ``` but I am getting this error as response: ``` "{\"ActiveRecord::StatementInvalid\":\"PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block\\n: /*application:ESAPI,controller:shipments,action:create*/ INSERT INTO \\\"shipments\\\" (\\\"type\\\", \\\"company_id\\\", \\\"shipment_state\\\", \\\"pickup_state\\\", \\\"transaction_state\\\", \\\"label_state\\\", \\\"manifest_state\\\", \\\"delivery_state\\\", \\\"store_state\\\", \\\"warehouse_state\\\", \\\"reconciliation_state\\\", \\\"destination_name\\\", \\\"destination_company_name\\\", \\\"platform_name\\\", \\\"order_notes\\\", \\\"destination_country_id\\\", \\\"incoterms\\\", \\\"buyer_selected_courier_id\\\", \\\"address_line_1\\\", \\\"state\\\", \\\"city\\\", \\\"postal_code\\\", \\\"phone_number\\\", \\\"email_address\\\", \\\"store_id\\\", \\\"origin_country_id\\\", \\\"currency\\\", \\\"service\\\", \\\"sort_by\\\", \\\"tracking_engine\\\", \\\"package_count\\\", \\\"easyship_shipment_id\\\", \\\"origin_address_id\\\", \\\"created_at\\\", \\\"updated_at\\\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35) RETURNING \\\"id\\\"\"}" ```

Posted by Cristiano 3 months ago