Hi Morgan, Thanks for the info, I had seen these options previously so will look into them and see if it resolves the issue, as it certainly looks like it might be something like that.
I have since found, that completely restarting the SQL server sometimes fixes the issue. I say sometimes because it doesn't always work. And when it does, it may be for an hour, or a day, then it will break again. Rich From: [email protected] [mailto:[email protected]] On Behalf Of Morgan Little Sent: 19 June 2015 19:10 To: [email protected] Subject: [mssms] RE: Application Catalog Not Loading Hello all, We recently had the same issue and found that it was due to the number of connections into the application catalog. If you look at the Web.config file for the CMApplicationCatalogSVC, you can see at the bottom scaling recommendations for Maxconcurrentcalls, maxconcurrentsessions, and maxconcurrentinstances based on processor. Increasing those values per the number of processors we have allocated resolved the issues. Hope this helps. Morgan From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Atkinson, Matt T Sent: Thursday, June 18, 2015 11:21 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Application Catalog Not Loading Found this similar problem on the TechNet forums: https://social.technet.microsoft.com/Forums/en-US/7f158f00-0ed0-4b6a-aea8-c53e0e4e0d66/application-catalog-cannot-connect-to-the-application-server-sql-related?forum=configmanagergeneral Unfortunately no detailed answer, but it does point to SQL permissions. Can you check the log files on your SQL server to see if there is anything obvious? I'm not even certain you would see anything there, but you've tried all the other stuff that I can think of ;) From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Mawdsley R. Sent: Thursday, June 18, 2015 6:47 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Application Catalog Not Loading Yes it does, But this is on every client, and we've tried it on two separate servers now. It just stopped working! :( Rich From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: 18 June 2015 14:40 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Application Catalog Not Loading I think the App Catalog relies on Silverlight? Might reinstall, or roll back to an older version if it was recently upgraded? Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Mawdsley R. Sent: Thursday, June 18, 2015 9:30 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Application Catalog Not Loading Afternoon Chaps, Had a very strange problem arise.. Our Application Catalog will not open. It sits on loading like this, and then error's out. [cid:[email protected]] [cid:[email protected]] So far I've tried: * Restarting everything. Literally. Services, IIS, Servers * Reinstalled IIS and App Catalog Roles * Installed App Catalog Roles on a different server * Tried with just HTTP as a pose to HTTPS * Increased timeouts in web.config files * Recreated Certificates Below is the errors from the ServicePortalWebService.log "[16, PID:4024][06/18/2015 14:20:00] :SCCMServiceCertificateValidator - Validating certificate D4E8D22DE0D70FA82FD2FD5E464075AD464F53C4 [17, PID:4024][06/18/2015 14:20:00] :ApplicationOfferService - (mydomain\myusername) GetApplications call [24, PID:4024][06/18/2015 14:20:03] :Failed to execute the DB procedure get the application values for a property [24, PID:4024][06/18/2015 14:20:03] :User = S-1-5-21-2015846570-11164191-355810188-112065 [24, PID:4024][06/18/2015 14:20:03] :System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at Microsoft.ConfigurationManager.SoftwareCatalog.Service.SqlDatabase.ExecuteReader(DbCommand command) at Microsoft.ConfigurationManager.SoftwareCatalog.Service.ApplicationHandler.GetApplicationValuesForProperty(UserContext userContext, ApplicationProperty property, Platforms platformFilter) at Microsoft.ConfigurationManager.SoftwareCatalog.Service.ApplicationOfferService.GetApplicationValuesForProperty(UserContext userContext, ApplicationProperty propertyName, Platforms platformfilter, String reserved) [24, PID:4024][06/18/2015 14:20:03] :An exception has been thrown from the service: System.ServiceModel.FaultException`1[[Microsoft.ConfigurationManager.SoftwareCatalog.Service.ServiceError, Microsoft.ConfigurationManager.SoftwareCatalog.Service.ApplicationOfferContract, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Internal Server Error at Microsoft.ConfigurationManager.SoftwareCatalog.Service.ApplicationOfferService.GetApplicationValuesForProperty(UserContext userContext, ApplicationProperty propertyName, Platforms platformfilter, String reserved)" Other Notes: Interestingly, when its sat at "loading" which it does for around a minute, you can click on install and it will install the select application. Any help would be great. We're clutching at straws now! Thankyou Rich The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. * * * * * * * * * * * NOTICE: This e-mail and any attachments contain confidential information that may be legally privileged. If you are not the intended recipient, you must not review, retransmit, print, copy, use or disseminate it. Please immediately notify us by return e-mail and delete it. If this e-mail contains a forwarded e-mail or is a reply to a prior email, the contents may not have been produced by the sender and therefore we are not responsible for its contents. This notice is automatically appended to each e-mail. It is the recipient's responsibility to take measures to ensure that this e-mail is virus free, and no responsibility is accepted by Greystone for any loss or damage arising in any way from its use. * * * * * * * * * * *
