INSERT Error when Updating Published Report

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

INSERT Error when Updating Published Report

Affected Software/Reports/DLL(s): Any previously published reports


Affected Software Version: N/A


Symptoms: The following error may occur when trying to update a published a report.


System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__st_user_report_p__70099B30". The conflict occurred in database "[database]", table "dbo.st_report_parameter".

The statement has been terminated.



Cause/Details: This error may indicate that an older version of the report DLL has been published to the database and has not been updated.


Resolution/Workaround: Update the published report. More details on updating the published report can be found here.