generic drill down error when data contains a single quote
Posted: Tue Sep 16, 2014 7:06 pm
Has anyone run into the generic drill down error when the data contains a single quote? This is coming from IA 8.7.0.0 (no fix packs) on AIX via ODBC data source (SQL Server), Format tab, General Format A'AAAA, such as a name. The names display fine in the Distinct Values pane. Click Drill Down gives an error within a couple of seconds.
The generic error text is, "No results are available at this time due to one of the following reasons: either the data or the table is no longer in the database, a source database connection issue exists, or the Agent is not running. Verify that the data or table exists in the database; check your source database connection or configuration; and confirm that the Agent is running."
Drilling down on the same table and column via a format that does not contain a single quote, such as AAAA, works just fine.
I have checked in the SystemOut.log and other recently updated log files in the area at the time of the error and not found any signs of errors in any log files.
The generic error text is, "No results are available at this time due to one of the following reasons: either the data or the table is no longer in the database, a source database connection issue exists, or the Agent is not running. Verify that the data or table exists in the database; check your source database connection or configuration; and confirm that the Agent is running."
Drilling down on the same table and column via a format that does not contain a single quote, such as AAAA, works just fine.
I have checked in the SystemOut.log and other recently updated log files in the area at the time of the error and not found any signs of errors in any log files.