My Oracle Support Banner

In Analytics, Workbook/Dataset Created Using ADW Column Names Enclosed With Double Quotes Is Failing With Invalid Identifier Error (Doc ID 2999606.1)

Last updated on JANUARY 26, 2024

Applies to:

Oracle Analytics Cloud - Version N/A and later
Information in this document applies to any platform.

Symptoms

Analytics Workbook/Dataset Unable To Read Value When ADW Column Enclosed With Double Quote ("ABC") [ABC is column name] 

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000) State: HY000. Code: 77031.

[nQSError: 77031] Error occurs while calling remote service DatasourceService.

Details: [JDSError : 115] Database Error - Cause: ORA-00904: "<Table Name>"."<Column Name>": invalid identifier

Changes

 NA

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.