Hi,

When I am trying to install DMX 6.01 I am getting the following error.
Error loading files from temporary folder - see below (truncated)
Then Failure Installation Failed - Script. Any ideas why this might be happening?

Thanks,

Chris

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DMX_Extensions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.DMX_Extensions SET ControlToLoad = 'bring2mind/dmx/edits/editentry.ascx' WHERE ControlToLoad = 'bring2mind/dmx/editentry.ascx' System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DMX_Extensions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.DMX_Extensions SET ControlToLoad = 'bring2mind/dmx/edits/editentrypb.ascx' WHERE ControlToLoad = 'bring2mind/dmx/editentrypb.ascx' System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DMX_Extensions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.DMX_Extensions SET ControlToLoad = 'bring2mind/dmx/views/ajaxtwopanel.ascx' WHERE ControlToLoad = 'bring2mind/dmx/viewcollection.ascx' System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DMX_Extensions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.DMX_Extensions SET ControlToLoad = 'bring2mind/dmx/views/ajaxthreepanel.ascx' WHERE ControlToLoad = 'bring2mind/dmx/viewthreepanel.ascx' System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.DMX_Extensions'. at

Hi Chris,

Is this a new install or an upgrade? The error comes from the upgrade logic but it's complaining it can't find the original DMX stuff that should have been there. So it's like the DB had no DMX in it, but the module definitions did.

Peter

Hi Peter,

This is an upgrade. Should I try uninstalling and doing a new install?

Chris

First: if you uninstall you lose all data. If you have no important data in DMX you can always do that, but just be aware of this.

Second: if this were an upgrade the table DMX_Extensions should have been there in SQL. Yet it was not. This threw the upgrade script off. How could that have happened? Did you try to uninstall before? Or did someone remove the table by hand?

Peter

Peter,

Sorry for the late response, I have been on vacation. I had just installed it to try it out before purchasing so losing data isnt a big deal. I tried Uninstalling and got the following:

ExceptionSystem.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_PortalDesktopModules_DesktopModules". The conflict occurred in database "DotNetNuke", table "dbo.PortalDesktopModules", column 'DesktopModuleID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeleteDesktopModule(Int32 desktopModuleId) at DotNetNuke.Entities.Modules.DesktopModuleController.DeleteDesktopModule(Int32 desktopModuleID) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.DeleteModule()
Info Component uninstalled successfully - Module
Warning Component Uninstalled with Warnings - Module
Info Starting Component Uninstall - Config
Info Component uninstalled successfully - Config
Info Component Uninstall Successful - Config
Info Starting Component Uninstall - ResourceFile
Failure Exception - Could not find file 'D:\DotNetNuke\DesktopModules\Bring2mind\DMX\resources.zip.manifest'.
Info Component uninstalled successfully - ResourceFile
Warning Component Uninstalled with Warnings - ResourceFile
Failure ExceptionSystem.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_PortalDesktopModules_DesktopModules". The conflict occurred in database "DotNetNuke", table "dbo.PortalDesktopModules", column 'DesktopModuleID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeleteDesktopModule(Int32 desktopModuleId) at DotNetNuke.Entities.Modules.DesktopModuleController.DeleteDesktopModule(Int32 desktopModuleID) at DotNetNuke.Services.Installer.Packages.PackageController.DeletePackage(PackageInfo package) at DotNetNuke.Services.Installer.Installer.UnInstallPackages(Boolean deleteFiles) at DotNetNuke.Services.Installer.Installer.UnInstall(Boolean deleteFiles)

Right. A DNN uninstall error. OK, I'm not sure where this comes from, but by the looks of it you'll need to dig in and try to uninstall by hand. This means:
1. On the server's hard disk delete DesktopModules/Bring2mind/DMX folder and the Bring2mind dlls from the bin folder
2. Delete Portals/**/DMX folders
3. In Web.config remove any lines containing the word "Bring2mind"
4. In SQL remove any table/view/sproc/function prefixed by "DMX_"
5. *If* you've used the DMX folderprovider (which you've probably not) you'd need to remove all records from FolderMappings that have the Bring2mind DMX Provider
6. Finally: you need to remove the DesktopModules entry for Document Exchange. This is where it gets tricky. The error is DNN compaining it couldn't rip out this record. So you need to try and determine which record was tied to this and try to delete that. It complained about records in PortalDesktopModules being tied to this. I've not seen this error before, but I guess that removing those records will suffice. Presumably you've added the DMX module as a specific/premium module for certain portals. I'm not sure.

Peter

Peter,

That fixed it all up. I got everything reinstalled and it is working now.

Thanks so much for your help.

Chris