Cannot delete custom reports with deleted or deactivated custom fields

Modified on Thu, 01 Dec 2011 17:57 by CAREWare Help Desk — Categorized as: FAQ

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