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

Stunnware Fetch Xml Doesn't show the attribute of an entity

If you use the Fetch Xml Wizard from Stunnware sometimes you may face an issue where the Wizard doesn't show one of the attributes which you added to an entity in the Attribute Picker. This happened to me recently and when i did a little investigation i figured out that the Wizard maintains a offline metadata cache for your organization in "%localappdata%\Stunnware\Stunnware Tools Metadata Cache" folder to improve performance.
Now sometimes the cache doesn't get refreshed after you make a change in the CRM metadata on the server. To fix this you need to exit the stunnware tools wizard and delete the folder from the path "%localappdata%\Stunnware\Stunnware Tools Metadata Cache" and boom you'd see your changes being reflected on the wizard.

Njoi!!!!

~Abhishek