My Oracle Support Banner

OAS 5.5 : NULL VALUES SHOWS UP ION PROMPTS DESPITE OF USING SHOWNULLVALUEWHENCOLUMNISNULLABLE TAG IN INSTANCECONFIG>XML (Doc ID 2711942.1)

Last updated on SEPTEMBER 17, 2020

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms


Null values showing up in prompts.
ShowNullValueWhenColumnIsNullable is not working as shown below:-

 

For example:

<ServerInstance>
...
<Prompts>
<ShowNullValueWhenColumnIsNullable>never</ShowNullValueWhenColumnIsNullable>
<MaxDropDownValues>256</MaxDropDownValues>
<ResultRowLimit>65000</ResultRowLimit>
<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>
<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>
<AutoCompletePromptDropDowns>
<SupportAutoComplete>true</SupportAutoComplete>
<CaseInsensitive>true</CaseInsensitive>
<MatchingLevel>MatchAll</MatchingLevel>
<ResultsLimit>50</ResultsLimit>
</AutoCompletePromptDropDowns>
</Prompts>
...
</ServerInstance>

Changes

 Upgraded to OAS 5.5 Or Fresh Install of OAS 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.