| StartJob |
Start Sql execution: 03.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. 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, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.grmRepositoryObjects SET CategoryId = (SELECT Cast(ItemID as varchar(2)) + ';' from dbo.grmRepositoryCategories WHERE dbo.grmRepositoryObjects.ModuleId=dbo.grmRepositoryCategories.ModuleID) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RepositoryObjects') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN Declare @OldModuleID int Declare @NewModuleID int INSERT INTO dbo.DesktopModules (FriendlyName, Description, Version, isPremium, IsAdmin,BusinessControllerClass,FolderName,ModuleName,SupportedFeatures) VALUES ('Gooddogs Repository', 'This module is a download/resource module', '',0,0,'Gooddogs.Repository.RepositoryController, Gooddogs.Repository','Repository', 'Gooddogs Repository', 3) DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor INSERT INTO dbo.ModuleDefinitions (FriendlyName, DesktopModuleID,DefaultCacheTime) VALUES ('Gooddogs Repository', @NewModuleID,0) DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor UPDATE dbo.Modules SET ModuleDefID = @NewModuleID WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Repository' DELETE FROM dbo.ModuleControls WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.DesktopModules WHERE FriendlyName = 'Repository' END |
| EndJob |
End Sql execution: 03.00.00.SqlDataProvider file |
| ... |
| Info |
Executing 03.00.01.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.01.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.01.SqlDataProvider file |
| |
| Info |
Executing 03.00.02.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.02.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.02.SqlDataProvider file |
| |
| Info |
Executing 03.00.03.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.03.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.03.SqlDataProvider file |
| |
| Info |
Executing 03.00.04.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.04.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.04.SqlDataProvider file |
| |
| Info |
Executing 03.00.05.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.05.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.05.SqlDataProvider file |
| |
| Info |
Executing 03.00.06.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.06.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.06.SqlDataProvider file |
| |
| Info |
Executing 03.00.07.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.07.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.07.SqlDataProvider file |
| |
| Info |
Executing 03.00.08.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.08.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.08.SqlDataProvider file |
| |
| Info |
Executing 03.00.09.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.09.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.09.SqlDataProvider file |
| |
| Info |
Executing 03.00.10.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.10.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.10.SqlDataProvider file |
| |
| Info |
Executing 03.00.11.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.11.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.11.SqlDataProvider file |
| |
| Info |
Executing 03.00.12.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.12.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.12.SqlDataProvider file |
| |
| Info |
Executing 03.00.13.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.13.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.13.SqlDataProvider file |
| |
| Info |
Executing 03.00.14.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.14.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.14.SqlDataProvider file |
| |
| Info |
Executing 03.00.15.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.15.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.15.SqlDataProvider file |
| |
| Info |
Executing 03.00.16.SqlDataProvider |
| StartJob |
Start Sql execution: 03.00.16.SqlDataProvider file |
| EndJob |
End Sql execution: 03.00.16.SqlDataProvider file |
| |
| Info |
Executing 03.01.00.SqlDataProvider |
| StartJob |
Start Sql execution: 03.01.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. 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, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.grmRepositoryObjects SET CategoryId = (SELECT Cast(ItemID as varchar(2)) + ';' from dbo.grmRepositoryCategories WHERE dbo.grmRepositoryObjects.ModuleId=dbo.grmRepositoryCategories.ModuleID) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RepositoryObjects') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN Declare @OldModuleID int Declare @NewModuleID int INSERT INTO dbo.DesktopModules (FriendlyName, Description, Version, isPremium, IsAdmin,BusinessControllerClass,FolderName,ModuleName,SupportedFeatures) VALUES ('Gooddogs Repository', 'This module is a download/resource module', '',0,0,'Gooddogs.Repository.RepositoryController, Gooddogs.Repository','Repository', 'Gooddogs Repository', 3) DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor INSERT INTO dbo.ModuleDefinitions (FriendlyName, DesktopModuleID,DefaultCacheTime) VALUES ('Gooddogs Repository', @NewModuleID,0) DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor UPDATE dbo.Modules SET ModuleDefID = @NewModuleID WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Repository' DELETE FROM dbo.ModuleControls WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.DesktopModules WHERE FriendlyName = 'Repository' END |
| EndJob |
End Sql execution: 03.01.00.SqlDataProvider file |