SQL Error in Beas lists, reports, browser

Q: I've sql error in Beas list- or Beas report views

A: Reason can be a template

If customer have sql error in default reports from one day to other or after Beas update and you can't reproduce this, then the reason is in most of cases a wrong template definition

You can have errors, example
Syntax error or access violation;257 sql syntax error: incorrect syntax near ")

Check in simple way:

1. Open this window
2. Left click on icon on bottom right side
3. Choose "Default"

If not working

1. Open the debug window Level 2

2. Open the window, which produce the sql error
3. Check generate HTML File

In this example Beas display the userfield and the name of template
If the value not a correct sql statement, then the template not working correct.

More see documentation - templates