Resolution: Errors After Installing Update Rollup for Dynamics CRM 2011

After installing an update rollup for Dynamics CRM 2011 ( I was installing UR12, but others have gotten the same error with outher URs), I started getting this error.


Log Name: Application Source: ASP.NET 4.0.30319.0 Date: 3/28/2013 8:40:04 AM Event ID: 1309 Task Category: Web Event Level: Warning Keywords: Classic User: N/A Computer: crm_server.domain.local Description: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 3/28/2013 8:40:04 AM Event time (UTC): 3/28/2013 1:40:04 PM Event ID: 857c1ec3a88c43799878637451e1b3a7 Event sequence: 36389 Event occurrence: 23 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT-1-140088322863478416 Trust level: Full Application Virtual Path: / Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\ Machine name: CRM_SERVER Process information: Process ID: 3508 Process name: w3wp.exe Account name: DOMAIN\service_account Exception information: Exception type: CrmException Exception message: Attribute objecttypecode on Entity PrincipalObjectAccessReadSnapshot is of type picklist but has Child Attributes Count 0 at
Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal() at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute() at Microsoft.Crm.ApplicationQuery.RetrieveMultipleCommand.RetrieveData() at Microsoft.Crm.ApplicationQuery.ExecuteQuery() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData() at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output) at ASP.claimsopssupporttest_tools_emailtemplateeditor_emailtemplateeditor_aspx.__RendercrmForm(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.Crm.Application.Forms.EndUserForm.Render(HtmlTextWriter output) at ASP.claimsopssupporttest_tools_emailtemplateeditor_emailtemplateeditor_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Request information: Request URL:     Request path: /CRMOrg/tools/emailtemplateeditor/emailtemplateeditor.aspx      Thread information: Thread ID: 24 Thread account name:
Stack trace: at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal() at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute() at Microsoft.Crm.ApplicationQuery.RetrieveMultipleCommand.RetrieveData() at Microsoft.Crm.ApplicationQuery.ExecuteQuery() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder) at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData() at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData() at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output) at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output) at ASP.claimsopssupporttest_tools_emailtemplateeditor_emailtemplateeditor_aspx.__RendercrmForm(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at Microsoft.Crm.Application.Forms.EndUserForm.Render(HtmlTextWriter output) at ASP.claimsopssupporttest_tools_emailtemplateeditor_emailtemplateeditor_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Page.Render(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I poked around a little and noticed that the update rollup wasn't applied to one of my organization database. We have two organization databases and one was at UR12 and the other was still at UR11. In deployment manager, I tried to manually update the database and it failed. That led me to this error that was in C:\Users\username\AppData\Roaming\Microsoft\MSCRM\Logs\crm50dmsnapin.log.

09:05:35| Error| Installer Complete: OrganizationDatabaseHotFixer - Error encountered 09:05:36| Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer: Action Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction failed. InnerException: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.DependencyBase' with unique index 'ndx_UniqueDependencyNodes'. The duplicate key value is (guid).The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkInsertDependencies(BusinessEntityCollection dependencies, ISqlExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.CreateComponentDependencies(Dictionary`2 recordsByComponentType, ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) at Microsoft.Crm.BusinessEntities.ExecutionContext.OnEndRequest() at Microsoft.Crm.Setup.MetadataPatchService.ProcessMetadataDiffFile(String targetRevision) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId) at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall) at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall) at Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase) at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdates(Guid orgId) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.Do(IDictionary parameters) at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo) InnerException: System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.DependencyBase' with unique index 'ndx_UniqueDependencyNodes'. The duplicate key value is (guid). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkInsertDependencies(BusinessEntityCollection dependencies, ISqlExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.CreateComponentDependencies(Dictionary`2 recordsByComponentType, ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) at Microsoft.Crm.BusinessEntities.ExecutionContext.OnEndRequest() at Microsoft.Crm.Setup.MetadataPatchService.ProcessMetadataDiffFile(String targetRevision) ClientConnectionId:be6bf5ae-acf5-4fe2-83a8-53e2gfe8a2a3 09:05:36| Info| Setting organization state. New state = Failed 09:05:36| Error| Update Organization with Id=(guid) failed with Exception: System.Exception: Action Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.DependencyBase' with unique index 'ndx_UniqueDependencyNodes'. The duplicate key value is (guid).The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkInsertDependencies(BusinessEntityCollection dependencies, ISqlExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.CreateComponentDependencies(Dictionary`2 recordsByComponentType, ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) at Microsoft.Crm.BusinessEntities.ExecutionContext.OnEndRequest() at Microsoft.Crm.Setup.MetadataPatchService.ProcessMetadataDiffFile(String targetRevision) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId) at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall) at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall) at Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase) at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdates(Guid orgId) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType) at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.Do(IDictionary parameters) at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo) --- End of inner exception stack trace --- at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo) at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver) at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver) at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute() at Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer.Execute() at Microsoft.Crm.Tools.Admin.ApplyDatabaseHotFixInstaller.ApplyDatabaseHotFix(IApplyDatabaseHotFixInfo applyDatabaseHotFixInfo)

