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.

Well, 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.

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 “&”.

Tags: ,
Subscribe to Comments RSS Feed in this post
3 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.

Leave a Reply

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

*
*

Read previous post:
PeopleSoft Journal Uploader
PeopleSoft Journal Import Error – User-defined type not defined

Close