Troubleshooting
Problem
While running column analysis on a text file or a data source, Discovery fails with the following error: ODBC Error Message [42S22:904]: [Oracle][ODBC][Ora]ORA-00904: : invalid identifier Please try again!DM.Lib.CoreException: Failed to execute command: create table
Resolving The Problem
This error usually occurs because one of your text file's or data source column heading names is a staging database reserved word.
To workaround this issue, edit the ReservedWords.txt file located in following places by adding the column name in the reserved word list.
- Discovery Engine : \\Discovery\Discovery Engine\Config\ReservedWords.txt
- Corresponding Project: Please find find your corresponding project in the following location and update the reserverdwords.txt located in that project. The default location where the project is located \\Discovery\Discovery Engine\Repos\<Machine name>\Port_9090
- Discovery Studio: \\Discovery\Discovery Studio\Config\ReservedWords.txt
- Restart the DiscoveryEngine service and rerun the discovery task.
[{"Product":{"code":"SSC6AW","label":"InfoSphere Discovery"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1.1;4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Product Synonym
Information in this article applies to: ;- Discovery 3.x;- Discovery 4.0
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21405691