Anyone know why I am getting random intermittent errors in DataMesh jobs?
Error message: A JSON text must at least contain two octets!
I don't do anything and the problem is gone on the next run. This is happening with multiple unrelated DataMesh configurations.
I get an email alert "Scheduler Error for Config 'ConfigName' with the message:
Hi,
There was an issue with one of your DataMesh configurations.
Please use the URL below to view the issues with the configuration:
https://datamesh.smartsheet.com/#config/######/logs
Your data will not be updated until the config is updated.
Thanks,
Smartsheet DataMesh Team
When I go to the config logs, I see the error was a few minutes in the past and the next runs were successful without me changing anything.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
Same thing happens to me.
-
@Ami Veltrie Sorry to hear that, but glad it's not just something I'm doing wrong! 😁 Misery loves company. Must be something going on behind the scenes. It just started up for me maybe a month or two ago. I will open a ticket with support.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman Thank you Jeff! Haha, indeed, not just you. If you get a resolution, let me know. 😊
-
@Jeff Reisman / @Ami Veltrie I'm getting "Error code Unknown (Ref: ): A JSON text must at least contain two octets!" when running a pivot configuration. I was able to create the pivot sheet and I then set up the config to run hourly. It ran with no errors on the first hourly run but it returns the error message on every subsequent hourly run. I've started a case with support so hopefully there is a resolution soon but if either if you have found a solution, I'd be grateful to hear it.
-
@Randy Saad Hi Randy. I don't have any pivot tables so I'm not sure if this string also pertains to pivots.
-
@Jeff Reisman Hi Jeff. Did you ever get a response from Smartsheet Support on this?
-
Thanks @Ami Veltrie. Support has taken a look at the situation and thinks the pivot updates were successful but they are still investigating why the "must at least contain two octets!" still shows. But the pivot update is not completely successful so there does seem to be a true underlying issue.
-
The answer I got was basically "this can happen sometimes if the source sheet is very complex or busy."
I no longer work at my previous job, so I don't know if it's still happening (or even how much of the systems I built are still operational.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman Thank you for the response Jeff! I have several scenarios where Smartsheet tells me "the sheet too complex". 🤔 Congrats on your new job!
-
Congrats on your new job!
Boy how I wish that was the case! I got RIF'ed along with 47 others in February. Still looking for something new! I'm convinced that many of these job listings aren't real...
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman Oh no, I'm so sorry! Have you looked here: https://community.smartsheet.com/categories/community-job-board
