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

Last updated on OCTOBER 07, 2024

Applies to:

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"

Changes

Cause