Install errors - Outlook Sync

Search Home

Home

Support

Outlook Sync

Install errors

8/11/2010 11:30 PM

James Wemyss

Joined: 8/2/2010

Posts: 4

Install errors (United Kingdom)

I have tried the install twice on 2 different DNN installs and both times getting warning errors

StartJob	Starting Installation
Info	Starting Installation - iWebs - OutlookSync
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Folder Created - C:"Inetpub"vhosts"untitledtm.com"httpdocs"DesktopModules"OutlookSync"
Info	Created - 43.01.01.SqlDataProvider
Info	Executing 43.01.01.SqlDataProvider
Info	Start Sql execution: 43.01.01.SqlDataProvider file
Info	End Sql execution: 43.01.01.SqlDataProvider file
Info	Created - 43.01.03.SqlDataProvider
Info	Executing 43.01.03.SqlDataProvider
Info	Start Sql execution: 43.01.03.SqlDataProvider file
Info	End Sql execution: 43.01.03.SqlDataProvider file
Info	Created - 43.02.02.SqlDataProvider
Info	Executing 43.02.02.SqlDataProvider
Info	Start Sql execution: 43.02.02.SqlDataProvider file
Info	End Sql execution: 43.02.02.SqlDataProvider file
Info	Created - 43.02.04.SqlDataProvider
Info	Executing 43.02.04.SqlDataProvider
Info	Start Sql execution: 43.02.04.SqlDataProvider file
Warning	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The object 'Users' does not exist or is invalid for this operation. 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) CREATE TRIGGER dbo.[dnn_iwebs_OS_OnUpdateEmail] ON Users FOR UPDATE AS IF UPDATE(Email) BEGIN DECLARE @UserID INT DECLARE @Email VARCHAR(100) DECLARE @PortalID INT DECLARE @EmailProfileDefID INT SET @PortalID=-1 SELECT @UserID=UserID,@Email=Email FROM Inserted SELECT @PortalID=PortalID FROM dnn_UserPortals WHERE UserID=@UserID SET @EmailProfileDefID=-1 IF @PortalID<>-1 BEGIN SELECT TOP 1 @EmailProfileDefID = PropertyDefinitionID FROM dnn_ProfilePropertyDefinition WHERE PortalID=@PortalID AND PropertyName='iWebs-Email' IF @EmailProfileDefID <>-1 BEGIN DECLARE @EmailProfileID INT SET @EmailProfileID=-1 SELECT TOP 1 @EmailProfileID=ProfileID FROM dnn_UserProfile WHERE UserID=@UserID AND PropertyDefinitionID=@EmailProfileDefID IF @EmailProfileID<>-1 BEGIN UPDATE dnn_UserProfile SET PropertyValue=@Email,LastUpdatedDate=GETDATE() WHERE ProfileID=@EmailProfileID AND PropertyValue<>@Email END ELSE BEGIN INSERT INTO dnn_UserProfile (UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate) VALUES (@UserID,@EmailProfileDefID ,@Email,0,GETDATE()) END END END END System.Data.SqlClient.SqlException: The object 'UserPortals' does not exist or is invalid for this operation. 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) CREATE TRIGGER dbo.[dnn_iwebs_OS_OnDeleteUser] ON UserPortals FOR DELETE AS DECLARE @UserID INT DECLARE @PortalID INT SET @PortalID=-1 SELECT @UserID=UserID,@PortalID=PortalID FROM Deleted INSERT INTO dnn_iwebs_OS_DeletedUsers (PortalID,UserID,DeletedOn) VALUES (@PortalID,@UserID,GETDATE())
Info	End Sql execution: 43.02.04.SqlDataProvider file
Info	Created - 45.01.01.SqlDataProvider
Info	Executing 45.01.01.SqlDataProvider
Info	Start Sql execution: 45.01.01.SqlDataProvider file
Warning	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The object 'UserPortals' does not exist or is invalid for this operation. 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 EXISTS(SELECT * FROM syscolumns WHERE id=object_id(N'dbo.[dnn_UserPortals]') and name=N'IsDeleted') BEGIN declare @SQL nvarchar(2000) select @SQL = 'CREATE TRIGGER dbo.[dnn_iwebs_OS_OnDeleteUserPortal] ON UserPortals FOR UPDATE AS ' select @SQL = @SQL+' IF UPDATE(IsDeleted) ' select @SQL = @SQL+' BEGIN ' select @SQL = @SQL+' DECLARE @UserID INT ' select @SQL = @SQL+' DECLARE @PortalID INT ' select @SQL = @SQL+' DECLARE @IsDeleted INT ' select @SQL = @SQL+' SET @PortalID=-1 ' select @SQL = @SQL+' SELECT @UserID=UserID,@PortalID=PortalID, @IsDeleted=IsDeleted FROM Inserted ' select @SQL = @SQL+' IF @IsDeleted=1 ' select @SQL = @SQL+' BEGIN ' select @SQL = @SQL+' INSERT INTO dnn_iwebs_OS_DeletedUsers (PortalID,UserID,DeletedOn) VALUES (@PortalID,@UserID,GETDATE()) ' select @SQL = @SQL+' END ' select @SQL = @SQL+' END ' EXEC sp_executesql @SQL END
Info	End Sql execution: 45.01.01.SqlDataProvider file
Info	Created - 45.05.06.SqlDataProvider
Info	Executing 45.05.06.SqlDataProvider
Info	Start Sql execution: 45.05.06.SqlDataProvider file
Info	End Sql execution: 45.05.06.SqlDataProvider file
Info	Created - 45.05.07.SqlDataProvider
Info	Executing 45.05.07.SqlDataProvider
Info	Start Sql execution: 45.05.07.SqlDataProvider file
Warning	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The object 'Users' does not exist or is invalid for this operation. 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) CREATE TRIGGER dbo.[dnn_iwebs_OS_OnUpdateEmail] ON Users FOR UPDATE AS IF UPDATE(Email) BEGIN DECLARE @UserID INT DECLARE @Email VARCHAR(100) DECLARE @FirstName VARCHAR(500) DECLARE @PortalID INT DECLARE @FirstNameProfileDefID INT SET @PortalID=-1 SELECT @UserID=UserID,@Email=Email,@FirstName=FirstName FROM Inserted SELECT @PortalID=PortalID FROM dnn_UserPortals WHERE UserID=@UserID SET @FirstNameProfileDefID=-1 IF @PortalID<>-1 BEGIN SELECT TOP 1 @FirstNameProfileDefID = PropertyDefinitionID FROM dnn_ProfilePropertyDefinition WHERE PortalID=@PortalID AND PropertyName='FirstName' IF @FirstNameProfileDefID <>-1 BEGIN DECLARE @FirstNameProfileID INT SET @FirstNameProfileID=-1 SELECT TOP 1 @FirstNameProfileID=ProfileID FROM dnn_UserProfile WHERE UserID=@UserID AND PropertyDefinitionID=@FirstNameProfileDefID IF @FirstNameProfileID<>-1 BEGIN UPDATE dnn_UserProfile SET LastUpdatedDate=GETDATE() WHERE ProfileID=@FirstNameProfileID END ELSE BEGIN INSERT INTO dnn_UserProfile (UserID,PropertyDefinitionID,PropertyValue,Visibility,LastUpdatedDate) VALUES (@UserID,@FirstNameProfileDefID ,@FirstName,1,GETDATE()) END END END END
Info	End Sql execution: 45.05.07.SqlDataProvider file
Info	Created - Uninstall.SqlDataProvider
Info	Finished Sql execution
Info	Component installed successfully - Script
Info	Starting Installation - Module
Info	Module registered successfully - iWebs - OutlookSync
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin"App_Web_Validate.ascx.8846829a.dll
Info	Created - bin"App_Web_Validate.ascx.8846829a.dll
Info	Assembly registered - bin"App_Web_PostBack.aspx.8846829a.dll
Info	Created - bin"App_Web_PostBack.aspx.8846829a.dll
Info	Assembly registered - bin"App_Web_ViewOutlookSync.ascx.8846829a.dll
Info	Created - bin"App_Web_ViewOutlookSync.ascx.8846829a.dll
Info	Assembly registered - bin"App_Web_EditOutlookSync.ascx.8846829a.dll
Info	Created - bin"App_Web_EditOutlookSync.ascx.8846829a.dll
Info	Assembly registered - bin"App_Web_EditItems.ascx.8846829a.dll
Info	Created - bin"App_Web_EditItems.ascx.8846829a.dll
Info	Assembly registered - bin"App_Web_EditViews.ascx.8846829a.dll
Info	Created - bin"App_Web_EditViews.ascx.8846829a.dll
Info	Assembly registered - bin"App_SubCode_OutlookSync.dll
Info	Created - bin"App_SubCode_OutlookSync.dll
Info	Component installed successfully - Assembly
Info	Starting Installation - File
Info	Created - Validate.ascx
Info	Created - PostBack.aspx
Info	Created - ViewOutlookSync.ascx
Info	Created - EditOutlookSync.ascx
Info	Created - EditItems.ascx
Info	Created - EditViews.ascx
Info	Created - App_SubCode_OutlookSyncHttpModule.code
Info	Created - OutlookContacts.asmx
Info	Created - Module.css
Info	Component installed successfully - File
Info	Starting Installation - ResourceFile
Info	Expanding Resource file
Info	Created - App_LocalResources/EditItems.ascx.resx
Info	Created - App_LocalResources/EditOutlookSync.ascx.resx
Info	Created - App_LocalResources/EditViews.ascx.resx
Info	Created - App_LocalResources/ViewOutlookSync.ascx.resx
Info	Created - Images/apply.gif
Info	Created - Images/apply2.gif
Info	Created - Images/arr.gif
Info	Created - Images/backimg_01.jpg
Info	Created - Images/backimg_02.jpg
Info	Created - Images/bg_button_a.gif
Info	Created - Images/bg_button_span.gif
Info	Created - Images/button-design.gif
Info	Created - Images/buy1.jpg
Info	Created - Images/buy2.jpg
Info	Created - Images/buynow.jpg
Info	Created - Images/buynow2.jpg
Info	Created - Images/cancel.jpg
Info	Created - Images/cancel2.jpg
Info	Created - Images/DeleteItem.gif
Info	Created - Images/dotnetnuke_logo.gif
Info	Created - Images/help.jpg
Info	Created - Images/help1.gif
Info	Created - Images/help2.jpg
Info	Created - Images/interactiveweb_logo.gif
Info	Created - Images/interwebs.jpg
Info	Created - Images/Items.gif
Info	Created - Images/Left.gif
Info	Created - Images/LeftTop.gif
Info	Created - Images/LookAndFeel.gif
Info	Created - Images/menubgItems.jpg
Info	Created - Images/menubgViews.jpg
Info	Created - Images/Note.gif
Info	Created - Images/request.gif
Info	Created - Images/request2.gif
Info	Created - Images/Right.gif
Info	Created - Images/RightBottom.gif
Info	Created - Images/SaveItem.gif
Info	Created - Images/snowcovered_logo.gif
Info	Created - Images/sub.gif
Info	Created - Images/submit.jpg
Info	Created - Images/submit2.jpg
Info	Created - Images/Views.gif
Info	Created - Images/Warning.gif
Info	Resource Files created
Info	Component installed successfully - ResourceFile
Info	Installation committed
Info	Installation successful. - iWebs - OutlookSync
Info	Deleted temporary install folder
EndJob	Installation successful.

8/18/2010 12:05 AM

DNN Module Support

Joined: 8/28/2006

Posts: 2064

Re: Install errors (Australia)

We have identified this as a problem with the Outlook sync not correctly supporting SQL Object Qualifier for a shared database. We have released a version 45.05.09 and above today that will resolve this issue.

Page 1 of 1

Connect to us