Discussions
Error on create shipment
almost 6 years ago by Cristiano
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": "[email protected]",
"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\\\"\"}"