Generate List for Ticket System does not work (4274225)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Generate List for Ticket System does not work
Description

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)
Cause

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

Database.dbo.TableName
Resolution

Instead of

Select * from TableName

Please use

Select * from Database.dbo.TableName

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title