'Could not find a record in sys_report for column report_id referenced in this update' Error

[Fromsee Genene]

When I tried to move the local update set to the remote update set I got 'Could not find a record in sys_report for column report_id referenced in this update' error on the dashboard, how can I solve this?

[Maddysunil · Accepted solution]

@Fromsee Genene 

It means you are trying to update is referring to a value in the color_palette field, but ServiceNow cannot find a corresponding record in the referenced table (pa_chart_color_schemes).

Here are steps you can take to troubleshoot and resolve the issue:

1. Check Reference Field:

   • Navigate to the record where the error is occurring, and find the color_palette field.
   • Verify that the value in the color_palette field corresponds to a valid record in the pa_chart_color_schemes table.

2. Verify Record Existence:

   • Manually check the pa_chart_color_schemes table to ensure that a record with the referenced value in the color_palette field exists.

3. Data Consistency:

   • Ensure that the data in the pa_chart_color_schemes table is consistent and there are no missing or corrupted records.

If my response help you, please mark correct/Helpful.

Thanks

[Fromsee Genene]

@Maddysunil 

I want to delete records from the sys_report_users_groups table but the delete functionality is off, could you help me remove records from this table or, The 'Report ID' in the sys_report_user_group table is blank. Could you possibly help me address this issue?

[Maddysunil]

@Fromsee Genene 

It is not recommended to delete record without necessary approvals and permission, however to delete record from that table below is sample background script you can use it:

var repGr=new GlideRecord('sys_report_users_groups');
repGr.addQuery('sys_id','003e4d3cc7123010d7e818b1c7c260f9');
repGr.query();
if(repGr.next())
{
    repGr.deleteRecord();
    repGr.autoSysFields(true);
    repGr.update();
}

Kindly mark helpful/accepted if it helps you.

Thanks

[Fromsee Genene]

@Maddysunil 
I attempted to resolve the issue causing the report ID to be empty, but I was unable to identify the root cause before erasing the information. Could you please assist me with this?

[Maddysunil · Accepted solution]

@Fromsee Genene 

Group ID and Report ID is showing empty then please verify that the specified group_id and report_id values correspond to existing groups and reports in the system. If the referenced groups or reports have been deleted or are inactive, it can result in empty fields.

You may need to manually update it with background script with correct sysids.

Kindly mark helpful/accepted if it helps you.

[Fromsee Genene]

@MaddysunilThank you. I'll remove it manually in the script background and get back to you if there are any issues.