请教Xcelsius通过Qaaws连接Universe取数的问题

[Former Member]

我安装的版本：

SAP BusinessObjects Edge Series 3.1 + Xcelsius Engage Server 2008 + SAP Kit

现在通过Qaaws连接Universe正常，Xcelsius的数据管理器中建的WEB服务连接导入Universe信息也正常（能看到输入值、输出值，下面显示1方法可用），

刷新选项也配置了，加载时刷新、间隔5秒

但是数据就是出不来，啥反应都没有，预览也没有错误信息，Universe是正常的，连的是ACCESS，Universe里能看到表的数据，这是什么原因呢？

试用版本只有 Engage 和 Engage Server 的，难道是Xcelsius Engage Server 2008 版本不能用Qaaws方式连接Universe吗？

求教了~~

注：我是在服务器端直接弄的，不是在客户端

[sunny_zhang · Accepted solution]

1. 在Xcelsius的机器上打开一个IE，输入WSDL地址，是什么结果？

2. 有没有其他的Xcelsius可以试一下看看是不是也是一样的结果？

[Former Member · Accepted solution]

您好，Sunny Zhang

1.直接打开WSDL地址，得到像下面这样的代码：

<?xml version="1.0" encoding="UTF-8" ?>

- <definitions xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:s0="NOR" xmlns:tns1="dsws.businessobjects.com" targetNamespace="NOR" xmlns="http://schemas.xmlsoap.org/wsdl/" name="queryasaservice">

- <types>

- <s:schema elementFormDefault="qualified" targetNamespace="NOR">

- <s:element name="runQueryAsAService">

- <s:complexType>

- <s:sequence>

<s:element name="login" type="s:string" />

<s:element name="password" type="s:string" />

</s:sequence>

</s:complexType>

...more.

2.在另一台客户端上也装了 Xcelsius Engage Server 2008 ，也是同样的情况，导入能看到输入值、输出值，但数据就是出不来。。

[Former Member]

刚发现用导出预览时有提示错误如下：

Error #2170: Security sandbox violation: file:///C|/DOCUME%7E1/ADMINI%7E1/LOCALS%7E1/Temp/XC%5F17ec/swf255.swf cannot send HTTP headers to http://bodemo34:8090/dswsbobje/qaawsservices/queryasaservice?&cuid=AdpdCY8WVp5FhNYAr3ALNxA&authType=....

这个是什么错误？

[sunny_zhang]

有点忙，来不及翻译，先给你发个英文的吧~~

Error #2170: Security sandbox violation: <domainA> cannot send HTTP headers to <domainB>

Symptom

The Xcelsius SWF is saved onto a SharePoint server, but returns a #2170 error when attempting to refresh data from the Business Objects Enterprise Server

The crossdomain policy file has been applied to the WebLogic application server to successfully view http://server:port/crossdomain.xml from the client browser

Running the Flash debug player returns the following error in the trace log: "Error: [strict] Ignoring policy file at http://<server>:<port>/crossdomain.xml due to missing Content-Type. See http://www.adobe.com/go/strict_policy_files to fix this problem."

Reproducing the Issue

Envorinment:

Xcelsius 2008 Service Pack 2

Solaris WebLogic 9.2

Windows SharePoint Services 3.0 (WSS 3.0)

Business Objects XI 3.1 Fixpack 1.8

Create an Xcelsius dashboard that contains a connection to update from Live Office

Test in the same Business Objects environment to ensure the data refreshes

Deploy the SWF file to another server (ie. Sharepoint) and test the SWF refresh, which still points to the original Business Objects system.

Apply the Crossdomain policy file on the remote HTTP server to ensure access to: http://<remoteDomain>:<port>/crossdomain.xml

Error #2170: Security sandbox violation: <domainA> cannot send HTTP headers to <domainB> is returned

Cause

Flash Player is ignoring the policy file (crossdomain.xml) that is placed on the remote server because the response header information does not include the content-type. If content-type is not specified, then the Flash Player will consider the policy file to be invalid.

Resolution

Within the WAR file used to deploy the crossdomain.xml on WebLogic, "mime-type" clauses need to be added to the WEB_INF/web.xml:

<mime-mapping>

<extension>xml</extension>

<mime-type> application/xml </mime-type>

</mime-mapping>

See Also

http://www.adobe.com/go/strict_policy_files

[sunny_zhang]

内容太多乱了，分成三部分回复：

Error #2170: Security sandbox violation: <domainA> cannot send HTTP headers to <domainB>

Symptom

The Xcelsius SWF is saved onto a SharePoint server, but returns a #2170 error when attempting to refresh data from the Business Objects Enterprise Server

The crossdomain policy file has been applied to the WebLogic application server to successfully view http://server:port/crossdomain.xml from the client browser

Running the Flash debug player returns the following error in the trace log: "Error: [strict] Ignoring policy file at http://<server>:<port>/crossdomain.xml due to missing Content-Type. See http://www.adobe.com/go/strict_policy_files to fix this problem."

[sunny_zhang]

Reproducing the Issue

Envorinment:

Xcelsius 2008 Service Pack 2

Solaris WebLogic 9.2

Windows SharePoint Services 3.0 (WSS 3.0)

Business Objects XI 3.1 Fixpack 1.8

Create an Xcelsius dashboard that contains a connection to update from Live Office

Test in the same Business Objects environment to ensure the data refreshes

Deploy the SWF file to another server (ie. Sharepoint) and test the SWF refresh, which still points to the original Business Objects system.

Apply the Crossdomain policy file on the remote HTTP server to ensure access to: http://<remoteDomain>:<port>/crossdomain.xml

Error #2170: Security sandbox violation: <domainA> cannot send HTTP headers to <domainB> is returned

[sunny_zhang]

Cause

Flash Player is ignoring the policy file (crossdomain.xml) that is placed on the remote server because the response header information does not include the content-type. If content-type is not specified, then the Flash Player will consider the policy file to be invalid.

Resolution

Within the WAR file used to deploy the crossdomain.xml on WebLogic, "mime-type" clauses need to be added to the WEB_INF/web.xml:

<mime-mapping>

<extension>xml</extension>

<mime-type> application/xml </mime-type>

</mime-mapping>

See Also

http://www.adobe.com/go/strict_policy_files

[Former Member]

谢谢，刚才处理了，增加了crossdomain.xml 文件后，导出预览已经没有错误提示信息了，

但是这个问题解决了，数据还是读不出来，这应该是2个问题了，

苦脑中。。。

[Former Member]

问题解决了，应该说本来就没有问题

原来连接读数据是不会往EXCEL中写的，只用来定义存放数据的区域

用数据时直接组件用就行了，

这个。。。。。，真雷倒我了，

[Former Member]

Wilson

很高心你的问题解决！以后请别忘记给帮助过你的坛友们积分。

[Former Member]

Hello Wilson，

这种情况可以先看看Xcelsius的log；或者找一个Web Services的监测工具看看QaaWS的Web Service是否正常，既然Universe上没问题， 那问题就可能出在QaaWS这层了。

[Former Member]

谢谢Rongliang Li 的回复，

我没找到您说的Xcelsius的log，不知是在哪个菜单或文件目录下？