KBI 310114 ODBC Errors And Invalid Identifier When Using Oracle

Version

8.0A-0804 or below. This KBI only applies to customers using Oracle 9i, 10g and 11g as a backend.

Date

18 Aug 2008

Summary

After installing Argent Extended Technology using Oracle 9i, 10g or 11g as a backend, issues occurred when storing data into the Oracle database.

When investigating the Argent Alert Engine Log, the following error message was noted:

“ODBC Error: ORA-00904: “type”: invalid identifier

            (FILE: AACMain.cpp LINE: 481)”

Technical Background

The issue is due to a SELECT statement that uses quotes (“) around the column name. The column name in the query is in lower case, but the column name in the table is in upper case.

Oracle identifiers are not case sensitive, but when an identifier is enclosed with a quote (“), it becomes case sensitive.

Resolution

This has been addressed in Argent Extended Technology 8.0A-0807.