Fetch optimize teradata odbc teradata driver unable to get catalog string

Go to the ODBC control panel on the Windows server. Select the Teradata DSN.. Click Configure. Click Options. Change the DateTime Format list to . A session reading from a Teradata table fails with following error logged in session log: READER_1_1_1 RR_ SQL Error [FnName: Fetch Optimize -- [Teradata][ODBC Teradata Driver] Invalid date/time/timestamp value. Following is from the ODBC trace: EXIT SQLError with return code 0 (SQL_SUCCESS) HENV 0x FnName: Fetch Optimize -- [Teradata][ODBC Teradata Driver] Illegal data conversion FnName: Fetch Optimize -- [Teradata][ODBC Teradata Driver] Character string truncated In PowerCenter Designer, the mapping along with the data types appears as follows.

FnName: Fetch Optimize -- [Teradata][ODBC Teradata Driver] Unable to get catalog string. We have been trying to figure out for quite sometime by changing the connection strings and port order but we still failed. - Improper column reference in the search condition of a joined table. - Teradata Database Teradata Database Messages Product Teradata Database Release Number Content Type Programming Reference Publication ID BK Language English (United States) Teradata Database Messages; %VSTR. %VSTR. %VSTR. %VSTR. FnName: Fetch Optimize -- [Teradata][ODBC Teradata Driver] Unable to get catalog string. This issue could occur if the relevant spool space on Teradata database server is insufficient to read the data.

(Teradata related) Errors when using the 'mod' function in a compatible mode Cognos 10 project: RQP-DEF An error occurred while. Error in File ~tmp rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: ] Failed to retrieve data from the database. I am facing issue while connecting to teradata db using dbc file. Message [Teradata] [ODBC Teradata Driver]:Unable to get catalog.