E-QR: MS Excel Error When Running Query To Excel From Query Client (2-tier) (Doc ID 2192850.1)

Last updated on OCTOBER 13, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

When attempting to run queries, from PS Query client, which retrieve more than 65K rows , the following error occurs :

ERROR
-----------------------
'Excel interface exception [E:\pt85508b-retail\peopletools\src\psnxl\gridapp.cpp:1213] ' Error for ': '. (28,160)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to psqed.exe
2. Run a query which contains more than 65K rows
3. Notice the error

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