Excel to CI Error – Invalid XML Returned

Today one of our users called in stating that they were getting an error while trying to upload the data using the Excel to CI utility.

The text of the error was: Error: Invalid XML Returned. The response text is not valid XML. Login Data cleared.

Excel to CI Error - Invalid XML Returned

Excel to CI Error - Invalid XML Returned

Upon investigation, it was found that a wrong entry in the Connect Information sheet was the root cause of this error.

The PeopleSoft Site Name entered was incorrect. After entering the correct site name, the tool started working perfectly.

There are other scenarios that could result in the “Invalid XML Returned” error.

Let’s look at all of them.

Connect Information Incorrect

The entries you make on the Connect Information sheet is used to connect to your PeopleSoft environment.
So if any of the following is incorrect, the Excel to CI will not be able to connect and instead return the Invalid XML error.

  • Protocol
  • Portal
  • PeopleSoft Site Name
  • Node
  • Language Code

Security

Another reason for this error to occur would be that none of the Permission Lists that are associated with the user has access to WEBLIB_SOAPTOCI iScript.
But in our case, this was ruled out as this user was able to use Excel to CI till the week before.

Incorrect Password / Password Expired

It goes without saying that if the user’s password is incorrect or has expired, they wouldn’t be able to connect to the PeopleSoft Environment and will get the XML error instead.

Password About to Expire

It’s also interesting to know that this could happen if the user’s password is about to expire.
The Password About to Expire notification can result in the Invalid XML error.

Some Special Chars

If you have ruled out the above possibilities, then there could be yet another reason that this may happen.
It can be due to the presence of invalid characters in the actual data being uploaded, the most common such character being “&”.

Other Excel to CI Errors

There are other errors that the utility throws as well.

URL Not Found

When your Web Server Machine Name is incorrect, it shows the URL Not Found error.

Error: URL Not Found
Cannot find URL https://web-server:/psc/site-name/EMPLOYEE/PSFT_CS/s/

URL Not Found Error

sendSOAPRequest_SubmitToDB

When the HTTP Port is incorrect, it shows the sendSOAPRequest_SubmitToDB error.

sendSOAPRequest_SubmitToDB
Error occurred in routine sendSOAPRequest_SubmitToDB:
Error:
Number: -2147012867
Description: A connection with the server could not be established

sendSOAPRequest_SubmitToDB

Tags: ,
Subscribe to Comments RSS Feed in this post
5 Responses
  1. I got the same error and discovered that it could be caused by the wrong Web Server Machine Name as well.

    • @Nevena – Thanks for posting it here.
      It could be useful for someone looking for a solution.

  2. We got the same error and found that it was due to employee password was about to expire (10 days were remaining).

    Changing the password fixed the issue.

  3. Tuve el mismo error, este se derivado de que los parametros siguientes eran incorrectos: parámetros: Web Server Machine Name: ;
    HTTP Port; los copie de la URL del aplicativo y funcionó correctamente el Excel TO CI.

  4. We have the same issue, but in our case it was a password exipred notification at Peoplesoft. Once it was changed the error was fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*