Error moving dashboard in update set "Could not find a record in sys_grid_canvas for column canvas_page referenced in this update"

[Leilani Wolf]

I'm trying to move a dashboard with custom widgets from a demo instance to my PDI (both on Madrid). I followed the steps described in Move a dashboard with an update set  including unloading the dashbaord to the update set. When I loaded the update set into my PDI, I got a ton of errors, a lot of which were like the error described in Solving errors on dashboards moved with update set. I wasn't able to follow the steps in that doc because when I went to sys_grid_canvas, there wasn't a sys_id field and searching for the specific errors didn't find anything. I hit Accept all remote update and committed the update set, but the dashboard did not appear once I did.

My question is 1) How do I resolve the sys_grid_canvas error and 2) How do I successfully transfer over the dashboard? TIA!

[Mike322]

Hi Leilani,

You might've already found a solution after a years time but since your link isn't working anymore, here's one that does still work: Clicky!

In your case the missing sys_id might be caused by an invalid reference. I think the only way of resolving that is by rebuilding the page again in the other instance. That said, if you did, how did you resolve it ultimately?

To anyone else: In case you're from sometime in the future where the page I linked to has also been deleted or moved: Hello weary traveler! You probably found out that the link above doesn't work as expected anymore so here is the text it contained - you know, for posterity!

Could not find a record in sys_grid_canvas for column canvas_page referenced in this update

When you move a dashboard with an update set, the following error may occur: 'Could not find a record in sys_grid_canvas for column canvas_page referenced in this update'. To solve this error, move the canvas page from the source instance to the target instance.

Before you begin

Role required: admin

Procedure

1. In the Update Set Preview Problems related list, click the information icon () next to the error.
2. In the pa_tabs record payload, copy the sys_id associated with the canvas_page field.
3. In the source instance, navigate to sys_grid_canvas.list.
4. Filter the list on the sys_id copied in step 2.
5. Right-click on the returned record and select Unload Canvas Page to add this record to the current update set.
6. Transfer the update set to the target instance using standard update set functionality. For more information, see Retrieve an update set.
7. Repeat this task for all update set preview problems that have this error.

Result

The missing dashboard tab content is moved to the target instance.

[Community Alums]

Mike, you have no idea how thoughtful it was for you to include the document contents in your post. There have been many answers I've seen that have dead links (e.g. all wiki.service-now.com url's), which is always a bummer. So, this is very much appreciated 🙂

[Mike322]

No problem at all Ethan!

I think that everyone knows that feeling: Finally you've found that Google link that really seems to be answering that question that you've had for days or months. Thinking you can now remove that roadblock that has plagued your project all this time, only to find out that the link is dead or otherwise unusable.

Because this is quite a relatable scenario to any dev for a lot of software solutions, I thought to break out of this seemingly endless cycle of hope and disappointment and just upload the entire page. Hopefully, more people will follow this example so we've got a decentralized way of retrieving information in case the central repository is dead and buried. 😉