Welcome Guest, Login


Quick Search

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

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.