Hi There,

After downgrading from 7.3.1 PE to 7.3.1 CE and then upgrading to 7.4.1 CE, i am experiencing issues with adding and deleting a portal. I will be grateful for any help from the community, it was working on 7.3.1 CE. Below is the error log:

Error: Site Management is currently unavailable.DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_Files_Portals". The conflict occurred in database "mydatabase", table "dbo.Files", column 'PortalId'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_Files_Portals". The conflict occurred in database "mydatabase", table "dbo.Files", column 'PortalId'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PetaPoco.Database.Execute(String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.DataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInternal(Int32 portalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.OnGridDeleteCommand(Object source, GridCommandEventArgs e) --- End of inner exception stack trace ---

Kind Regards,
Vishal

Hi Sabastien,

Thanks for your response. How do i investigate this?

Regards,

Vishal

Hi Sebastian,

I looked under Databases>mydatabase>Programmability>Stored Procedures>dbo.DeleteFiles . Is this the right stored procedure i'm looking at? Script Below:

USE [mydatabase]

GO

/****** Object:  StoredProcedure [dbo].[DeleteFiles]    Script Date: 09/16/2015 16:58:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[DeleteFiles]

    @PortalID int

AS

BEGIN

    IF @PortalID is null

    BEGIN

        DELETE FROM dbo.Files WHERE PortalId is null

    END ELSE BEGIN

        DELETE FROM dbo.Files WHERE PortalId = @PortalID

    END

END

Kind Regards,

Vishal