Update set errors when adding a KB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2018 07:20 AM
I needed to create a new KB with unique permissions. I went into DEV. And after creating an update set, used the insert/stay function to copy an existing KB that was working in DEV and PROD. I set my new permissions and updated the KB. I set the update set as complete and went to PROD to import this update. When I do I get two errors related to who can read and who can contribute.
Could not find a record in kb_knowledge_base for column kb_knowledge_base referenced in this updat
Suggestions?
Thanks…
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2018 01:38 AM
This is because Knowledge Base is not captured in update sets. You need to export and import it via XML (to make sure sys_ids are the same) from DEV to TEST/PROD as part of the release and run preview again.
You can identify which table is captured in update sets by checking Dictionary entry of type "collection" for the table and see if there is attribute "update_synch=true" specified.
Regarding knowledge management tables, most of them are not captured in update set (as knowledge bases and articles). If you use following URL, you can find all kb tables that are captured in update set: https://YOUR_INSTANCE_NAME.service-now.com/sys_dictionary_list.do?sysparm_query=nameSTARTSWITHkb%5Einternal_type%3Dcollection%5EattributesLIKEupdate_synch%3Dtrue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2018 06:20 AM
Thank you, that clears things up for me.