The problem was with one of the ndx_UniqueDependencyNodes indexs. To fix that problem we followed a suggestion we found on http://social.microsoft.com/Forums/en-US/crm/thread/cf12f112-f9b7-4504-925e-7d837e32a808?prof=required that said to "open the index 'ndx_UniqueDependencyNodes' for 'dbo.DependencyBase' and select 'Skip repeating values' option on 'Parameters' tab. This option is next after 'Rebuild index'."

After that I was able up manually update the organization database from the deployment manager successfully. Unfortunately, we were still getting our original error. We ended up rebuilding that same index on the other organization database that originally was updated successfully while installing the update rollup, and the errors went away on the entire environment.

Read More

Filter Security Event Logs by User in Windows 2008 & Windows 7

If you are like me, you probably miss being able to easily filter your security event logs by a specific user like we did in previous versions of Microsoft Windows. Well, it is still possible in Windows 2008 and Windows 7. You just need to use the XML filter option. When you are in the security event logs, click on "Filter Current Log..." from the actions pane. Click the XML tab of the window that opens, and check the box next to "Edit query manually".

 

If you want to see all events in the security event log for a specific user, then you need to use an XML filter like this. (Make sure to replace <username> with the username that you want to show logs for.)

<QueryList>

<Query Id="0" Path="Security">

<Select Path="Security">* [EventData[Data[@Name='subjectUsername']='<username>']]</Select>

</Query>

</QueryList>

If you only want to see the successful and failed logon events for a specific user, than you could modify it to look like this.

<QueryList>

<Query Id="0" Path="Security">

<Select Path="Security">*[System[(EventID=4624 or EventID=4625)]]</Select>

<Select Path="Security">* [EventData[Data[@Name='subjectUsername']='<username>']]</Select>

</Query>

</QueryList>

 

 

Read More

Dynamics CRM: Authentication is Required - Timing Out and Prompting for Credentials

If you are running Dynamics CRM 4.0 and 2011 with claims based authentication, by default you get a prompt saying "Authentication is Required" after 20 minutes. If you want to extend this timeout, you need to make some changes to the relying party trust in Active Directory Federation Services (ADFS).

1. Log into your ADFS server and open the The Active Directory Federation Services (ADFS) Microsoft Management Console (MMC) and determine the name of the relying party trust that CRM is using.
2. Open a Powershell prompt with elevated privileges ( right-click and run as administrator ).
3. Add the ADFS snap-in for powershell by running: Add-PSSnapin Microsoft.Adfs.PowerShell
4. Run the following command from your powershell prompt. Change "relying_party" with the name you found in step 1, and you can replace 480 with the number of minutes that you want the timeout to be Set-ADFSRelyingPartyTrust -Targetname "relying_party" -TokenLifetime 480

Read More

List all of the Microsoft Hotfixes Installed on a System

If you need to list all of the Microsoft hotfixes/patches that are installed on a system, you can run the command below from a command prompt. Add/Remove Programs does not list them all.

wmic qfe list full /format:htable > C:\Temp\patches.htm

After you run the command, you need to open the file patches.htm that was created in the C:\Temp directory on your computer.

Read More

$10,000 Worth of Microsoft Training Videos For Free

Microsoft puts on a huge training event every once per year, per continent called TechEd. This event is great! It offers hundreds of different focused training sessions every year that you can choose from to further your education. However, the registration fee alone is over $2,000 (standard pricing), then you have travel and hotel expenses on top of that. Because of that, this is not something that everybody can afford to attend.

If you cannot go to Teched, you can still watch the sessions from previous years for free online. These videos won't give you the full conference experience, but they are a great learning resource that's available for free. Right now, there are videos for many of the sessions that happened between 2008 and 2013. If you figure $2,000 per year to attend the conference, that's like $10,000 worth of education available for free!

Check out the free videos at http://channel9.msdn.com/Events/TechEd/NorthAmerica

Read More

Fix Event ID# 7043 Load control template file /_controltemplates/TaxonomyPicker.ascx failed: Could not load type

This is an error that's a little misleading. At first it might seem that the file is missing or that there is a permissions issue, but that's not the case. The problem is that there is a bad charater in the template file.

Log Name:      Application

Source:        Microsoft-SharePoint Products-SharePoint Foundation

Date:          3/6/2013 1:07:44 PM

Event ID:      7043

Task Category: Web Controls

Level:         Error

Keywords:     

User:          DOMAIN\farm-admin

Computer:      sharepoint-server.domain.local

