Getting INTERNAL_SERVER_ERROR error when exporting priceLists data

Retired Boards Appdev Graphql Basics And Troubleshooting
1

I always get “INTERNAL_SERVER_ERROR” error when trying to export product fixed prices. When bulk query export contains about 2 - 3 million lines, it will return INTERNAL_SERVER_ERROR error. Here is the bulk operation query that I use

mutation {
  bulkOperationRunQuery(
    query: """
    {
      priceLists {
        edges {
          node {
            id
            currency
            contextRule{countries}
            parent {
              adjustment {
                type
                value
              }
            }
            prices(originType:FIXED) {
              edges {
                node {
                  variant {
                    id
                    product{
                      id
                    }
                  }
                  price {
                    amount
                    currencyCode
                  }
                  compareAtPrice {
                    amount
                  }
                }
              }
            }
          }
        }
      }
    }
    """
  ) {
    bulkOperation {id status}
    userErrors {field message}
  }
}

This problem is only occurring with this specific store: sachinandbabi.myshopify.com, while the bulk query export works properly with the other merchant stores.

2

Hi @nkhoai -thanks for getting in touch. I tried to do some digging into this, but wasn’t able to determine why the query would result in an Internal Server error. That said, the amount of lines you mentioned the output JSONL payload contains is fairly significant and I could see how a potential time out could result in an error like this happening (usually we would serve a time out error rather than an internal server error if this were the case, though)

If you’re still encountering the issue, could you please reach out to our Patner Support team through your Partner Dashboard’s “Support Tab” or through https://help.shopify.com? When you reach out, if you could also include the response body, response headers (x-request-id, most importantly) and timestamps for an example of an API call where you’re seeing the internal server error returned? I’d also reference this forum post so our Support teams can properly share my reply here with either our Partner Support team or one of the more technical teams like mine.

On the forums we can generally provide some basic solutions, but the investigation might be a bit more complicated here and require some looking into more private information on the shop.

Hope this helps - let us know if we can clarify anything further and hope to hear from you soon.