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

Fromsee Genene · ‎02-13-2024

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 · ‎02-13-2024

@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 · ‎02-13-2024

@Maddysunil

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

Maddysunil · ‎02-13-2024

@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:

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.
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.
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

View solution in original post

Maddysunil · ‎02-13-2024

@Fromsee Genene

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

Thanks