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 SEPTEMBER 10, 2019

Applies to:

Hyperion Essbase - Version and later
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: <TID>] [userId: <anonymous>] [ecid: <ECID>] [SID: <SID>] [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.