Error Building in Oracle 'Invalid Identifier' ORA-00904

Document ID : KB000102466
Last Modified Date : 19/06/2018
Show Technical Document Details
Issue:
When building with Storage = Java Oracle Server multiple tables cause the error: ODBC Error: [Oracle][ODBC][Ora]ORA-00904: : invalid identifier
The fields, types, and table structure looks correct and referenced tables was built successfully as well.
First, try to use Oracle Syntax Checker online https://www.eversql.com/sql-syntax-check-validator/ 
Environment:
Windows , Oracle Database
Cause:
use of a Oracle SQL reserved word as Column Name.
Resolution:
use of a reserved word as a field name (COMMENT). Renaming that field allowed it to be built. See, https://docs.oracle.com/cd/A58617_01/server.804/a58234/vol2_wor.htm
Additional Information: