Could not find a record in sys_portal for column portal_widget referenced in this update
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2020 11:43 AM
I added some reports to my dashboard, "Unload the dashboard" in the Update set and moved it to test.
I get 30 errors - "Could not find a record in sys_portal for column portal_widget referenced in this update" for the reports which are added I believe. I already ignored the errors and committed the update set.
Now my dashboard layout is all messed up.
when I created another update set to capture missing updates of sys_portal, I see they are not capturing in the update set.
Do I need to import and export the xml?
how can i resolve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2020 12:04 PM
Hi,
This page below explains how to add a home page, which is a sys_portal_page, to an update set.
- https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/administer/homepage-administ...
- It explains that you need to unload the home page to get it into the update set. The command for unloading a portal page is where current is the GlideRecord for the home page.
GlideappHome.unloader(current);This command pushes all the home page and its drop zones and stuff like that to the update set.
If it helps,Please mark ✅ Correct and 👍 Helpful.
Warm Regards,
Milind
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2020 12:14 PM
thanks Milind for reply
I have created another update set to capture the fixes.
And I have unload the portal page as in above document.
But this has only captured the portal page - "sys_portal_page" not missing "sys_portal" records.
This gives only one record in my update set.
I am not clear Where do I need to write this command ?
GlideappHome.unloader(current);Or only Unloading the page is going to solve the issue?
or Do I need to import and export the xml the missing sys_portal records?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2021 07:07 AM
When you click on unload portal page and move that update , then all sys_portal_page and sys_portal, both errors get resolved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2025 04:14 AM
Hi,
This error is due to the records in sys_portal and sys_portal_page for the dashboard is not found in the target instance.
The solution I found while facing this was to export the xml of these records(your dashboard specific records from sys_portal and sys_portal_page) and import them to the target instance first. After importing the xml, if you migrate the update set, you should no longer face this error and the dashboard layout or reports should not be messed up or empty.
Thankyou.
