Ran into transient error: Hydration query failed - unknown error

Shopify Plus
1

Trigger: Scheduled to run: 7:30am and 2:30pm every day

Get order data x 13 for different order tags as warehouse team tag them at different stages of production

Output: Send internal email to various staff with status summary of orders

This had been working for a few days but didn’t see the report this morning and it has failed in the afternoon too.

It is stuck running on a retry and hangs at the first of the 13 Get order data actions.

Error message is:

Ran into transient error: Hydration query failed - unknown error

Does anyone have any ideas?

2

I think I found it. The advanced condition was set out to be more legible like this:

fulfillment_status:unfulfilled
AND NOT status:cancelled
AND tag:Product_tag
AND tag:Stage1
AND NOT tag:Stage2
AND NOT tag:Stage3
AND NOT tag:Stage4
AND NOT tag:Stage5
AND NOT tag:Stage6
AND NOT tag:Stage7
AND NOT tag:Stage8
AND NOT tag:Stage9

but actually it all needs to be bunched together like this:

fulfillment_status:unfulfilled AND NOT status:cancelled AND tag:Product_tag AND tag:Stage1 AND NOT tag:Stage2 AND NOT tag:Stage3 AND NOT tag:Stage4 AND NOT tag:Stage5 AND NOT tag:Stage6 AND NOT tag:Stage7 AND NOT tag:Stage8 AND NOT tag:Stage9

3

Just FYI, it seems we’re having an issue. At least temporarily, the fix is to merge multi-line queries into a single line until we can resolve the issue.

Update: This should be resolved as of Friday (August 8). Please let us know if you’ve continued to experience this issue.

1 Like