Category Archives: Berry van den Heuvel
The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column
Problem: Error message in report
Screenshot:
Screenshot text:
State: HY000. Code: 10058. [NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo("SELECT DESCRIPTOR_IDOF([COLUMN]) FROM ([SUBJECT_AREA])}
Possible solution:
- log in to OBIEE as administrator
- edit the report
- remove the filter that is defined on the column [COLUMN]
- save the report
- (optional) add the filter again
- save the report
- click Administration on the top right
- click Reload Files and Metadata
- go back to the report
Now, the error message is not displayed anymore.
Het bericht The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column verscheen eerst op OBIEE 24/7.
The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column
Problem: Error message in report
Screenshot:
Screenshot text:
State: HY000. Code: 10058. [NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo("SELECT DESCRIPTOR_IDOF([COLUMN]) FROM ([SUBJECT_AREA])}
Possible solution:
- log in to OBIEE as administrator
- edit the report
- remove the filter that is defined on the column [COLUMN]
- save the report
- (optional) add the filter again
- save the report
- click Administration on the top right
- click Reload Files and Metadata
- go back to the report
Now, the error message is not displayed anymore.
Het bericht The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column verscheen eerst op OBIEE 24/7.
Oracle BI Scheduler: TNS:listener does not currently know of service requested
Problem: BI Scheduler error in the Enterprise Manager.
Screenshot:
Screenshot text:
The next error occured: Error Oracle BI Scheduler: [nQSError: 17014] Could not connect to Oracle database. [nQSError: 17001] Oracle Error code: 12514, message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at OCI call OCIServerAttach. [nQSError: 68021] Message from Oracle BI Scheduler.
Solution:
- log in to the console of the environment
- click on Business Intelligence – coreapplication
- click on Deployment – Scheduler
- click Lock and Edit Configuration
- copy the string from Data Source. The format is like
-
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[HOSTNAME])(PORT=[PORTNUMBER])))(CONNECT_DATA=(SERVICE_NAME=[SERVICENAME])))
[HOSTNAME], [PORTNUMBER] and [SERVICENAME] must be filled in.
- open SQL Plus
- paste the string in Host String
- click OK
If the Host String is wrong, then you will see the message “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”
- change the Host String until you are succesfully logged in
- copy the Host String that you used
- paste it in the Data Source in Enterprise Manager
- click restart to apply recent changes
- restart all services.
Now the error message will not be displayed and the BI Scheduler will work again.
Het bericht Oracle BI Scheduler: TNS:listener does not currently know of service requested verscheen eerst op OBIEE 24/7.
Internal error: No matching table for expr
If you are editing a report and get this error message;
then probably an applied filter is the problem.
In my case, one of the filter on my report was
Day is equal to / is in @{[repository_variable]}
After removing this filter, the error message was gone.
Het bericht Internal error: No matching table for expr verscheen eerst op OBIEE 24/7.
TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach
When you get the error message (“TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach”)
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
the Data Source Name that is used in the connectionpool of the physical database that is used to show the report, is not found in the tnsnames.ora file.
This is how you can fix it;
- log in to the server
- go to the directory where the tnsnames.ora file is located
-
cd $FMW_HOME/Oracle_BI/network/admin
- create a copy of tnsnames.ora
-
cp tnsnames.ora tnsnames.ora[_orig]
- edit the file, for example with vi-editor
-
vi tnsnames.ora
- insert the entry
- save the tnsnames.ora
-
:wq
The error message will not be displayed anymore.
Het bericht TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach verscheen eerst op OBIEE 24/7.
