Essbase: Essbase Server and APS 11.1.2.1.107 Errors with: Essbase Error (1020012): Maximum number of columns [255] exceeded (Doc ID 2257343.1)

Last updated on APRIL 24, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.1.107 to 11.1.2.3.508 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When retrieving data from a spreadsheet with more than 255 columns, getting below error:

Maximum Number of columns (255) exceeded when retrieving on an excel template having more than 255 columns.

The apsserver.log has the following error:

[2017-04-19T10:22:06.881-04:00] [AnalyticProviderServices0] [ERROR] [] [oracle.EPMOHPS] [tid: 14] [userId: <anonymous>] [ecid: 0000Li6_rj0ApIs5wjh8iW1OwXBm0001Sp,0] [SID: E911052CD07196C803E98562483027] [APP: APS#11.1.2.0] Essbase Error (1020012): Maximum number of columns [255] exceeded.[[com.essbase.api.base.EssException: Essbase Error (1020012): Maximum number of columns [255] exceeded.

Reported against:

Essbase Server 11.1.2.1.107
Analytic Provider Services 11.1.2.1.107
Smartview 11.1.2.5.000 and higher

 

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