Коды ошибок opr4onwy u9im8tac oi2dl65p

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 42038 A REPORT totalling function must be in a leaf query block. (HY000)

Cause: A Report totalling function, e.g., REPORT_SUM or REPORT_MAX, is included in a non-leaf query block. This is not allowed.

Remedy is: De-select the option Report-Based Total (when applicable) for all grand totals or subtotals you have applied.

This option is available after you click on sigma button.

Skip to content

User gets the below shown error in Presentation Services when he try  to issue any requests to OBI Server.

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43081] Illegal operation attempted on a closed session. (HY000)

The most possible reason for this error is : 
The BI Server Administrator might have disconnected the current user’s session and that user might be still sending request to the BI Server.

Solution :
When the BI Server Administrator disconnects USER from the current session, then such user can not send request to the BI Server. Because that user in no more in the session to request.

Solution : Log out from the Presentation Services (just click on the Log Out button) and again Log in and check the same request.

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

Error getting drill information

Error Details

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P

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)

Cause:

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.

Solution:

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”.

Screenshots:

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:appXXXXXXproduct11.2.0client_1networkadmin—Tns file.

2. D:11GOracle_BI1networkadmin—- Tns file.

3. D:11Goracle_commonnetworkAdmin — 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.