✍ Kashif M

Sunday, 16 February 2014


By on February 16, 2014

View Display Error (Error Code: nQSError: 43113, nQSError: 10058, nQSError: 27005, YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P)

Error getting drill information

Error Details


Odbc driver returned an error (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "ME_MEALSEVOLUTION"."ME_ASONDATE".Please have your System Administrator look at the log for more details on this error. (HY000)


What is the reason and why getting the error:

1. ODBC driver error.

2. Column Mis-Matches.

3. Rename of the column or table or Subject areas in the RPD level.

4. User may not have the rights to access the report or Subject area or tables and columns.


1. Check the connection pool of the particular subject area in the RPD.

2. Check the tns entries in the OBIEE folder and Oracle installed folder.

3. Open the command prompt and check the tnsping of the tns entry name.

4. Make sure that the tables, columns; subject area has been renamed before.

5. If you made changes in the rpd level and do the same in the report or dashboard level also.

6. Check the rights of the user in the rpd level.

7. Check the access of the users for each and every table or columns or subject areas in the RPD level.

8. If the access of the user is in “No Access” then you will get this error”view display error”.


Error Details

Check the connection pool:

Check the connection of the database in the connection pool and status of the connection.

Check the tns file and its entries from the locations:

1. D:\app\XXXXXX\product\11.2.0\client_1\network\admin---Tns file.

2. D:\11G\Oracle_BI1\network\admin---- Tns file.

3. D:\11G\oracle_common\network\Admin --- Tns file. (if not create the Tns names as same to all the three location).

Check in the command prompt whether the tns name is in connecting through command prompt or not.

Command: tnsping <tnsname>.

Check in the rpd level of the user is having access or not to see the related subject area.

Right click on the subject area in the presentation layer and click on permission report.

Then see the access of the user, if the user has “No Access” then change the permission and check the report.

Change the “No Access” to “Read” option, then you can see the report.

mkashu: Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
Review : Kashif | Kashif
Update: February 16, 2014 | Rating: 4.5

Comment for "Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P"


  1. Mona Elmenshawy21 July 2017 at 08:04

    Thank you for the post, I'm facing the same error but on the publisher level, The Dataset is retrieving the data successfully but when I try to create the report based on that dataset I got the error, any ideas?

    1. can you share the screenshot of the error?


Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) About Kashif (1) BI Apps Installation (1) BI Publisher (2) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) mkashu (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)