When trying to delete a portal I get hte following error.

Error: Portals is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_UserImport_Modules". The conflict occurred in database "qef_beta1", table "dbo.DataSprings_UserImport", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_Modules_Portals". The conflict occurred in database "qef_beta1", table "dbo.Modules", 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_UserImport_Modules". The conflict occurred in database "qef_beta1", table "dbo.DataSprings_UserImport", column 'ModuleID'. The DELETE statement conflicted with the REFERENCE constraint "FK_Modules_Portals". The conflict occurred in database "qef_beta1", table "dbo.Modules", 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 trace ---

This is pretty serious - is there no support for this???!

I cant delete a portal becasue of the dynamic import module and this has had no reply in days, please help.

Wow that is annoying,

I have to go through and delete all the Foreign Keys to all the Datasprings modules in my site so I can delete a portal. Cant this be integrated in the module code?

I have done so but what effect is this going to have on the site? Im worried my production site is going to crash.

Hi Marc,

Sorry, I actually thought that this was related to our user directory module where it was having a problem clearing the recycle bin because of one foreign constraint. I honestly have not seen this anywhere else before.

https://www.datasprings.com/Products/Product-Forums/tabid/727/view/topic/postid/1764/Default.aspx

Yes - Basically you would either need to remove the constraints for these (I can’t see any impact besides the fact of referential integrity and possibly minor performance). Basically you will end up having rows in those tables that reference portal ID’s that no longer exist. So you can either:

1. Remove the constraints
2. Remove the rows in the database for the User Import / Directory Modules that are directly related to the portal ID you are trying to delete

This is something ill have to check on, I have seen this on rare occasions with the directory module but I have never seen anything posted on this related to the Interactive User Import module. We might review not adding this constraint in the installation for future builds.

Thanks for your understanding. Also please keep in mind that community forums are great and we encourage their use however responses within the community forums do not follow along with our standard support policy at http://www.datasprings.com/ProductSupport.

Thanks,

Chad

Also, please keep in mind its Sunday here in the U.S.

Thanks,
Chad

Understand, I just saw a fundamental flaw that was restricting typical DNN functions and therefore I assume is a bug that qualifies for immediate support. With the FK constraints dropped, all seems well with the portal deletion and I have seen no adverse effects.

I am getting user deletion Errors with the DR module. I know that it is only a soft delete and that is fine but there is still an "ERROR while deleting user" both from the DR user manager and DNN user manager. I think there are more FK isues in there?

Thanks for you help.

I got a similar message when I was emptying my recycle bin. I use several datasprings modules but not the user import. Anyway my message was the same except:

FK_DataSprings_DynamicViews_Modules

What I did was to select all the pages and click delete, then the same with the modules and then it was empty... also I could then successfully click on empty recycle bin.

Hope this helps

Now getting further issies with more FKs

DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_DataSprings_DynamicLogin_Role_Roles". The conflict occurred in database "qef_beta1", table "dbo.DataSprings_DynamicLogin_Role", column 'RoleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint

It seems like every DataSprings module has FKs that hinder portal and user deletion. So Im going through dropping all these constraints not knowing what impact there will be down the line.

And then I have to repeat all over again on the next site... really annoying.