Month: September 2015

Terminal server has exceeded maximum number of allowed connection – how to kill open sessions?

When you RDC (connecting remotely using Remote Desktop Connection) to a server and get “Terminal server has exceeded maximum number of allowed connection” message there’s still light at the end of the tunnel.

Solution (tested on Windows 2003)

RDC to another server in the same workgroup as the one you cannot access and go to Administrative Tools / Terminal Services

Reporting Services – deploying RDL files

In this post I’ll describe how to deploy RDL files using Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress).
Note: This description applies to the situation where Microsoft SQL Server is used.

  1. Go to Report Manager
  2. Too keep all clean, you can create a folder in which you will keep all your reports
  3. Create the data source, if not yet

System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

One of my applications was supposed to use image having its URL. The Image was instantiated with the stream the server that stored the image file responded with after being requested as below:

// create a request for image
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(IMAGE_URL);
request.Method = "GET";
request.ContentType = "multipart/form-data";
request.UserAgent = "Mozilla/4.0+(compatible;+MSIE+5.01;+Windows+NT+5.0";
request.Proxy.Credentials = CredentialCache.DefaultCredentials;
request.Credentials = CredentialCache.DefaultCredentials;

// get 

Exception – ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed

In my application data were collected from database (Oracle) using web services that called stored procedures. One of the stored procedure had SELECT defined similar to the one below:

WITH sth1 as 
(
        SELECT ...
),
sth2 as 
(
        SELECT ...
)
SELECT ...

This construction was the reason why in my application I was getting the following exception while …

How to wait until AJAX call completes in Selenium tests

If you introduce AJAX to the application that is web tested with Selenium your tests might fail from time to time. In my case the tests were failing randomly, not that often but it made their quality decreased. So, how can you fix this?

Solution

Ideally, what you need is to stop the test execution (e.g. do not perform checks …