E-QR: Running Query to Excel Logs User out of PIA, "java.lang.NoSuchMethodError:org.apache.commons.io.IOUtils.byteArray(I)[B" error occurs in stderr Log File.
(Doc ID 3011911.1)
Last updated on APRIL 07, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.61 and laterInformation in this document applies to any platform.
Symptoms
When attempting to download PS Query to Excel, Users are logged out from PIA.
The following errors occur:
1). In any browser (e.g. Firefox, Chrome, Edge):
"An error has occurred.
You may attempt to sign in again.
If your attempt fails, please contact your System Administrator.
Please make sure Webserver and Appserver are up."
You may attempt to sign in again.
If your attempt fails, please contact your System Administrator.
Please make sure Webserver and Appserver are up."
2). In stderr log file:
"java.lang.NoSuchMethodError:org.apache.commons.io.IOUtils.byteArray(I)[B
org.apache.commons.io.output.AbstractByteArrayOutputStream.needNewBuffer(AbstractByteArrayOutputStream.java:104)
org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:51)
org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:38)
org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:528)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:245)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:241)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:229)
com.peoplesoft.pt.psspreadsheet.impl.PSFTWorkBookImpl.<init>(PSFTWorkBookImpl.java:175)
com.peoplesoft.pt.psspreadsheet.impl.PSFTWorkBookImpl.<init>(PSFTWorkBookImpl.java:193)
com.peoplesoft.pt.psspreadsheet.WorkbookManager.openWorkbook(WorkbookManager.java:207)"
org.apache.commons.io.output.AbstractByteArrayOutputStream.needNewBuffer(AbstractByteArrayOutputStream.java:104)
org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:51)
org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.<init>(UnsynchronizedByteArrayOutputStream.java:38)
org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:528)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:245)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:241)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:229)
com.peoplesoft.pt.psspreadsheet.impl.PSFTWorkBookImpl.<init>(PSFTWorkBookImpl.java:175)
com.peoplesoft.pt.psspreadsheet.impl.PSFTWorkBookImpl.<init>(PSFTWorkBookImpl.java:193)
com.peoplesoft.pt.psspreadsheet.WorkbookManager.openWorkbook(WorkbookManager.java:207)"
The issue can be reproduced at will with the following steps:
1. Login to PIA.
2. Navigate to Reporting Tools > Query > Query Manager.
3. Search by an existing Query.
4. Select Run to Excel (a new window opens).
5. Fill in any prompts (if any).
6. The user gets a screen "An Error has occurred".
Changes
Upgrade to PeopleTools version 8.61.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |