Inventory Sync Mutation 504 error code

GraphQL API
1

We were trying to send a file with near 200K SKUs (13MB), but the API returned 504 error:

<html><head><title>504 Gateway Time-out</title></head><body bgcolor="white"><center><h1>504 Gateway Time-out</h1>< (truncated...)

The request that we sent:

mutation{

inventory_sync(data:{
url:“https://dev-twctools.s3-us-west-2.amazonaws.com/shiphero/inventory_sync/primary/primary_1570709571.csv”,
warehouse_id:“V2FyZWhvdXNlOjEwMjQw”
}){
request_id
complexity
sync_id
}
}

As I can see, the batch was actually created, but having an error in response is a problem since we can not get the sync process ID for further monitoring.

3

We’ve got another problem for the big file upload. The file that was delivered within the same mutation has near 1.3M rows and 88Mb. However besides the regular 504 error that we got, the sync process is stuck in processing state and haven’t changed since Friday. Please fix this ASAP as we can not deliver other batches.

{
        "node": {
          "id": "5da049e3b212a900010b7bb9",
          "url": "https://dev-twctools.s3.us-west-2.amazonaws.com/shiphero/inventory_sync/primary/primary_1570785642.csv",
          "warehouse_id": "V2FyZWhvdXNlOjEwMjQw",
          "customer_account_id": null,
          "total_count": 1391255,
          "status": "processing",
          "error": null,
          "created_at": "2019-10-11T09:22:43+00:00",
          "updated_at": "2019-10-11T10:44:57+00:00"
        }

Thanks.

4

Hi ihnatk!
Could you please try uploading that file again, issue should be fixed now.
Thanks!,
Tom

5

Hi @tomasw,
Thanks for your reply. I can not send create a new sync while the old one is not failed or completed. Please see the mutation response:

There is a sync already scheduled/being processed for warehouse 10240: {u'status': 2, u'user_id': 21397L, u'account_id': 5518L, u'url': u'https://dev-twctools.s3.us-west-2.amazonaws.com/shiphero/inventory_sync/primary/primary_1570785642.csv', u'total_count': 1391255, u'created_at': datetime.datetime(2019, 10, 11, 9, 22, 43, tzinfo=<UTC>), u'updated_at': datetime.datetime(2019, 10, 11, 10, 44, 57, tzinfo=<UTC>), u'warehouse_id': 10240L, u'error': None, '_id': '5da049e3b212a900010b7bb9'}

I believe you’ll need to set error status for the previous one manually in order to let us deliver a new batch.