Deleting Custom funding sources assigned to WIYC Report generates error

RSS

» Deleting Custom funding sources assigned to WIYC Report generates error

When a user tries to delete a custom funding source from Contracts and that funding source has been included in the WICY Report Funding section then the error below will be generated.

In order to work around this error a user must remove the custom funding source from the WICY report funding section prior to deleting the funding source

Source:  - An error occurred while saving provider setup information to the database.
If the problem persists, please contact technical support.
The DELETE statement conflicted with the REFERENCE constraint "FK_wic_fn_fnd_sr_rpk". The conflict occurred in database
 "CW_Data", table "dbo.cw_wicy_funding_map", column 'wic_fn_fnd_sr_rpk'.
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_funding_source WHERE fnd_sr_pk = @fnd_sr_pk
   at jProgBusiness.jBusiness.jDomainManager.Complete_Provider_Setup(jProviderDomain ProviderDomain, String GUIDToken, 
String VersionToken, DomainVariables dv)
   at jProgBusiness.jBusiness.jBusinessRemote.ADM_Complete_Provider_Setup(jProviderDomain ProviderDomain, String 
SessionToken, String version, DomainVariables dv)
server stack trace:
   at jProgBusiness.jBusiness.jBusinessRemote.ADM_Complete_Provider_Setup(jProviderDomain ProviderDomain, String 
SessionToken, String version, DomainVariables dv)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object 
server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] 
args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean 
fExecuteInContext)
Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at jProgBusiness.jBusiness.jBusinessRemote.ADM_Complete_Provider_Setup(jProviderDomain ProviderDomain, String 
SessionToken, String version, DomainVariables dv)
   at jProgBusiness.jBusiness.jClientSideRemote.ADM_Complete_Provider_Setup(jProviderDomain ProviderDomain, String 
SessionToken, String version, DomainVariables dv)
   at Client.SetupWizPrvLogo.finishWizard()
An error occurred while saving provider setup information to the database.

This bug was found in build	594
This bug was fixed in build	#
TTP #	1948

Back to Bugs

Back to Frequently Asked Questions