数据传送错误"指定的密钥不存在"

在数据穿梭,我有一个工作流程,正在产生以下错误:

无法向目标工作表添加行:UNKNOWN:指定的键不存在。(Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87)

这个工作流已经运行了好几个月了(每天运行两次),没有出现任何错误,这只是刚刚开始列出这个错误。

从存储在OneDrive帐户上的excel文档上传时,工作流导入了大约12500行。该工作流处理12,500行中的10,879行。

我检查了源excel文档,以查看它成功导入的最后一行和随后的行,一切看起来都很好。事实上,这些行较老,创建于2月份,数据穿梭在过去几个月导入它们时没有遇到任何问题。不知道为什么会突然。

有人知道这个错误说明了什么吗?

最佳答案

答案

Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106193,"type":"question","name":"Multiple Forms, One Smartsheet","excerpt":"I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?","categoryID":321,"dateInserted":"2023-06-08T13:28:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T13:47:26+00:00","insertUserID":152102,"insertUser":{"userID":152102,"name":"AllieB","url":"https:\/\/community.smartsheet.com\/profile\/AllieB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T13:49:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T21:09:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":45,"score":null,"hot":3372467730,"url":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106193\/multiple-forms-one-smartsheet","format":"Rich","lastPost":{"discussionID":106193,"commentID":379551,"name":"Re: Multiple Forms, One Smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379551#Comment_379551","dateInserted":"2023-06-08T13:47:26+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-06-08T21:09:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T13:46:06+00:00","dateAnswered":"2023-06-08T13:44:25+00:00","acceptedAnswers":[{"commentID":379548,"body":"

@AllieB<\/a> <\/p>

Yes - in your sheet, add a Created date column.<\/p>

-Peggy<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106191,"type":"question","name":"Can't find how to enable % Complete column","excerpt":"I am new to the app working in a Trial window. I have searched the Help but cannot seem to resolve how to enable the % Complete column. Dependencies are enabled. System Settings only gives me options for \"None\" or \"Notes\" for a % Complete column. Only thing I seem to get is the ability to add custom columns. Any direction…","categoryID":321,"dateInserted":"2023-06-08T13:26:39+00:00","dateUpdated":"2023-06-08T13:35:37+00:00","dateLastComment":"2023-06-08T13:40:28+00:00","insertUserID":162189,"insertUser":{"userID":162189,"name":"BillB","url":"https:\/\/community.smartsheet.com\/profile\/BillB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T15:50:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162189,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-08T21:03:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3372463627,"url":"https:\/\/community.smartsheet.com\/discussion\/106191\/cant-find-how-to-enable-complete-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106191\/cant-find-how-to-enable-complete-column","format":"Rich","lastPost":{"discussionID":106191,"commentID":379545,"name":"Re: Can't find how to enable % Complete column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379545#Comment_379545","dateInserted":"2023-06-08T13:40:28+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-08T21:03:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T13:42:55+00:00","dateAnswered":"2023-06-08T13:40:06+00:00","acceptedAnswers":[{"commentID":379543,"body":"

After hours of searching, I seemed to have figured this out as soon as I posted the question. Issue resolved.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势