SYMPTOM:
Executing a report that contains an attribute with a form based on ApplySimple making reference to an internal database function “Right”, the following error message is thrown:
Sample Code/Error
QueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect.
ORA-00904: "RIGHT": invalid identifier
CAUSE:
The internal database function “Right” is a Microsoft SQL Server internal function that does not exist in Oracle. In this referred scenario, the warehouse had been recently migrated from Microsoft SQL Server to Oracle, so the ApplySimple statement still contained this function as shown:
ACTION:
Replace the Microsoft SQL Server internal function reference “Right” by an equivalent Oracle function. Contact the Database Administrator in order to obtain further information about internal Oracle function.
