We are getting an error message back from our WSDL calls "the operation has timeout". It seems to be occuring when LC trys to authorize the wsdl access to the server. It is believed that the number of connections to the LC internal database is hitting it's max. If the server is restarted, then the issue is resolved for a time.
Are there any know issues with SQL and LC transactions? What are some steps to debug this issue?
Issue is in web service. Web service creates a connection to database for fetching the data that needs to be close after completion. I think that part is missing that's why you are getting issue when number of connection reached to maximum limit. Once you restart the server all the connection gets closed and your application starts working.