Monday, January 30, 2017

Invalid identifier at OCI call OCIStmtExecute (1)

 Invalid identifier at OCI call OCIStmtExecute (1)


Problem: Error when editing initialization block
Screenshot:
Invalid identifier
Screenshot text:
[NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: [IDENTIFIER]: invalid identifier at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed.
Possible solution:
  • edit the SQL statement
  • change the part that is using [IDENTIFIER] to a part that is not using [IDENTIFIER]
  • save the statement
The error message is not displayed anymore.

No comments:

Post a Comment

How To Fix Hive – Partition Table Query Failed When Stored As Parquet

This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...