I tried to delete a portal that had an instance of the User Directory on one of its pages, and I got the following error:

 

Error: Portals is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Modules". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Portals". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'PortalID'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Modules". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicUserDirectory_Portals". The conflict occurred in database "A3250372", table "dbo.DataSprings_DynamicUserDirectory", column 'PortalID'. The statement has been terminated. 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.grdPortals_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack

 

It seems to have left the portal in kind of a quasi-deleted stage, as I can no longer navigate to the portal to try to delete the UD module that was causing the problem.

Not an earth-shattering problem, but it would be nice if it could be fixed in the next release. When is a new release planned for this module?

Hi, execute this under Host/SQL and let me know if this fixes you up.

ALTER TABLE DataSprings_DynamicUserDirectory
DROP CONSTRAINT FK_DataSprings_DynamicUserDirectory_Modules

I just had this same issue (DNN 4.9.5 and DUD 2.5.3) .. could not clear DUD from recycle bin .. received same error as above. I ran the SQL script and all was resolved.

 

Thanks

 

Kelly

Kelly,

Thanks for posting this... Always great to see someone post when a solution worked for them instead of only when it doesn't

-Chad

Will this SQL impact the DUD modules on any other portal?

I have DUD on several portals, when I tried to delete a portal I got the same error message.  I want to get thinngs cleaned up properly, but I do not want to do so at the expence of DUD function on my other portals.

Thanks,

Jack

HI, this SQL command is only to remove the constraint for deleting the DUD module from a portal but it should not effect any DUD module functionality if that module is not deleted. -- David