OBIEE 11g When Running A Report With A LOOKUP SPARSE Column In An Analysis Using SQL Server Error - 'Field Descriptor Id 1 Is Beyond The Maximum Field Count 0' (Doc ID 2003447.1)

Last updated on MAY 11, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.141014 and later
Information in this document applies to any platform.

Symptoms

When Running A Report With A LOOKUP SPARSE Column In An Analysis, the following error is encountered:


[2014-12-12T09:46:29.000-05:00] [OracleBIServerComponent] [TRACE:3] [USER-34] [] [ecid: 0052WNpETM0Fw000jzwkno00058S000U0Y,0:1:1:9:5] [tid: 395fd940] [requestid: 718d002f] [sessionid: 718d0000] [username: xxx] -------------------- Query Status: [nQSError: 46030] Field descriptor id 1 is beyond the maximum field count 0. [[
[nQSError: 43119] Query Failed:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms