Thanks Joe,
looking at the logs I see the following exception(s):
Install Package::Dnn.PersonaBar.Users
Info::Starting Installation
Info::Starting Installation - Dnn.PersonaBar.Users
Info::Starting Installation - ResourceFile
Info::Expanding Resource file
Info::Creating backup of previous version - App_LocalResources\Users.resx
Info::Created - App_LocalResources/Users.resx
Info::Creating backup of previous version - css\Users.css
Info::Created - css/Users.css
Info::Creating backup of previous version - scripts/bundles\users-bundle.js
Info::Created - scripts/bundles/users-bundle.js
Info::Creating backup of previous version - scripts/exportables/Users\UsersCommon.js
Info::Created - scripts/exportables/Users/UsersCommon.js
Info::Creating backup of previous version - scripts\Users.js
Info::Created - scripts/Users.js
Info::Creating backup of previous version - Users.html
Info::Created - Users.html
Info::Resource Files created
Info::Component installed successfully - ResourceFile
Info::Starting Installation - Assembly
Info::Assembly registered - bin\Dnn.PersonaBar.Users.dll
Info::Creating backup of previous version - bin\Dnn.PersonaBar.Users.dll
Info::Created - bin\Dnn.PersonaBar.Users.dll
Info::Component installed successfully - Assembly
Info::Starting Installation - Script
Info::Begin Sql execution
Info::Creating backup of previous version - Providers\DataProviders\SqlDataProvider\Install.SqlDataProvider
Info::Created - Providers\DataProviders\SqlDataProvider\Install.SqlDataProvider
Info::Executing Install.SqlDataProvider
Info::Start Sql execution: Install.SqlDataProvider file
Info::SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'ProactiveDNNUsr2.sysobjects'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:684382ca-2fae-4db6-90b4-3dd2fe29262a Error Number:208,State:1,Class:16 /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for ProactiveDNNUsr2. and *****/ /***** *****/ /************************************************************/ IF EXISTS (SELECT * FROM ProactiveDNNUsr2.sysobjects where id = object_id(N'ProactiveDNNUsr2.Personabar_GetUsersByUserIds') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE ProactiveDNNUsr2.Personabar_GetUsersByUserIds System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Personabar_GetUsersByUserIds' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:684382ca-2fae-4db6-90b4-3dd2fe29262a Error Number:2714,State:3,Class:16 CREATE PROCEDURE ProactiveDNNUsr2.Personabar_GetUsersByUserIds ( @PortalId INT, @UserIds nvarchar(max) -- comma separated list of UserIds ) AS BEGIN SELECT DISTINCT U.UserID, U.Username, U.DisplayName, U.Email, U.CreatedOnDate, U.IsDeleted, U.Authorised FROM ProactiveDNNUsr2.vw_Users U WITH (NOLOCK) INNER JOIN (Select RowValue FROM ProactiveDNNUsr2.ConvertListToTable(',',@UserIds)) UserIds ON U.UserID = UserIds.RowValue INNER JOIN ProactiveDNNUsr2.UserPortals UP WITH (NOLOCK) ON U.UserID = UP.UserId WHERE UP.PortalId = @PortalId END System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'ProactiveDNNUsr2.sysobjects'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:684382ca-2fae-4db6-90b4-3dd2fe29262a Error Number:208,State:1,Class:16 IF EXISTS (SELECT * FROM ProactiveDNNUsr2.sysobjects where id = object_id(N'ProactiveDNNUsr2.Personabar_GetUsers') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE ProactiveDNNUsr2.Personabar_GetUsers System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Personabar_GetUsers' in the database. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:684382ca-2fae-4db6-90b4-3dd2fe29262a Error Number:2714,State:3,Class:16 CREATE PROCEDURE ProactiveDNNUsr2.Personabar_GetUsers ( @PortalId INT, @SortColumn NVARCHAR(32), @SortAscending BIT, @PageIndex int = 0, @PageSize int = 10 ) AS BEGIN SELECT COUNT(*) AS TotalRecords FROM ProactiveDNNUsr2.UserPortals UP WITH (NOLOCK) INNER JOIN ProactiveDNNUsr2.Users U WITH (NOLOCK) ON UP.UserId = U.UserID WHERE UP.PortalId = @PortalId AND IsSuperUser = 0 ;WITH UsersCTE AS ( SELECT U.UserID, U.Username, U.DisplayName, U.Email, U.CreatedOnDate, U.IsDeleted, U.Authorised, ROW_NUMBER() OVER ( ORDER BY CASE WHEN @SortColumn = 'Joined' AND @SortAscending = 1 THEN U.UserID END ASC, CASE WHEN @SortColumn = 'Joined' AND @SortAscending = 0 THEN U.UserID END DESC, CASE WHEN @SortColumn = 'Email' AND @SortAscending = 1 THEN U.Email END ASC, CASE WHEN @SortColumn = 'Email' AND @SortAscending = 0 THEN U.Email END DESC, CASE WHEN @SortColumn = 'DisplayName' AND @SortAscending = 1 THEN U.DisplayName END ASC, CASE WHEN @SortColumn = 'DisplayName' AND @SortAscending = 0 THEN U.DisplayName END DESC) AS RowNumber FROM ProactiveDNNUsr2.vw_Users U WITH (NOLOCK) INNER JOIN ProactiveDNNUsr2.UserPortals UP WITH (NOLOCK) ON U.UserID = UP.UserId WHERE UP.PortalId = @PortalId AND IsSuperUser = 0 ) SELECT * FROM UsersCTE WHERE RowNumber BETWEEN (@PageIndex * @PageSize + 1) AND ((@PageIndex + 1) * @PageSize); END
Info::End Sql execution: Install.SqlDataProvider file
Info::Finished Sql execution
Info::Installation Failed - Script
Info::Rolling back component install - ResourceFile
Info::Exception - Could not find file 'C:\Inetpub\vhosts\domainname.co.nz\httpdocs\Install\Temp\234rnadlResources.zip'.
Info::Component rolled back successfully - ResourceFile
Info::Rolling back component install - Assembly
Info::Restored backup of previous version - bin\Dnn.PersonaBar.Users.dll
Info::Component rolled back successfully - Assembly
Info::Installation Failed - Dnn.PersonaBar.Users
Info::Deleted temporary install folder
Info::Installation Failed