Exalytics and OBIEE 12c - Auto Complete On Dashboard Prompts Does Not Always Return Values
(Doc ID 2248524.1)
Last updated on JANUARY 26, 2023
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and laterOracle Exalytics Software - Version 2.0.0.0.0 and later
Information in this document applies to any platform.
Symptoms
When using OBIEE 12.2.1.2.0, Auto Complete is not consistently returning values for all prompts.
With Auto Complete enabled in the instanceconfig.xml file, some prompts do not return values and do not Auto Complete.
The Manage Session log shows the following error at the time of the issue:
BufferedFileTable <!-- no file yet -->
Field Metadata: <wchar>,<double>
Ordering Metadata: 1 ASC
Records Seen: <<0>>
Source: <!-- [Closed] -->
Estimated memory usage: 3 Kb
STEPS
-----------------------
The issue can be reproduced at will with the following steps.
1. Enable Auto-complete in the instanceconfig.xml file and save changes.
<ShowNullValueWhenColumnIsNullable>never</ShowNullValueWhenColumnIsNullable>
<MaxDropDownValues>256</MaxDropDownValues>
<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
<AutoCompletePromptDropDowns>
<SupportAutoComplete>true</SupportAutoComplete>
<CaseInsensitive>true</CaseInsensitive>
<MatchingLevel>MatchAll</MatchingLevel>
<ResultsLimit>50</ResultsLimit>
</AutoCompletePromptDropDowns>
</Prompts>
2. Then create a new dashboard that uses a date prompt.
3. Enter 2015 into the date prompt.
4. Auto-complete does not work.
This problem can occur on any OBIEE 12c environment - those on Exalytics as well as standalone OBIEE servers.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |