OBIEE12c: NQODBC Error Returns When Using Alias to Create Opaque View

(Doc ID 2286422.1)

Last updated on JULY 27, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

 Aliasing Japanese column name when creating opaque view via BI Administration Tool Online-Mode, View failed to deploy with the following NQODBC error. 

--OBIEE 12.2.1.2
--BI Administration Tool Online Mode

1. Launch BI Administration Tool with online mode.

2. Right Click on the Schema Name (such as SH) > New Physical Table

Name: <Any>
Table Type: SELECT

Sample SQL:

  

3. Right Click on the newly created View > Deploy Views

Warning: View Deployment Messages:
Views failed to deploy:

"Database".."Schema"."ViewName"
Details: [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms