From time to time, an SQL error may be raised by WhereScape RED. These are usually caused by the data warehouse database returning an error. There are many causes of database error messages being returned to RED. The most common causes include permission issues and invalid SQL statements being run. To find the exact SQL statement run by WhereScape RED, go to the View menu and select Last SQL.
The following window is displayed:
The four fields shown are:
- The last SQL statement run
- The second to last SQL statement run
- The third to last SQL statement run
- The error message (if any) from the last SQL statement