Also, make sure the correct ver of the SQL client is installed on your app catalog role server. I've had similar issues in the past where someone updated the SQL client and broke communication to the ConfigMgr SQL instance.
-Stephen > On Jun 18, 2015, at 10:24 AM, Atkinson, Matt T <[email protected]> > wrote: > > 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]] > On Behalf Of Mawdsley R. > Sent: Thursday, June 18, 2015 6:47 AM > To: [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]] > On Behalf Of Daniel Ratliff > Sent: 18 June 2015 14:40 > To: [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]] > On Behalf Of Mawdsley R. > Sent: Thursday, June 18, 2015 9:30 AM > To: [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. > > <image001.jpg> > > > > 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. >
