My Oracle Support Banner

OAC: Creating a Project on an Existing Data Set Fails with 500 - Internal Server Error and Nonexistent Column Error (Doc ID 2455119.1)

Last updated on OCTOBER 10, 2019

Applies to:

Oracle Analytics Cloud - Classic - Version 18.2.1 and later
Information in this document applies to any platform.

Symptoms

There exists an Oracle Applications connection to /analytics for the same OAC instance.

There exists a Data Set on that connection with columns / tables from a Subject Area in the RPD (Data Model).

In Data > Data Sets > Click on the Data Set to create a new Project. See the following error is thrown:-

Something Went Wrong
It looks like we did something wrong. Please try again, but if the problem persists know that we are trying hard to make the product perfect.

Show Details
500 - Internal Server Error. Please try again in a few moments

In the obis1-diagnostic.log file, the following error is observed:-

... [OBIS] [ERROR:1] ... [nQSError: 27045] Nonexistent column: "<Subject Area>"."<Table>"."<Column>". [[
file: server/Metadata/NQSParser/Src/NQSPParserUtil.cpp; line: 104
...
Logical SQL:{call NQSGetSQLCustomColumns('XSA(''<User>''.''<Column>'')','%','Columns','%')}
/* type='subjectArea' */

In Data > Data Sets > Click on the Data Set and select Edit from the menu. See all columns and results display, with no errors thrown.

Changes

 

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.