May
10
Error: [nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column.
Description
This error message is associated with the “Descriptor ID” feature introduced with OBIEE 11g. This feature is aimed at transparently replacing descriptor fields (ie. Department Name) with their equivalent ID fields (ie. Department ID) on the WHERE clause of SQL statements issued by the BI server. This is achieved by selecting a “Descriptor ID” field on the logical column definition for each descriptor field.
Symptoms
Error message “[nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column.”
Cause
This error message refers to an instance of a descriptor field where this Descriptor ID selection has been removed from the descriptor field.
Solution(s)
Depending on your current requirements you can resolve this issue by either:
1) Verify a Descriptor ID field has been configured on your logical column
2) Edit the logical SQLfor each report with this error on the Analysis designer Advanced tab to remove the Descriptor ID references.
3) Depending on the amount of formating and layout customization on your report sometimes is best to instead edit the XML and remove all references to DESCRIPTOR_IDOF().”
If you find this post useful please or Share our site!
Symptoms
Error message “[nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column.”
