Mittwoch, 18. Januar 2012

Update Rollup 5 Issue with SystemSettings - 'Organization' entity doesn't contain attribute with Name = 'isuseraccessauditenabled'.

Get an Issue after running UR5 on an multi Server environment at customer site.
As I´ve seen in the web that many people have this issue, I will share our findings here in an summary.
Issue:
========
We tried a couple of things on our CRM 2011 Servers instance and found 2 problems:
 •when importing a Solution with the System Settings embedded, the import fails saying the system settings fields are missing - very strange, since these fields are part of the system organization entity
 •when trying to activate Auditing (the global setting) I get the error "Query Builder Error" & the following error in the in the errordetails.txt: 'Organization' entity doesn't contain attribute with Name = 'isuseraccessauditenabled'. So I cannot enable auditing. Use Access auditing is a feature of UR5. I get the error regardless of enabling/disabling this new option.

Cause:
=======
It appears that Rollup 5 (build 1533) has been applied to CRM 2011, but not the databases, i.e. the CRM schemas have not been updated? I say this because
So it seems they have updated the CRM dll's but not the metadata!
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #96B4876FDetail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #96B4876F</Message>
  <Timestamp>2012-01-17T22:06:33.6688209Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147217149</ErrorCode>
    <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
    <Message>'Organization' entity doesn't contain attribute with Name = 'isuseraccessauditenabled'.</Message>
    <Timestamp>2012-01-17T22:06:33.6688209Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>
Solution:
===========
Installed UR5 on the Deployment Server Role as well which wasn´t the case (was missed).
This run of UR5 Installation  updated the Database and the CRM schemas correctly.
Webforms and Database is matching again and we are able to update SystemSettings again.
http://www.dynamicsconsulting.de/2012/01/18/update-rollup-5-issue-with-systemsettings-organization-entity-doesnt-contain-attribute-with-name-isuseraccessauditenabled/

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Free Samples By Mail