Creating a DV Canvas on an Existing Data Set Fails with 500 - Internal Server Error and Nonexistent

3673447

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.