Very Small Sheet causes "Error! Failed to issue the request,

I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors:

Error! Failed to issue the request, please relogin and try again.

Error code: 0 - Error message:error

This only happens one direction. I can datamesh from Sheet A to Sheet B but can no longer go from Sheet B to Sheet A. I have deleted all rows and columns so I'm down to 13 rows and 75 columns. This was working when there were 900 rows!

Thanks,

Jack

Tags:

Best Answer

  • Jack Swaton
    Jack Swaton ✭✭
    Answer ✓

    SOLVED!!!

    I wanted to use my target sheet with Resource Management so I turned DEPENDENCIES on in the PROJECT SETTINGS.

    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.

    Once I turned DEPENDENCIES off in the target sheet my DataMesh worked just fine.

    :)

    Jack

    image.png


Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Jack Swaton

    I hope you're well and safe!

    Strange!

    If you haven’t already, I recommend submitting a support ticket through the newSmartsheet Support Portal.

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Thank you. I have indeed created a support ticket. Also, turns out it is the TARGET sheet which is failing. And the target sheet is very clean with no external links except to one link TO the source sheet. Fewer than 100 rows and fewer than 25 columns.

    Jack

  • Jack Swaton
    Jack Swaton ✭✭
    Answer ✓

    SOLVED!!!

    I wanted to use my target sheet with Resource Management so I turned DEPENDENCIES on in the PROJECT SETTINGS.

    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.

    Once I turned DEPENDENCIES off in the target sheet my DataMesh worked just fine.

    :)

    Jack

    image.png


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Jack Swaton

    Excellent!

    Happy to help!

    Glad to hear you solved it.

    Remember!了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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 \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":73,"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 \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>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":110328,"type":"question","name":"Data shuttle issue","excerpt":"Hi All I'm trying to use the automation in the data shuttle - all seems to be mapped correctly but I keep getting the notification the columns in the target sheet are restricted. Do you have any idea what does that mean please? I have unlocked any locked columns but it still doesn't seem to be working. Any help would be…","snippet":"Hi All I'm trying to use the automation in the data shuttle - all seems to be mapped correctly but I keep getting the notification the columns in the target sheet are restricted.…","categoryID":343,"dateInserted":"2023-09-15T13:27:16+00:00","dateUpdated":null,"dateLastComment":"2023-10-25T14:33:20+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2023-10-25T15:44:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":158375,"lastUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2023-10-25T15:44:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":161,"score":null,"hot":3393030636,"url":"https:\/\/community.smartsheet.com\/discussion\/110328\/data-shuttle-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110328\/data-shuttle-issue","format":"Rich","lastPost":{"discussionID":110328,"commentID":401611,"name":"Re: Data shuttle issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401611#Comment_401611","dateInserted":"2023-10-25T14:33:20+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2023-10-25T15:44:55+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/0HCEQKZESQCD\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-19T09:52:35+00:00","dateAnswered":"2023-09-15T13:28:50+00:00","acceptedAnswers":[{"commentID":395534,"body":"

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":[]}">

Trending Posts