Generate List for Ticket System does not work (4274225)

Generate List for Ticket System does not work

Generate List reports the following error.

An error occured while testing the Ticket System. The results are: [mm/dd/yyyy hh:mm:ss] Executing Ticket System SQL Statement: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name \'TableName\'. (SQL-42S02) [state was 42S02 now 42000][Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)

The SQL query needs to be updated to specify the database name in the following format 

Database.dbo.TableName

Instead of

Select * from TableName

Please use

Select * from Database.dbo.TableName