Welcome Guest, Login


Quick Search

Attempting to delete a custom report that has a deleted custom field or depreciated CAREWare object results in the following error being generated on the central administration domain

Source: jProgBusiness - The DELETE statement conflicted with the REFERENCE constraint "rlt_fld_sl_slc_fl". 
The conflict occurred in database "CW_Data", table "dbo.cw_select_field", column 'slc_fl_fld_sl_fk'.

The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.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_field_selection WHERE fld_sl_pk = @fld_sl_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 build558
This bug was fixed in build580
TTP #1804

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.