·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:



Create or Find Page:


View Dispatcher Column Headings are Red

Category:HWeb Dispatcher

Dispatcher column headers all turn red

Usually indicates an invalid SQL Query command.

If database is MS Access (legacy versions only)  try to Repair Access Table. Then repeat process that caused error, but with DEBUG enabled in log trace settings. Copy the entire SQL query from the log into Access, then run the query in Access.

If database is MS SQL Server, then check for correct SQL query syntax in any Custom Filters that exist.  Also, open Grid Properties, and review all filters for possible errors or conflicts. Examine any inner joins and the field names specified on the SQL Tab.