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
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 *