Error launching Report Builder from MOSS 2007

SQL Server 2008 R2 with SP1 on Windows Server 2008
SharePoint 2007 (Dec 09 CU) on Windows Server 2003

"Edit in Report Builder" sends the the browser to

"/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderReportContext&list={E048CF36-3F8C-4333-A429-21907A15022D}&ID=1"

which redirects to

"/_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application?ReportPath=SITE/Report1.rdl"

Now the type "Microsoft.ReportingServices.SharePoint.Soap.RSProxyHttpHandler" takes over the request (see httpHandlers section in web.config for WSS virtual directory)
and should send the manifest to the browser from the SSRS server.

This didn´t happen in our environment.
So we reinstalled the SP2 on the SSRS and it solved this problem.

Things to remember:
* The files in "\ISPAI\ReportBuilder" are not the same on MOSS and SSRS.
* "/_vti_bin/ReportServer" have a custom httpHandler definied in web.config.
* Fiddler helps, but only to a certain point.
* Make sure to run the Add-in installation as a Farm administrator.

XML definition for ContentType

If one don´t include the FieldRef for a column in the FieldRefs collection of the ContentType (for the schema.xml in the List Instance) then the field is not available in the SPContext.Current.Fields collection.

Decrypting error in multi-forest environment

In the ULS for a SharePoint 2010 Server after a trust between two domains has been re-configured: Decryption failed with error 0:" (and the rest of the callstack) Solution: stsadm -o setapppassword -password "SomeString" (on all WFE:s) stsadm -o setproperty -pn peoplepicker-searchadforests -pv "ForestDomainUserString" No IISResets needed.

Update-SPProfilePhotoStore and Service Application permission

Running Update-SPProfilePhotoStore -CreateThumbnailsForImportedPhotos 1 -MySiteHostLocation https:///my based on User Profiles – Picture Property in SharePoint 2010.

This command requires Full Control on the "User Profile Application" service application (Use the Permissions tab on the Manage Servcie Applications page).

Solving ‘Configuring certificate’ hang for User Profile Synchronization Service.

The quick explanation:

1. If you re-provision the UPA service and encounter an error while creating the certificate, check this blog post by Paul Culmsee: More User Profile Sync issues in SP2010: Certificate Provisioning Fun.

2. If you delete the certificate in Trusted Root Certification Authorities and still are stuck on ‘Starting’ you also need to delete the certificate “higher up” in the certificate chain at Personal –> “ForefrontIdentityManager”.

A few good pointers:

Start to put the User Profile ULS category to Verbose, then read this blogpost by the SharePoint Escalation Team. Compare the ULS log entries you got with the blogpost, it´ll show where in the process the provisioning fails.

To unprovision the service run the powershell command: Stop-SPServiceInstance –Identity ‘'GUID’

Get the GUID by “Get-SPServiceInstance”, if you have more than one SP server in the farm you have two instances of the service name ‘User Profile Synchronization’, the one which is active has the status “Provisioning”. You might also need to delete the “UserProfileSyncronizationSetup” job before the unprovisioning can start.

In my case I could disregard these error messages in the ULS logs:

ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service. ILM Configuration: Error 'ERR_SERVICE_NOT_INSTALLED' ILMPostSetupConfiguration: ILM Configuration: Validating installation of SQL Service FAILED

Update: Another case required the removal of all subfolders in the MaData folder. I had alot of errrors regarding MS DTC before the removal