Upgrade attempt #2:
After successfully upgrading the DNN base install to 4.8.2, attempted to upgrade the reports module to v5.0.0 (from v4.0.5) yields the following error:
StartJob Starting Installation
StartJob Reading files
Info Loading 05.00.00.txt
Info File 05.00.00.txt read successfully
Info Loading license.html
Info File license.html read successfully
Info Loading Reports.dnn
Info File Reports.dnn read successfully
Info Loading 04.04.02.SqlDataProvider
Info File 04.04.02.SqlDataProvider read successfully
Info Loading 04.05.00.SqlDataProvider
Info File 04.05.00.SqlDataProvider read successfully
Info Loading 05.00.00.SqlDataProvider
Info File 05.00.00.SqlDataProvider read successfully
Info Loading resources.zip
Info File resources.zip read successfully
Info Loading DotNetNuke.Modules.Reports.dll
Info File DotNetNuke.Modules.Reports.dll read successfully
EndJob Reading files done.
StartJob Reading Installation Manifest file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'Reports' module
EndJob Manifest file finished successfully
StartJob Begin Sql execution
Info Executing 05.00.00.SqlDataProvider
StartJob Start Sql execution: 05.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_dnn_ModuleSettings'. Cannot insert duplicate key in object 'dbo.dnn_ModuleSettings'. Violation of PRIMARY KEY constraint 'PK_dnn_ModuleSettings'. Cannot insert duplicate key in object 'dbo.dnn_ModuleSettings'. Violation of PRIMARY KEY constraint 'PK_dnn_ModuleSettings'. Cannot insert duplicate key in object 'dbo.dnn_ModuleSettings'. The statement has been terminated. 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.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) IF NOT EXISTS (SELECT * FROM dbo.dnn_PackageTypes WHERE PackageType='DNN_Reports_DataSource') BEGIN INSERT INTO dbo.dnn_PackageTypes(PackageType, Description, SecurityAccessLevel) VALUES ('DNN_Reports_DataSource', 'DNN Reports Data Source', 3) END IF NOT EXISTS (SELECT * FROM dbo.dnn_PackageTypes WHERE PackageType='DNN_Reports_Visualizer') BEGIN INSERT INTO dbo.dnn_PackageTypes(PackageType, Description, SecurityAccessLevel ) VALUES ('DNN_Reports_Visualizer', 'DNN Reports Visualizer', 3) END -- Set Modules to use DNN Data Source by default INSERT INTO dbo.dnn_ModuleSettings SELECT M.ModuleID, 'dnn_Reports_DataSource' as SettingName, 'DotNetNuke' as SettingValue FROM (SELECT ModuleId FROM dbo.dnn_ModuleSettings WHERE SettingName = 'dnn_Reports_Query') AS M -- Set Modules to use DNN Data Source by default INSERT INTO dbo.dnn_ModuleSettings SELECT M.ModuleID, 'dnn_Reports_DataSourceClass' as SettingName, 'DotNetNuke.Modules.Reports.DataSources.DotNetNuke.DotNetNukeDataSource' as SettingValue FROM (SELECT ModuleId FROM dbo.dnn_ModuleSettings WHERE SettingName = 'dnn_Reports_Query') AS M -- Convert query settings UPDATE dbo.dnn_ModuleSettings SET SettingName = 'dnn_ReportsDS_DotNetNuke_Query' WHERE SettingName = 'dnn_Reports_Query'
EndJob End Sql execution: 05.00.00.SqlDataProvider file
EndJob Finished Sql execution
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
Info Created C:\DotNetNuke_2\Website\bin\DotNetNuke.Modules.Reports.dll
Failure ExceptionSystem.UnauthorizedAccessException: Access to the path 'C:\DotNetNuke_2\Website\DesktopModules\Reports\Providers\DataProviders\SqlDataProvider\04.04.02.SqlDataProvider' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateDataProviderFile(PaFile file, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()
Any help at all would be greatly appreciated.