MDX Query Fails with Unexpected Error 1042017 in Essbase v11.1.2.1 (Doc ID 1320230.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion Essbase Administration Services - Version 11.1.2.1.000 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.
*** Reviewed for Relevance 12-Apr-2013 ***

Symptoms

An MDX query that previously worked in version 9.3.3 and 11.1.2 no longer works in 11.1.2.1. When the query is executed a network error appears.

Steps to reproduce:
1. Using an ASO database with member formula in the outline with the LEAD function.
2. Run the MDX query which contains the member with the LEAD function from EAS console and the following error message appears:

Unexpected error 1042017



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