Instance Data Replication — Unable to Select Tables During Producer Replication Set CreationIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } When creating Producer Replication Sets in Instance Data Replication (IDR), certain tables do not appear in the selection list even though they are not part of the officially excluded tables list. Excluded Tables - IDR Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All supported releases Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } The is_df_table field in the sys_db_object table was storing a null value for the affected tables. However, the UI was rendering this null as false, masking the actual database state. Since IDR's replication eligibility check relies on this field being explicitly set to false (not null), the affected tables were incorrectly excluded from the replication table picker. Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Use the two background scripts below — first to diagnose which tables are affected, then to remediate by explicitly setting is_df_table to false. ⚠️ Update the sys_scope GUID in both scripts to match the target application scope before running. Step 1 – Diagnostic Script Identifies tables where is_df_table is null and checks replication eligibility. var result = String(sn_idr.IDRReplEntryHelper.getAllowedTables()); var gr = new GlideRecord('sys_db_object'); gr.addQuery('sys_scope', 'c35f87776fd241958d8337ea88bb2203'); // Interview management scope gr.query(); while (gr.next()){ var tableName = gr.getValue("name"); // check the is_df_table. If it is null, there's an issue. 0 is good. gs.print(tableName + '.is_df_table = ' + gr.getValue('is_df_table')); gs.print('Allow to replicate ' + tableName + ': ' + (result.indexOf(tableName) >= 0)); } What to look for: Any table where is_df_table returns null (instead of 0) is affected and will not appear in the IDR table picker. Step 2 – Remediation Script Explicitly sets is_df_table to false for all tables in the scope. var gr = new GlideRecord('sys_db_object'); gr.addQuery('sys_scope', 'c35f87776fd241958d8337ea88bb2203'); gr.query();var count = 0; while (gr.next()) { gr.setWorkflow(false); gr.setValue('is_df_table', false); gr.update(); gs.print('Fixed: ' + gr.getValue('name')); count++; } gs.print('Total tables fixed: ' + count); After running the remediation script, re-open the Producer Replication Set configuration and verify that the previously missing tables are now available for selection. ⚠️ Important: Before executing these scripts in your production instance, it is strongly recommended to test them in a sub-production environment first. Validate that the expected tables appear correctly in the IDR Producer Replication Set configuration after running both scripts, and confirm there are no unintended changes to other tables in the target scope.