E-QAS/QR: "RESTListeningConnector:returnResponse() The value 9999999999 is not an Integer" Error When Running QAS REST Services in PeopleTools 8.58 (Doc ID 2818582.1)

Last updated on JULY 27, 2022

Applies to:

Symptoms

When attempting to Execute QAS_EXECUTEQRY_REST_GET service operation, running the process does not give results and the following error message is seen in browser window:

In the errorLog.html log file, the following error message will occur:

Note: To generate the errorLog.html, follow the below steps:
a. Locate integrationGateway.properties and set ig.log.level=5
b. Locate in File Path:
<PS_HOME>/webserv/<DOMAIN_NAME>/applications/peoplesoft/PSIGW.war/WEB-INF/errorLog.html

In order to reproduce the issue, follow the below steps:

1. Login into PIA.
2. Navigate to Reporting Tools > Query > Query Manager.
3. Create a new PUBLIC query (for example, based on CONTRY_TBL record).
4. Select only 2 fields (for example, COUNTRY and DESCR).
5. Navigate to PeopleTools > IB > Integration Setup > Service Operations.
6. Opened QAS_EXECUTEQRY_REST_GET.
7. Filled in the fields.
QueryName: [Query Name]
IsConnectedQuery: N
OwnerType: public
MaxRow: 999999999
QueryResultType: WEBROWSET
QueryResultFormat: NONFILE
8. Click on "Generate URL" button.
9. Copy the URL and open it in a browser.

Changes

Upgrade to Peopletools 8.58.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.