Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Creating a DV Canvas on an Existing Data Set Fails with 500 - Internal Server Error and Nonexistent
I am using OBIEE 12.2.1.4.0 which has the DV capability and when I am trying to create a canvas in the DV project using an existing RPD,I see the below error
In the obis1-diagnostic.log file, the following error is observed:-
[2019-11-10T22:39:31.325-08:00] [OBIS] [ERROR:1] [] [] [ecid: 616fcc56-436c-4b0c-9a35-fa8b552e0689-00017834,0:1:20] [sik: ssi] [tid: 75c3b700] [nQSError: 27045] Nonexistent column: <Subject Area>"."<Table>"."<Column>".. [[
file: server/Metadata/NQSParser/Src/NQSPParserUtil.cpp; line: 104
I went through some of the solutions present in oracle support forums like ensuring the column exists in the respective Subject area in the rpd,redeploying the rpd, clearing the OBIEE cache,but none of them worked for me. So can someone help me regarding what's the missing piece here.