I found the following messages in the debug logs when attempting to refresh the remote datasets:
|5608|a37c3b3|2021-08-20 11:31|CONSOLE|GET|DEBUG|||SET @taskId='16'; SET @name='Fetch Remote Datasets'; SET @status='1'; SET @pid='0'; SET @configFile='/tasks/remote-dataset.task'; SET @class='\Xibo\XTR\RemoteDataSetFetchTask'; SET @options=''; SET @schedule='30 * * * *'; SET @lastRunDt='1629477074'; SET @lastRunMessage='# Fetching Remote-DataSets No results for NVMS Chromebooks No results for Lunch Menu Middle Mealviewer Remote No results for Lunch Menu High Mealviewer Remote No results for Lunch Menu Elementary Mealviewer Remote No results for ESC Remote Building Calendar Wednesday No results for ESC Remote Building Calendar Tuesday No results for ESC Remote Building Calendar Thursday No results for ESC Remote Building Calendar Monday No results for ESC Remote Building Calendar Friday Done '; SET @lastRunStatus='4'; SET @lastRunDuration='3614'; SET @lastRunExitCode='0'; SET @isActive='1'; SET @runNow='0'; UPDATE `task` SET `name` = @name, `status` = @status, `pid` = @pid, `configFile` = @configFile, `class` = @class, `options` = @options, `schedule` = @schedule, `lastRunDt` = @lastRunDt, `lastRunMessage` = @lastRunMessage, `lastRunStatus` = @lastRunStatus, `lastRunDuration` = @lastRunDuration, `lastRunExitCode` = @lastRunExitCode, `isActive` = @isActive, `runNow` = @runNow WHERE `taskId` = @taskId|
|5609|a37c3b3|2021-08-20 11:31|CONSOLE|GET|ERROR|||Task run error for taskId 16. E = SQLSTATE: String data, right truncated: 1406 Data too long for column 'lastRunMessage' at row 1|
I am continuing to get this error. I was able to briefly bypass it by removing some older remote datasets, but I have added a few new ones and the following error comes up when I attempt to fetch remote datasets:
Task run error for taskId 19. E = SQLSTATE: String data, right truncated: 1406 Data too long for column ‘lastRunMessage’ at row 1
Hi, did you find a solution? We upgraded from 2.3.12 to 3.0.4 and now encountering the same error. RemoteDataSet task runs for about an hour (every 10 min.) and then errors out and stops.
Any tip is welcome
Sorry to bump this. But manually reactivating the task multiple times per day is no fun.
Our conference center and department rosters are depending on remote datasets. In other words they are vital for our daily work (in our hospitals).
I’ll understand that there is no ready made fix, but I’m stuck at how to debug this problem. Hope someone at Xibo can give me any clues how to proceed!?
Thank you for your message and for providing the details about the error. The lastRunMessage entry referenced in the error has a character limit of 255. The character count in your lastRunMessage is beyond this limit:
# Fetching Remote-DataSets No results for NVMS Chromebooks No results for Lunch Menu Middle Mealviewer Remote No results for Lunch Menu High Mealviewer Remote No results for Lunch Menu Elementary Mealviewer Remote No results for ESC Remote Building Calendar Wednesday No results for ESC Remote Building Calendar Tuesday No results for ESC Remote Building Calendar Thursday No results for ESC Remote Building Calendar Monday No results for ESC Remote Building Calendar Friday Done
The development team are aware of the issue and will fix this. I will also update this post with a link to the issue report so you can track its progress.
Hi Dan, I manually adjusted Tasks.php with the lines from the commit. The apk-command did not work for me, probably due to our firewall. And as it is weekend now and our infrastructure department is not available, I did it this way.
But the good news is that it seems to work . I’m very, very, very happy!
I will monitor for the coming hours, but I suspect this was all what’s needed.
Did I say I’m very happy with this fix? So thank you very much for your support, really appreciate it!
Hi Callen_Magnuson, thank you for the update. I have been trying to replicate your issue on 3.0.8 and so far I have had no luck getting that error to appear.
Please can you send me screenshots showing:
The error in your 3.0.8 CMS.
The lastRunMessage for your Fetch Remote Dataset task from the last run. If you go to the Tasks page in your CMS and highlight the tick under the Last Status column for the task it will show the message being returned.
Thank you for your screenshots of the issue. Below is a link to the Task.php where you can see the fix for the issue you reported was resolved. The fix begins on line 503 and ends on line 506. Please can you go to lib/Controller/Task.php for your local install and make sure that the same appears on lines 503-506?