ExcelToCI的时候,报错:THE RESPONSE TEXT IS NOT VALID XML. LOGIN DATA CLEARED

一般来讲,这个常见错误可能的原因:

1. 网络服务无响应:关掉Excel然后重新打开,重新上传就好了

2. 用户名密码错误

3. CI没有加到Permission List里面

 

今天碰到这个问题,三方面都检查过,依然报错。无奈中,在application designer里测试,可以上传成功。

偶然实验了下重新New Template,结果报错了:

Error retrieving structure of component interface gpmx_pi

<html dir='ltr' lang='zh-cn'>
<!-- Copyright(c) 2000,2009.Oracle.All rights reserved.-->
授权错误-与安全管理员联系</html>

 

去Google搜索这个报错信息,发现需要把WEBLIB_SOAPTOCI 添加到Web Libary中去:

Before you can use the Excel To CI Spreadsheet, you’ll need to know the name of the Component Interface that you’re working with as well as the WEBLIB_SOAPTOCI web library and the SOAPTOCI web service added to one of your permission lists