My Oracle Support Banner

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 and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


When using OBIEE, 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


The issue can be reproduced at will with the following steps.

1.  Enable Auto-complete in the instanceconfig.xml file and save changes.


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.




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

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