E-BI: Problems Using Load Balancer URL When Uploading Journals, Vouchers, or Getting the XMLLink Service Listing

(Doc ID 662674.1)

Last updated on NOVEMBER 10, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.46 to 8.55 [Release 8.4]
PeopleSoft Enterprise FIN Payables - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9.2 [Release 8.9 to 9]
Information in this document applies to any platform.

*** Latest revision: 18-August-2017 ***


Symptoms

Performing the "browser test", uploading Journals, Vouchers, or other data from an Excel spreadsheet utilizing xmllink where the URL points directly at each web server, is usually successful. If the URL is changed so it points at a load balancer (LB) in front of the web servers, the uploads and XMLLink service listing fail. The error message varies, depending on various factors. Below is a list of common error messages seen.

"Error 500-- Internal Server Error'
"The server encountered an unexplained condition which prevented it from fulfilling the request"

 

"Please check server connectivity and try again.
Error: Failed to POST data"

 

"Error: The return content is not xmllink data, please check log file xmllinkservlet.log"

 

"A connection with the server could not be established"

 

SSL related errors include the following:

"The download of the specified resource has failed"

"The server returned an invalid or unrecognized response"

 

Error message below occurred after the load balancer SSL certificates were upgraded to SHA-2.

"An error occurred in the secure channel support"

 

Below is a common error when using upload spreadsheets such as Voucher upload, and AR Deposit which use the xmllink service to authenticate the user.

"Login was not successful. Please check your User ID or password"

 

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