IBM Support

Receive 'Application level error' when exporting a huge pivot table from IBM SPSS Statistics

Technote (troubleshooting)


I am working with IBM SPSS Statistics 19 or higher.
I try to export a huge pivot table from Output Viewer to MS Excel or Word, but I receive the following error:
"Application level error. SPSS has encountered a problem with memory. Please attempt to save your work and then exit."

How can I export my huge Pivot tables?

Resolving the problem

Exporting huge Pivot tables to another application file format needs a lot of memory on Export - Output from the viewer SPV file. So if you receive the above message on exporting such tables you may consider to upgrade your machine hardware memory.

Another workaround is to use OMS syntax command instead of the Output Export function as OMS works differently than direct Export to another application format file from Output Viewer.

"The Output Management System (OMS) provides the ability to automatically write selected categories of output to different output files in different formats.
Formats include: Word, Excel, PDF, IBM SPSS Statistics data file format (.sav), Viewer file format (.spv), web report format (.spw), XML, HTML, and text. "

See the topic OMS options on the Statistics Help for more information.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics

Software version: 19.0, 20.0, 21.0

Operating system(s): Platform Independent

Reference #: 1624346

Modified date: 07 September 2016

Translate this page: