When trying to access the software catalog in CM12 SCCM 2012 In the ServicePortalWebSite.log
[31, PID:6916][07/25/2013 08:19:25] :ApplicationViewService.asmx - GetApplications with startItem = 0, search text = '' returned successfully [37, PID:6916][07/25/2013 08:19:36] :Web service call timed out - System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:59.9990007. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. [37, PID:6916][07/25/2013 08:19:36] :System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:59.9990007. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. In the ServicePortalWebService.log log [85, PID:6792][07/25/2013 15:31:39] :ApplicationOfferService - (domain\user) GetApplicationValuesForProperty call [87, PID:6792][07/25/2013 15:31:40] :ApplicationOfferService - (domain\user) GetApplications call [85, PID:6792][07/25/2013 15:32:39] :Failed to execute the DB procedure get the application values for a property The SP call in trace looks like this exec [dbo].[usp_GetApplicationPropertyValues] @User=N'<user sid>', @UserGroupSids=N'<all group sids>', @CategorizedByColumnID=5, @LocaleID=1033 Open usp_GetApplicationPropertyValues and change this LEFT JOIN HiddenAppFlags f on Apps.CI_ID=f.ToAppCIID WHERE f.fromAppCIID IS NULL to this LEFT JOIN HiddenAppFlags f on Apps.CI_ID=f.ToAppCIID AND f.fromAppCIID Is NULL --WHERE f.fromAppCIID IS NULL One of my coworkers figured this out, not me. It took the sp execution time from ~7 minutes down to less than a ms we can change it back and the time goes back to over 7 minutes. MS filed a bug. Case number is 113072510618009 if anyone needs to reference it. We are waiting for confirmation from the product team that it is ok to run like this until they can fix it. /Todd
