My Oracle Support Banner

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

Last updated on JULY 31, 2018

Applies to:

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


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#] 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
Analytic Provider Services
Smartview and higher



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.