Archive for March, 2012

Error Message: The report parameter ‘P1? is read-only and cannot be modified. (rsReadOnlyReportParameter)

March 16, 2012

Came across this error last week with any custom report that was uploaded into MSCRM.

The error seems to be a known issue with MSCRM 4 & SSRS 2008 R2

The following workaround should solve this error

To resolve the error message, update the report parameters in the SQL Server Reports Manager to Prompt User for the parameters created by CRM.

  1. Navigate to the Reports Manager website (i.e. /Reports”>http://<ServerName>/Reports)
  2. Click to open the <ORGNAME>_MSCRM folder
  3. Click on Details View
  4. Click on the 4.0 folder
  5. Select the Dropdown menu next to the GUID value associated with the report, and select Manage.
  6. Select Parameters.
  7. For the P1 Parameter, mark the Hide checkbox
  8. Repeat Step #7 for all P<#> Parameters that exist and also and CRM_<NAME> Parameters that exist
  9. Click Apply to save changes

Here is the KB article that will give you more detail on this.


SharePoint Site Collection Lock and Unlocking

March 14, 2012

Reasons for SharePoint Site Lock (Read only Mode)

  1. Site Collection Backup cancelled or interrupted
  2. Broken web part locks out SharePoint site

When upgrading a custom web part in SharePoint, it is REALLY important to uninstall the previous version of the web part and its referencing web pages or risk locking out all users including the Administrator from your website.
Impacts on the SharePoint site:

  1. Site Collection will be turn into Read only mode. Nothing can be saved.
  2. All Farm administrators and site collection Administrator will get access denied on several pages like Create.aspx and AreaNavigation.aspx
  3. You cannot able to add any user and not even you wont see the option to add user.
  4. If you try to open through SharePoint designer it will open in Contributor mode(Content Author) and you cannot able to See code view and cannot copy or Modify any thing

Solution: Go to Central Administration > Application Management > Site Collection Quotas and Locks Select the Site Collection and chose the correct option to unlock the site as below. Lock status for this site: Not locked — Select this option to unlock Adding content prevented Read-only (blocks additions, updates, and deletions) No access
After Selecting the Option Not Lock, the issue will be resolved and you can able to view all the options.

The SELECT permission was denied on the object ‘FilteredActivityPointer’, database ‘MicrosoftCRM_MSCRM’ schema ‘dbo’

March 12, 2012

If you received the following error.

The SELECT permission was denied on the object ‘BuildVersion’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’ or the variation The SELECT permission was denied on the object ‘SystemUser’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’

If you have tried changing the owner of new database with admin login making it as dbowner but did not help then following may help solving this problem

Right click the affected object (table/view etc) in my case it was ‘BuildVersion’ and ‘SystemUser’ in SQL Server Management Studio, click on properties click on “Permissions” on left tab click on “View schema permission” link on right tab click on “Add” button, click on “Browse” select “CRMReaderRole” of type Database role. click ok, click ok, now you will be again in object properties. Place check mark in “Grant” column against “Select” permission click ok

To change the dbowner command is (If required)

use <CRMDatabaseThatYouNeedToChangeTheOwner>

exec sp_changedbowner ‘DOMAIN\AdministratorMappedWithCrmAdmin’


Turn of read-only mode after an interrupted backup

March 12, 2012

Per default a site is set in read-only mode during backup. If the backup is interrupted, e.g. if the server is rebooted after updates, the site will stay in read-only mode.

To unlock the site use the following command:

Set-SPSite -Identity http://mysite -LockState “Unlock”

Other possible states are: NoAdditions, ReadOnly, NoAccess.

Update Rollup 21 for Microsoft Dynamics CRM 4.0

March 2, 2012

The Microsoft Dynamics CRM Sustained Engineering (SE) team released Microsoft Dynamics CRM 4.0 Update Rollup 21 on Thursday, February 9, 2012.

The links below will take you to the necessary information about Update Rollup 21.

General details about Update Rollup 21

  • Update Rollup 21 is cumulative.  However, the Update Rollup 21 CRM Client and Data Migration Client packages require Update Rollup 7 to be installed.  For all other CRM components, you do not need to install any previous Update Rollups prior to Update Rollup 21.
  • The Update Rollup 21 download contains updates for the 40 supported Language Packs.  Prior to installing the Update Rollup 21 Language Pack, you must install the original Language Pack.
    • If you have Language Packs installed, you should
      1. Download the Update Rollup 21 Language Pack
      2. Install the Update Rollup 21 Language Pack
      3. De-provision the Language Pack
      4. Re-provision the Language Pack
  • Information about how to avoid reboots when installing the CRM Outlook Client can be found in the Update Rollup 4 blog posting.
  • The Update Rollup 21 Client can be deployed before the server is upgraded to Update Rollup 21.
  • Steps to make the Update Rollup 21 Client available via AutoUpdate can be found in the Update Rollup 4 blog posting.  The Link and Patch IDs can be found in KB article 2550098.
  • Each update rollup could have fixes that require manual configuration.  Please see the “Hotfixes and updates that you have to enable or configure manually” section in KB article 2621054.

Office 365 for Enterprise Service Descriptions

March 1, 2012

Office 365 is a suite of Internet-based services that are designed to help meet your needs for robust security, 24/7 reliability, and user productivity. This set of documents provides service descriptions for the components of the suite.

Microsoft Exchange Online for Enterprises Service Description – Microsoft® Exchange Online is a hosted messaging solution that delivers the capabilities of Microsoft Exchange Server as a cloud-based service. It gives users rich and familiar access to email, calendar, contacts, and tasks across PCs, the web, and mobile devices.

Microsoft SharePoint Online for Enterprises Service Description – Microsoft SharePoint Online is a Microsoft Office 365 service for businesses of all sizes. Instead of installing and deploying Microsoft SharePoint Server on-premises, any business can now simply subscribe to SharePoint Online to provide their employees with an enterprise grade solution for creating sites to share documents and information with colleagues and customers.

Microsoft Lync Online for Enterprises Service Description – Microsoft® Lync™ Online is a next-generation cloud communications service that connects people in new ways, anytime, from virtually anywhere. Lync Online provides intuitive communications capabilities across presence, instant messaging, audio/video calling and a rich online meeting experience including PC-audio, video and web conferencing. Transform your interactions with colleagues, customers and partners from today’s hit-and-miss communication to a more collaborative, engaging, and effective experience.

Microsoft Office Professional Plus Service Description – With Office Professional Plus, users get the latest version of the Microsoft Office applications, seamlessly connected and delivered with cloud services, so they can access their documents, email, and calendars from virtually any device. Office Professional Plus includes the new Office Web Apps—online companions to Microsoft Word, Microsoft Excel®, Microsoft PowerPoint®, and Microsoft OneNote®—which let users review and make minor edits to documents directly from a browser.

Microsoft Office 365 Apple Devices Service Description – The Microsoft Office 365 Apple Devices Service Description provides customers with an overview of Office 365 capabilities on the Mac and iOS (iPhone and iPad) devices.

Microsoft Exchange Online Archiving Service Description – Microsoft Exchange Online Archiving is a cloud-based archiving solution for organizations that have deployed Microsoft Exchange Server 2010 on-premises. Exchange Online Archiving is an enterprise-class service that assists these organizations with their archiving, compliance, regulatory, and e-discovery challenges while simplifying their on-premises infrastructure, thereby saving costs and easing the information technology (IT) burden.

Microsoft Office 365 for Enterprises Support Service Description – Microsoft® Office 365 for enterprises Support Service Description provides information to customers about the technical and nontechnical support included in their subscription fee to Microsoft Office 365 for enterprises.

Microsoft Office 365 Mobility Services Description – The Microsoft Office 365 Mobility Services Description provides customers with information on mobility solutions—access to services from phones and devices—that are available for two online services in this current release namely, Microsoft Exchange Online and Microsoft SharePoint® Online.

Microsoft Office Web Apps Service Description – Microsoft® Office Web Apps is the online companion to Microsoft Word, Microsoft Excel®, Microsoft PowerPoint®, and Microsoft OneNote® applications that helps users access documents from almost anywhere. Users can view, share, and work on documents online with other users across personal computers, mobile devices, and the web.

Office 365 Security and Service Continuity Service Description – This service description describes the security, continuity, privacy, and compliance policies and controls for the Office 365 for enterprises service offerings. It is intended to provide Office 365 customers with an overview of how each of the Office 365 services is designed to provide a high degree of security, privacy, continuity, and compliance—service goals that are derived from the Microsoft Risk Management program.

Office 365 Identity Service Description – This document discusses the design, policies, and best practices related to Office 365 identity, including the creation of user accounts, password policy, co-existence, directory synchronization, and single sign-on ( identity federation). Users can gain access to Office 365 by authenticating to their Office 365 user accounts—either through a prompt to provide valid credentials or through a single sign-on process. Once authenticated, users’ identities refer to the user names associated with the Office 365 accounts.