Monday, June 13, 2011

How to use Sharepoint Cmdlets in powershell

To use the powershell commandlets in sharepoint 2010 one needs to add the ps snapin  Microsoft.SharePoint.PowerShell which can be done using the following command on windows powershell


Add-PSSnapin Microsoft.SharePoint.PowerShell.

Njoi 
~Abhishek

Wednesday, June 8, 2011

CRM 2011 :- Error while Scheduling a report to run

I tried scheduling a report to run on a daily basis and store the snapshots for the user in the CRM 2011 system. Doing this was simple as i selected the report in the reports view and did the scheduling. 
However the report snapshots were not getting displayed at all and every time i tried to open the snapshot it gave an error saying "The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"


The culprit was the fact that Snapshot isolation was turned on in my reportserver database. To get rid of this error and to allow the snapshots to be running properly i executed the following query on my reportserver databse and i was good to go...


"ALTER DATABASE ReportServer
    SET ALLOW_SNAPSHOT_ISOLATION OFF;"


Hope this helps in case you are stuck while trying to schedule the reports in your CRM installation. 


~Abhishek