数据航天飞机——工作流s Failing

Dean Johnson ✭

07/06/23 edited 07/07/23 inAdd Ons and Integrations

I have multiple offload and upload workflows that have functioning quite well in Smartsheet, however after a week or two they seem to randomly not be able to find the Attachment File for the upload workflow and then give me that wonderful red error message. Anyone have a solution for this issue or at least an explanation? Thank you.

Tags:

Data Shuttle

0 ·

Answers

Amit Wadhwani ✭✭✭✭✭✭

07/10/23

Hi@Dean Johnson

What is the input in the source sheet? Is there a possibility that the row was created, sheet saved and data shuttle ran, just before the attachment was uploaded to the row? Not sure if this is the cause, just trying to connect the dots here.

Best Regards

Amit Wadhwani, Smartsheet Community Champion

Smartsheet CoE,Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Did this answer help you? Show some love by marking this answer as "Insightful" or "Awesome❤️" and "Vote Up⬆️"

0 · Share on Facebook Share on Twitter

Categories

SOLVED!!!<\/p>

I wanted to use my target sheet with Resource Management so I turned DEPENDENCIES on in the PROJECT SETTINGS. <\/p>

My DataMesh was trying to update the START and END dates (which now were driven automatically in the target sheet) from the source sheet so Smartsheet could not update cells which were automatically updated.<\/p>

Once I turned DEPENDENCIES off in the target sheet my DataMesh worked just fine.<\/p>

:)<\/p>

Jack<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":[{"tagID":381,"urlcode":"datamesh","name":"DataMesh"}]},{"discussionID":102109,"type":"question","name":"Issue with DyanmicView","excerpt":"Hello, Using DynamicView, I couldn't show the column description. The columns name is limited in characters and I need to explain the meanings of each column. Also, I tried to do a helper row but the cell is limited to 20 contacts so I can't show the helper row to all viewers. Any alternative idea? Thanks,","snippet":"Hello, Using DynamicView, I couldn't show the column description. The columns name is limited in characters and I need to explain the meanings of each column. Also, I tried to do…","categoryID":343,"dateInserted":"2023-03-03T19:09:00+00:00","dateUpdated":null,"dateLastComment":"2023-10-26T17:29:57+00:00","insertUserID":152547,"insertUser":{"userID":152547,"name":"maltaee","title":"","url":"https:\/\/community.smartsheet.com\/profile\/maltaee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jKEmI3fEzHs!GlknHye32Ts!sXOmDxmK2Wo","dateLastActive":"2023-10-26T19:32:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":168774,"lastUser":{"userID":168774,"name":"ckeefe440","title":"Core Integration Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/ckeefe440","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxb0ajAmDX9MxssflJhuXofsohFC2-L61e695LHu=s96-c","dateLastActive":"2023-10-26T17:22:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":74,"score":null,"hot":3376214337,"url":"https:\/\/community.smartsheet.com\/discussion\/102109\/issue-with-dyanmicview","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102109\/issue-with-dyanmicview","format":"Rich","tagIDs":[443],"lastPost":{"discussionID":102109,"commentID":401880,"name":"Re: Issue with DyanmicView","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401880#Comment_401880","dateInserted":"2023-10-26T17:29:57+00:00","insertUserID":168774,"insertUser":{"userID":168774,"name":"ckeefe440","title":"Core Integration Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/ckeefe440","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxb0ajAmDX9MxssflJhuXofsohFC2-L61e695LHu=s96-c","dateLastActive":"2023-10-26T17:22:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-05T12:29:48+00:00","dateAnswered":"2023-03-04T13:39:47+00:00","acceptedAnswers":[{"commentID":365583,"body":"

Hi @maltaee<\/a> <\/p>

I hope you're well and safe!<\/p>

You can change the Field name with a Custom label in the Dynamic View settings.<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

A good example would be something like a dropdown column being restricted to only allow values within the column properties.<\/p>

\n \n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":713,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Help shape the future of Smartsheet.
Share your ideas and feature requests.
Watch video