This is a pretty common error which can be caused by a large number of reasons. I received the below error: GenericADOExcpetion could not execute query [ select ] [SQL: select ] While I was implemented the TrueFalse NHibernate data type. What I did was in my class file (class.cs) I rightly created the property […]
Read More →Archive for September, 2013
Nhibernate GenericADOException could not execute query
During the mapping process or after a data model change you may receive this error. The error message being: {“could not execute query\r\n[ select from TABLE ]”} with an inner exception of {“Ungültiger Spaltenname ‘SPALTEN NAME’.”} {“Invalid column name ‘COLUMN NAME’.”} I received this error when I was creating a many-to-one relationship between 2 classes, […]
Read More →Using Procdump and Failed Request Tracing to capture a memory dump
One of my favorite tools for troubleshooting Internet Information Service issues is ProcDump. It is a single, small, yet powerful EXE that is very useful for capturing W3WP.exe process memory dumps. One of my other favorites is Failed Request Tracing which I have written about here and here for a Windows Azure Web Site. Failed […]
Read More →Scaling your Microsoft Azure App Service Web App
Having spent many years supporting web sites running on IIS one of the most challenging aspects was managing load. I was able to plan for near-term growth by tracking the CPU, Memory, total number of requests, etc… over time and once the utilization of these elements exceeded my threshold for what I considered manageable, it […]
Read More →Download Azure App Services Web App log files from Visual Studio
I wrote an article about the ability to enable Web Server Logging, Detailed Error Message, Failed Request Tracing and Application Logging here. In that article I discussed that you can download the logs using an FTP tool like FileZilla. You can also download the log files from within Visual Studio by performing the following. I […]
Read More →500.19 when setting up WebDAV on a UNC File share
I have written some instruction on how I setup a WebDAV installation that uses Windows Authentication and UNC here. An important concept to understand before you start setting up a WebDAV solution using this configuration is the difference in behavior when you are logged on and testing from the IIS server versus testing from a […]
Read More →404 File or directory not found when mapping custom domain to an Azure App Service, Server Error
If you are receiving a 404 error while accessing your custom domain, as shown in Figure 1, then you are most likely missing the link between your Azure App Service Web App configuration and your custom domain. Figure 1, 404 File or directory not found when mapping custom domain Before we move to the solution, […]
Read More →Stopping and starting an FTP site in IIS 7.5+ from script with ADSI
There have been many changes over the years with managing the IIS configuration using scripting. In IIS 6 using WMI which relies on the ADSI model is the recommended approach. However, with the introduction of IIS 7.5 and now IIS 8 there is a new way of doing things. This new way is via the […]
Read More →Enable logging on your Windows Azure Web App – App Service from Visual Studio
With the release of Windows Azure SDK 2.0, you can enable the logging from within Visual Studio. I wrote another article which discussed how to enable Failed Request Tracing while logged into the Microsoft Azure Management console. You can review that article here. After installing the SDK, open Visual Studio and example the Server Explorer, […]
Read More →Enable CAPI2 event logging to troubleshoot PKI and SSL Certificate Issues
The CryptoAPI 2.0 Diagnostics is a feature available on Windows Server 2008+ that supports the trouble shooting of issues concerned with, for example: Certificate Chain Validation Certificate Store Operations Signature Verification This article describes how to enable the CAPI2 Diagnostic, but for an in depth review of the capability, check here. Enable CAPI2 logging by […]
Read More →