Description:

Load control template file /_controltemplates/TaxonomyPicker.ascx failed: Could not load type 'Microsoft.SharePoint.Portal.WebControls.TaxonomyPicker' from assembly 'Microsoft.SharePoint.Portal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e4bce131e9439c'.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6fb3e0cd-51e7-47ed-897a-241364937fc2}" />

    <EventID>7043</EventID>

    <Version>14</Version>

    <Level>2</Level>

    <Task>15</Task>

    <Opcode>0</Opcode>

    <Keywords>0x4000000000000000</Keywords>

    <TimeCreated SystemTime="2013-03-06T19:07:44.430Z" />

    <EventRecordID>143232</EventRecordID>

    <Correlation ActivityID="{EB866783-7CC2-4A8F-849D-D9551A56B66A}" />

    <Execution ProcessID="1508" ThreadID="6256" />

    <Channel>Application</Channel>

    <Computer>sharepoint-server.domain.local</Computer>

    <Security UserID="S-1-5-21-etc." />

  </System>

  <EventData>

    <Data Name="string0">Load control template file /_controltemplates/TaxonomyPicker.ascx failed: Could not load type 'Microsoft.SharePoint.Portal.WebControls.TaxonomyPicker' from assembly 'Microsoft.SharePoint.Portal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'.</Data>

  </EventData>

</Event>

To fix this, open up C:\Program Files\Common Files\ Microsoft Shared\Web Server Extensions\14\TEMPLATE\ControlTemplates\TaxonomyPicker.ascx in notepad. Search for &#44 and replace it with a comma. Then save the file and do an iisreset. Problem solved.

Read More

Fix Sharepoint/Powershell Error: The Farm is Unavailable

Below is an error that you can get in PowerShell or via STSADM for SharePoint

PS C:\> Get-SPServiceApplicationProxy
Get-SPServiceApplicationProxy : The farm is unavailable.
At line:1 char:30
+ Get-SPServiceApplicationProxy <<<<
    + CategoryInfo          : ResourceUnavailable: (Microsoft.Share...pplicationProxy:SPCmdletGetServiceApplicationProxy) [Get-SPServiceApplicationProxy], InvalidOperationException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletGetServiceApplicationProxy

This error occurs when the user running the command doesn't have enough access to the SQL server. You can either grant this user account more rights in SQL, or login and run the command with the farm admin account and this error should go away.

If you already have the SecurityAdmin role in SQL, you can run "Add-SPShellAdmin -UserName DOMAIN\User" at a powershell prompt to grant the rights rights in SQL that are needed as well.

Read More

The Distributed Transaction Coordinator service terminated with service-specific error 3221229584 (0xC0001010).

If you get the following error in the system event logs while trying to start the Distributed Transaction Coordinator service, we can help.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Description: The Distributed Transaction Coordinator service terminated with service-specific error 3221229584 (0xC0001010).

To fix this error, run the following error from an administrative command prompt, and then the service will start fine.

msdtc -resetlog

Read More

The IP Address You Have Entered for this Network Adapter is Already Assigned to Another Adapter

If you have ever replace and NIC card, either virtual or physical, and used the same static IP address as the old card had, you probably recognise the error below.

The IP address XXX.XXX.XXX.XXX you have entered for this network adapter is already assigned to another adapter <Name of adapter>. <Name of adapter> is hidden from the network and Dial-up Connections folder because it is not physically in the computer or is a legacy adapter that is not working. If the same address is assigned to both adapters and they become active, only one of them will use this address. This may result in incorrect system configuration.

Do you want to enter a different IP address for this adapter in the list of IP addresses in the advanced dialog box?

This is an annoying little message that you can click no on, and everything will still work fine. However, it will continue to pop up every time you go in and out of the network settings for that adapter. To get rid of this message, you need to remove the device the old NIC card using the directions below.

1. Run "set devmgr_show_nonpresent_devices=1" from an administrative command prompt. (if that doesn't work for you, another option is to add "devmgr_show_nonpresent_devices" as a new environment variable with a value of 1)
2. Go to Start > Run  and enter "start devmgmt.msc"
3. Click View > Show Hidden Devices
4. Expand the Network Adapters
5. Right-click the grayed out network adapter, then click Uninstall

Read More

VMWare Console Window Blank

There's an issue with Data Execution Prevention (DEP) in Windows that causes you to get a black empty screen , or a white blank screen while trying to connect to a VMWare console using the VSphere client, or the Virtual Infrastructure Client (VIC). You might also be presented with one of the following errors

• Unable to get the window handle for the 'AxQuickMksAxCtl' control. Windowless ActiveX controls are not supported.
• Exception has been thrown by the target of an invocation

To resolve this issue, run the following command from an administrative command prompt, then reboot.

bcdedit.exe /set nx AlwaysOff

Read More