the web front-end for your database

Troubleshooting Guide

Murphy's law applies everwhere including to dbFront.  Because of this we built in fairly accessibly logging and diagnostics.

Logging

If you log in as an admin user the bottom of every screen will contain a small area that provides some basic information about how dbFront is running.  Included is the name and location of the current logfile and how many errors are currently written or waiting to be written.

Changing the Logging Location

Both the web.config for the dbFrontUI and the config file for the dbFrontService contain a key named LogPath which can be used to specify the folder where they will create their log files.

You should never set dbFrontUI and dbFrontService to log to the same location.  This will cause conflicts.

The logging location should also not be to a network location because this will affect the application performance.

dbFrontUI Logging

The logfile for the dbFrontUI Web Application should generally be empty except for a single line indicating that all Log requests are normally sent to the dbFrontService.   The only time that the dbFrontUI logfile should contain any messages is if it can't contact the dbFrontService.

If the dbFrontUI can't talk to the dbFrontService then the specific issues might be:

  • The dbFrontService is not running.
  • The server name or port used are incorrect.   The logfile for the Service and the UI should both indicate the port they are using.
  • A firewall on the application server is blocking the incoming requests.
  • A firewall on the Web server is blocking the outgoing request.
  • Something about the network such as a firewall or router is preventing or blocking the communication.

dbFrontService Logging

Service Logs

The dbFrontService renumbers the existing logfiles and creates a new logfile everytime it starts.  The logfile with the lowest number is the most current logfile.  The benefit of this is that you can continue to watch logfile 000 and know that it is always the most current logfile.

If you run into an unusual situation we may ask you to add the following setting to your dbFrontService.exe.config file.   That will increase the level of information saved into your logfile.

<appSettings>
   ...
   <!-- Enables extra "Debug" logging -->
   <add key="Debug" value="true" />
   <!-- Requires "Debug" to be enabled, Logs extra security information -->

   <add key="DebugSecurity" value="true" />
   <!-- Requires "Debug" to be enabled, Logs all SQL statements -->
   <add key="DebugSQL" value="true" />
</appSettings>

The Debug flags can be enabled without restarting dbFront.

Warning: You should disable the extra Debug logging once the problem is resolved because it may cause performance issues.

Security Logs

Security Logs are given date based names and a new logfile will automatically be started the first time a new security event occurs for a day.

Security Logs are not automatically purged.

Getting Help

Once you have a specific log message or error message then you can look in the Knowledge Base or the Questions & Answers site.  We ask that you search our Knowledge Base and check out the Questions & Answers site before sending a specific support request.  Using these two resources first means that you will likely get your answer faster because your problem is unlikely to be unique to you.

If you still can't find the answer you need and you think that others might benefit from the question then please create a new question in the Questions & Answers site.  We will do our best to answer the questions there.

If you prefer more individual help or you think you have found a bug then feel free to submit a support request and we will be happy to respond.

Content you want the user to see goes here.
close