SYMPTOM
In Strategy 10.4 Hotfix 3, the following error appeared when publishing a cube against a Teradata database that contains a table with a special character such as # or $:
Unable to publish the cube. Details
We could not obtain the data because the database connection or warehouse table is changed. Encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42S22:-3810: on SQLHANDLE] [Teradata][ODBC Teradata Driver][Teradata Database] Column/Parameter 'xxxxxx.xxxxxx.Column##' does not exist
CAUSE
This is an identified defect in version 10.4 Hotfix 3 and Hotfix 4
ACTION
This issue has been addressed in 10.4 Hotfix 5 as well as 10.9.
Upgrade to this version to take advantage of this fix. 439443 KB439443
