none
【Sharepoint2010】UserProfile管理中,新建配置文件报错 RRS feed

  • 问题

  • 日志:

    880i High     System.Data.SqlClient.SqlException: Failed to load Msxmlsql.dll.     在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     在 System.Data.SqlClient.SqlDataReader.get_MetaData()     在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehav... f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05* w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880i High     ...ior, Boolean returnStream, Boolean async)     在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)     在 Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock) f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05  w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880k High        在 Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)     在 Microsoft.Office.Server.UserProfiles.DBHelper.RunSqlCommand(SqlCommand command)     在 Microsoft.Office.Server.UserProfiles.UserProfile.UpdateProfile(UserProfileUpdateWrapper update, Boolean forceBypassCanary)     在 Microsoft.Office.Server.UserProfiles.UserProfile.Commit()     在 Microsoft.Office.Server.UserProfiles.UserProfile..ctor(UserProfileManager objManager, String strAccountName, String strPreferredName)     在 Microsoft.Office.Server.UserProfiles.UserProfileManager.CreateUserProfile(String strAccountName, String strPreferredName)     在 Microsoft.Office.Server.UserProfiles.UserProfileManager.CreateUserProfile(String strAccountName)     在 Microsoft.Office.Server.UserProfiles.Us... f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05* w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880k High     ...erProfileManager.GetUserProfile(Boolean bCreateIfNotExist, Boolean loadFullProfile, Boolean bIsFirstAttempt)     在 Microsoft.Office.Server.UserProfiles.UserProfileManager.GetUserProfile(Boolean bCreateIfNotExist, Boolean loadFullProfile)     在 Microsoft.Office.Server.UserProfiles.ProfileLoader.EnsureUserProfile(Boolean bCreateIfNotExist)     在 Microsoft.Office.Server.UserProfiles.ProfileLoader.GetUserProfile()     在 Microsoft.SharePoint.Portal.WebControls.ProfilePropertyLoader.OnInit(EventArgs e)     在 System.Web.UI.Control.InitRecursive(Control namingContainer)     在 System.Web.UI.Control.InitRecursive(Control namingContainer)     在 System.Web.UI.Control.InitRecursive(Control namingContainer)     在 System.Web.UI.Control.InitRecursive(Control namingContainer)     在 System.Web.UI.Control.In... f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05* w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880k High     ...itRecursive(Control namingContainer)     在 System.Web.UI.Control.InitRecursive(Control namingContainer)     在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     在 System.Web.UI.Page.ProcessRequest()     在 System.Web.UI.Page.ProcessRequest(HttpContext context)     在 ASP._layouts_profnew_aspx.ProcessRequest(HttpContext context)     在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception err... f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05* w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880k High     ...or)     在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)     在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nati... f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05* w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880k High     ...veRequestContext, IntPtr moduleData, Int32 flags)   f5181c7a-23d2-44f1-a6ed-57f94bad02ab
    09/25/2012 09:16:43.05  w3wp.exe (0x217C)                        0x2570 SharePoint Server              Database                       880j High     SqlError: 'Failed to load Msxmlsql.dll.'    Source: '.Net SqlClient Data Provider' Number: 6610 State: 1 Class: 16 Procedure: 'sp_xml_preparedocument' LineNumber: 1 Server: 'SP-TEST-SERVER' f5181c7a-23d2-44f1-a6ed-57f94bad02ab


    开始Sharepoint旅程!

    2012年9月25日 1:53

答案

  • 问题解决了,从网上找到一个说法。

    Root cause:

    The issue happens due to the SQL installation order. When you Install SQL 2008 Express edition after SQL 2008 R2 installation, the "Msxmlsql.dll" file gets over written with the SQL 2008 Edition. This file is responsible of parsing XML and once its over written with the Express version, the issue start with any application.

    Solution/Workaround:

    The safest approach is to Uninstall the SQL 2008 Express edition.

    我就是先装了Sqlserver 2008 R2,然后装了VS2010(这里面自带了坑爹的Sqlserver 2008 Express)。

    我把Sqlserver 2008 Express卸载以后就OK了。


    开始Sharepoint旅程!

    • 已标记为答案 史向平 2012年9月25日 3:21
    2012年9月25日 3:21