Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
Outlook Sync
Install errors
Previous
Next
8/11/2010 10: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/17/2010 11:05 PM
DNN Module Support
Joined: 8/28/2006
Posts: 2065
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
Previous
Next
Home
Support
Outlook Sync
Install errors