英文:
Apps Script failed with error: Empty response
问题
我将所有的数据从BigQuery迁移到了一个特定的区域（europe-west2）几周前。从那以后，我一直在我以前从未遇到过的所有Apps Script中不断收到"Empty Response"错误，例如：
对bigquery.jobs.query的API调用失败，错误为：Empty response
除了区域更改，没有任何其他变化。错误也是间歇性的，以至于我创建了一个解决方法，它会立即尝试相同的"Bigquery.jobs.insert"操作，获得有效的响应。
有没有人知道为什么会发生这种情况？有没有人遇到相同的问题？
提前感谢
Dave
问题是间歇性的，所以运行完全相同的脚本和请求会"修复"问题。这真的很难调试，因为它是间歇性的。
英文:
I moved all of my data in BigQuery to a specific region (europe-west2) a few weeks ago. Since then I keep getting "Empty Response" errors in all of my Apps Script that I've never had before, for example:
API call to bigquery.jobs.query failed with error: Empty response
Nothing else has changed except for the region change. The error is intermittent as well, to the point that I have created a workaround that literally tries the same "Bigquery.jobs.insert" immediately again, with a valid response.
Does anyone have an idea of why this is happening? Has anyone been having the same issue?
Thanks in advance
Dave
The problem is intermittent so literally running the exact same script and request will "fix" the problem. It is really hard to debug because it is intermittent.
答案1
得分: 1
我已经找到一些帖子，指出这个错误是因为Google App脚本不支持上传大于50MB的文件。在这个答案中，用户将文件分割成小于50MB的部分。
另外，您可以参考这个问题跟踪器中关于同一问题的讨论：https://issuetracker.google.com/issues/247052933
英文:
I have found some posts that this error points out that Google App script does not support uploading larger than 50 mb files. In this answer a user splits the files into lower than 50 mb.
Also check this issue tracker for conversation about the same issue for your reference: https://issuetracker.google.com/issues/247052933
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论