Can't delete custom reports

Modified on Tue, 20 Dec 2011 17:59 by CAREWare Help Desk — Categorized as: FAQ

Deleting custom reports generates an error. When we add foreign keys to new tables, we forget to add the delete statement for that table when deleting the root table a record off the root table rather that must be a new table.

Error is: 
Source: jProgBusiness - The DELETE statement conflicted with the REFERENCE constraint "FK_grp_srv_rpr_sp_fk". The conflict occurred in database "CW_Data", table "dbo.cw_group_service_report_map", column 'grp_srv_rp_rpr_sp_fk'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at jProgBusiness.jBusiness.jSQLDeleteHelper.DeleteSingleRecord(IDbTransaction CurrentTrans, jUser User, String DomainPK, Boolean LogDelete) DELETE FROM cw_report_specification WHERE rpr_sp_pk = @rpr_sp_pk
 
   at jProgBusiness.jReports.jCustomReportOperations.deleteSpecification(String LoginToken, String specificationPK, Boolean deleteFieldsAndFilter)
   at jProgBusiness.jBusiness.jBusinessRemote.CRO_Delete_Specification(String SessionToken, String specificationPK, Boolean deleteFieldsAndFilter)
An error occurred while attempting to delete a custom report specification.

This bug was found in build522
This bug was fixed in build#
TTP #1695

Back to Bugs

Back to Frequently Asked Questions