Troubleshooting
Problem
Using DQM(Danymic Query Mode, JDBC) connect to Teradata database to run a report, if the query item or subject contains Non-English characters, report will fail with error: QE-DAT-0001 Data source adapter error
Symptom
The following error appears when running report
XQE-DAT-0001 Data source adapter error: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.00.00.14] [Error 3697] [SQLState HY000] Attempt to translate Unicode/Graphic/KanjiSJIS data to another form has failed - when processing query: SELECT ....
Cause
When using DQM(JDBC) to connect to Teradata, if the query item or subject contains non-English characters, Cognos will use the characters to generate SQL alias for column and table. The SQL with the characters will fail to run against Teradata.
Environment
Windows
Resolving The Problem
By creating Multilingual Project in Framework Manager, generating non-English SQL can be avoided but query item and subject can be any characters
1. Creating a project in Framework Manager, make sure the query subjects and query items are English characters in the scope of project design language.
2. In the menu bar, click [Project]-[Languages]-[Define Languages...] to open Define Languages dialog. Then add the language you want from the Available languages to the Project language list, select it , click [Set As Active] and then click [OK]
3. Rename the query items and subjects with the Active language you set in Step 2
4. Create the package
When running the report within browser, Cognos will generate the SQL based on the design language(English) while display the header(column alias) based on the browser language which is the same as the Active Language in Framework Manager
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21635438