将行添加到SharePoint Excel工作簿表MaxRequestDurationExceeded时出错 [英] Error when adding rows to a sharepoint excel workbook table MaxRequestDurationExceeded
问题描述
这是完整的错误
{错误":{代码":"MaxRequestDurationExceeded"，消息":很抱歉.我们完成了您要求我们做的事情，因为它花了太长时间."，"innerError":{"code":"gatewayTimeoutUncategorized"，" message":服务无法在时限内完成请求."，"innerError":{代码":"MaxRequestDurationExceeded"，消息":很抱歉.我们无法完成您要求我们做的事情，因为这花费了太长时间."}，日期":"2020-11-24T02:48:23"，"request-id":"a3f533ea-3d8e-4bb6-aa71-4eaf10b79364"，客户端请求ID":"a3f533ea-3d8e-4bb6-aa71-4eaf10b79364"}}} 当我尝试将记录添加到excel文件时，我收到此错误消息，但不清楚.起初，我每个帖子发送5k到8k的excel记录，所以我认为是因为我发送的太多.我所做的是每个帖子仅发送3k条记录，但仍然出现此错误.
我认为excel共享点文件需要一些时间来刷新新发布的数据，因此我在发布命令后添加了3分钟的时间延迟，但出现错误
我还在邮递员中尝试过，我只发送1条测试记录，但仍然出现相同的错误，不确定为什么.
进一步检查后，共享点中的工作簿大小似乎受到限制.限制为50mb，而我们的excel文件已经为40mb.它已经很近了，但是我仍然有10 mb的空间可以使用，所以应该不会有任何问题.
当前excel共享点文件具有100万以上的记录
** 是的，我们可能不得不重新考虑将sharepoint excel文件视为数据库，但就目前而言，我想看看是什么原因引起了上述错误，因为它并没有提供太多详细信息.
编辑:其他详细信息，在我之前检查过一些实例的情况下，实际上已将测试记录添加到excel文件中，但响应仍然是上述错误消息
我也没有发布代码，因为它上周开始工作，所以我认为该错误与我的代码无关，而是由于其他一些我不知道的变量
似乎sharepoint现在允许在excel文件中添加更多内容，因为它已经有很多记录了.根据这些限制:
但是，端点没有返回更多信息的错误消息还是有点奇怪.
here is the full error
{
"error": {
"code": "MaxRequestDurationExceeded",
"message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long.",
"innerError": {
"code": "gatewayTimeoutUncategorized",
"message": "The service wasn't able to complete the request within the time limit.",
"innerError": {
"code": "MaxRequestDurationExceeded",
"message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long."
},
"date": "2020-11-24T02:48:23",
"request-id": "a3f533ea-3d8e-4bb6-aa71-4eaf10b79364",
"client-request-id": "a3f533ea-3d8e-4bb6-aa71-4eaf10b79364"
}
}
}
when I'm trying to add records to an excel file, I get this error message which is a bit unclear. At first I was sending 5k to 8k excel records per post so I thought because I was sending too much. what I did was send only 3k records for every post but still I get this error.
I assumed that the excel sharepoint file need some time to refresh the newly posted data so I added a time delay for 3 minutes after a post command but I get the error
I also tried in postman where I only send 1 test record and I still get the same error, not sure why.
Upon further checking, there appears to be a limit of a workbook size that is in sharepoint. 50mb is the limit, and our excel file is already at 40mb. It is already close, but still I got 10 more mb to use so there shouldn't be any issues.
Currently the excel sharepoint file has 1 million plus records
**yeah we might have to rethink treating the sharepoint excel file as a database but for now I'd like to see what causes the error mentioned since it doesn't really give much details.
edit: additional details, earlier when I was checking there are a few instances that the test records are actually added in the excel file but the response is still the mentioned error message
also I didn't posted the code since it was working last week so I think the error is not related to my code but due to some other variables that I'm not aware of
it seems sharepoint is now allowing anymore addition to the excel file since it already has tons of records. as per these limits:
but still it is a bit weird that the endpoint does not return a more informative error message.
这篇关于将行添加到SharePoint Excel工作簿表MaxRequestDurationExceeded时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
