Unable to retrieve configuration settings - sub site & Ratings

May 26, 2009 at 8:05 PM

I have PKS installed in a SharePoint sub site and am getting a popup error "Unable to retrieve configuration settings"  when going to a podcastdetail.aspx page or the PKS Podcasts list.  Everything is working on the site except for ratings and comments.  Download counts are working so I know the application is able to reach the RatingStore database.  I am seeing screens very similar to this where on the home page, the stars are greyed out and on the detail page there are no ratings or comments.  I've verified the settings in the PKS Configuration Settings and PKS Media Encoder Monitor Locations lists per the documentation.  I've verified the permissions for the AppPool and the dbo (which are the same acct) and rights to the Upload Folder. 

We initially had the PKS March 2009 release installed and had the same problem.  In trying to fix this, I upgraded to the April 2009 release.  Still no fix.  Everything else works but still the same issue with the ratings and comments.  I've also re-verified all the pre-req's, the features are activated, and the values in the Content Rating Configuration Settings.

 Here is some information from the SharePoint logs:

05/26/2009 11:15:24.98  w3wp.exe (0x0E00)                        0x1BE0 Windows SharePoint Services    General                        0 Unexpected ERROR: request not found in the TrackedRequests. We might be creating and closing webs on different threads. ThreadId = 1, Free call stack =    at Microsoft.SharePoint.SPRequestManager.Release(SPRequest request)     at Microsoft.SharePoint.SPWeb.Invalidate()     at Microsoft.SharePoint.SPWeb.Close()     at Microsoft.SharePoint.SPWeb.Dispose()     at Microsoft.MSIT.Ratings.Configuration.ConfigurationManager.GetConfigurationList(SPSite site, String listName)     at Microsoft.MSIT.Ratings.Configuration.ConfigurationManager.GetConfigurationBeginWith(SPSite site, String listName, String configurationName, String value, Boolean beginWith)     at Microsoft.MSIT.Ratings.Configuration.ConfigurationManager.GetConfiguration(SPSite site, String listName, String configurationName)     at Microsoft.MSIT... 

05/26/2009 11:15:24.98* w3wp.exe (0x0E00)                        0x1BE0 Windows SharePoint Services    General                        0 Unexpected ....Ratings.Web.WebService.Utility.<>c__DisplayClass1.<get_ConfigCacheTimeout>b__0()     at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)     at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()     at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)     at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)     at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)     at Microsoft.MSIT.Ratings.Web.WebService.Utility.get_ConfigCacheTimeout()     at Microsoft.MSIT.Ratings.Web.WebService.EntityConfigs.GetConfigurationXml(String configurationName, String webId)     at Microsoft.MSIT.Ratings.Web.WebService.EntityConf... 


05/26/2009 11:15:24.98* w3wp.exe (0x0E00)                        0x1BE0 Windows SharePoint Services    General                        0 Unexpected ...igs.GetConfigXml(String configurationId, Boolean isListId)     at Microsoft.MSIT.Ratings.Web.WebService.EntityConfigs.ProcessGetRequest()     at Microsoft.MSIT.Ratings.Web.WebService.Entity.Process()     at Microsoft.MSIT.Ratings.Web.WebService.HttpHandler.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)     at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest... 

Here is the error from the event log:

Event Type: Error
Event Source: SPP Ratings
Event Category: None
Event ID: 0
Date:  5/26/2009
Time:  3:40:32 PM
User:  N/A
Computer: XXXXXX
Description:
Unable to retrieve configuration settings. Error msg: The given key was not present in the dictionary.  Stack trace:    at System.ThrowHelper.ThrowKeyNotFoundException()
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at Microsoft.MSIT.Ratings.Web.WebService.Utility.<>c__DisplayClass1.<get_ConfigCacheTimeout>b__0()
   at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
   at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
   at Microsoft.MSIT.Ratings.Web.WebService.Utility.get_ConfigCacheTimeout()
   at Microsoft.MSIT.Ratings.Web.WebService.EntityConfigs.GetConfigurationXml(String configurationName, String webId)
   at Microsoft.MSIT.Ratings.Web.WebService.EntityConfigs.GetConfigXml(String configurationId, Boolean isListId)
   at Microsoft.MSIT.Ratings.Web.WebService.EntityConfigs.ProcessGetRequest()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any information about where to look next or how to fix this issue would be greatly appreciated.

Jun 5, 2009 at 10:50 AM

Hi Pdavis,

You can try the following steps to correct your problem:

1. In your PKS website, open the custom list Content Rating Configuration Settings.
2. Update the key "RaterSkin" with the value dark.htm. Please ensure that the dark.htm file is present in folder Content Rating->Skins->Raters. It is easier to update this key using the datasheet view.

Also ensure that the following are configured on your site:
1. The following entry is present under the HttpHandler section of the web.config(of PKS Site):
<add path="*.Ratings/*,*.Ratings/*/*,*.Ratings/*/*/*,*.Ratings/*/*/*/*,*.Ratings/*/*/*/*/*,*.Ratings/*/*/*/*/*/*" type="Microsoft.MSIT.Ratings.Web.WebService.HttpHandler,Microsoft.MSIT.Ratings.Web, Version=1.0.0.0,  Culture=neutral,PublicKeyToken=039e36666027bfc6" verb="*" />
2. Go to Central Administration > Operations > Manage Farm Features and activate the ContentRatingFeatureFarm in case it is not activated.
3. Click “View All Site Content” on the top of the left hand menu
4. Open the “Content Rating Store Configuration Settings” list
5. Edit the connectionString key and update the Data Source entry to point to your SQL Server installation ( if database  servername is not provided)
 a. Example: Data Source=<database-servername>;Initial Catalog=RatingStore;Integrated Security=SSPI;

Hope this helps.

Regards,

Parag

Jun 10, 2009 at 12:35 PM

All these steps were checked and double checked but did not make any difference.  Here is something interesting we found when we did some process monitoring (see log output below).  We were wondering if the files in the layouts directory could be missing or is this just virtual?  We have a RatingMSIT folder but no service.ratings folder. Are we missing some code somewhere?  Again, your thoughts and recommendations would be appreciated.

3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch\_layouts PATH NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch NAME NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch\_layouts\service.ratings PATH NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch NAME NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch\_layouts\service.ratings\config PATH NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch NAME NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch\_layouts\service.ratings\config\@defaultsettings$ PATH NOT FOUND
3532 QueryOpen C:\Inetpub\wwwroot\wss\VirtualDirectories\81\watch NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\service.ratings\config PATH NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\service.ratings\config\@defaultsettings$ PATH NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\service.ratings\config PATH NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\template\layouts\service.ratings\config\@defaultsettings$ PATH NOT FOUND
3532 QueryOpen C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\service.ratings NAME NOT FOUND
Jun 15, 2009 at 2:02 PM

Here's the fix to this problem:

In the Content Rating Store Configuration Settings in Central Admin, change the Key ConfigCacheTimeout to all lower case configcachetimeout

Thank you Microsoft local resource RB who helped me install some debugging tools on our server and figure this out.

Jul 6, 2009 at 9:36 PM

We had a similar issue, but only with the comments not displaying (ratings and number of comments displayed fine).  It turned out to be a problem with http versus https.  We're using https.  There are two places in the Microsoft.MSIT.Ratings code where we found code that was hard-coded to check for a URL starting with "http://".  Since our URL started with "https://" some of the code wasn't being hit.

After some custom changes to the code, we got it working.