'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

[Maddysunil]

@Fromsee Genene 

• Go to the 'sys_report' table in ServiceNow and look for the record that is referenced in the error message.
• Verify that the 'report_id' field is populated correctly for this record.
• If the record is missing, try to find and restore it. If it's present, make sure it's not corrupted.

Please mark my response helpful!

[Fromsee Genene]

@Maddysunil  

what about this error 'Could not find a record in pa_chart_color_schemes for column color_palette referenced in this update'

[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

[Maddysunil]

@Fromsee Genene 

Could you please accept and mark my response helpful. Happy to help you.

Thanks