BulkOperation - Internal Server Error

Highlighted
New Member
6 0 0

Hi,

 

I recently switched my api requests from Rest to Graph, which works pretty fine.

But for one store I'm receiving an Internal Server Error shortly after executing the BulkOperation to query all products.

 

Here is the response:

{ 
   'data':{ 
      'node':{ 
         'id':'gid://shopify/BulkOperation/3203858567',
         'status':'FAILED',
         'errorCode':'INTERNAL_SERVER_ERROR',
         'createdAt':'2020-02-04T09:50:01Z',
         'completedAt':None,
         'objectCount':'0',
         'fileSize':None,
         'url':None,
         'partialDataUrl':None
      }
   },
   'extensions':{ 
      'cost':{ 
         'requestedQueryCost':1,
         'actualQueryCost':1,
         'throttleStatus':{ 
            'maximumAvailable':1000.0,
            'currentlyAvailable':999,
            'restoreRate':50.0
         }
      }
   }
}

Here some more ids that had the same issue:

gid://shopify/BulkOperation/3203825799

gid://shopify/BulkOperation/3201499271

gid://shopify/BulkOperation/3200712839

 

I'm only having this issue with one store. All others work fine. So I guess my query is all right.

 

 

0 Likes
Highlighted
New Member
6 0 0

UPDATE:

I now have another store which I'm completely unable to fetch its products via bulk.

 

I'm getting the same response as above.

Example query Ids:

gid://shopify/BulkOperation/3375693955

gid://shopify/BulkOperation/3372712067

gid://shopify/BulkOperation/3235381383

gid://shopify/BulkOperation/3372351619

gid://shopify/BulkOperation/3371958403

 

PLEASE HELP!

0 Likes
Highlighted
Shopify Staff
Shopify Staff
262 42 46

Hey @HeartCoding ,

 

This issue you are facing might be related to an on-going problem Shopify is currently working to solve in which queries for `products` in our core database for a Shopify store that has a large amount of products (e.g. > 1000 products) are failing. 

 

As I mentioned there is on-going work on our end to resolve this, but in the meantime as a workaround you can resolve this on your end by including a filter in your GraphQL query for the "created_at" date of the product. So for example your query could look like:

 

mutation {
  bulkOperationRunQuery(
    query:"""
    {
      products(query: "created_at:>=2020-02-01") {
        edges {
          node {
            id
...
}
}
}
}
}

 

Hassain | Developer Support Specialist @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Click Accept as Solution 

0 Likes