I have sucessfully created a QAAWS and am trying to use this in Xcelcius.
When I create a web services connection, import the URL it correctly pulls the columns which I can map to my Excel model. Things are looking good at this point.
When I go to preview the Xcelcius output and click on the web services button I get a message box “Error 2032” immediatley. For the life of me I cannot find out what this means.
It seems to me that the qaaws is pulling the correct db info (rows, tables, etc). But it may be when I am executing the service it is never pulling the data. When I plug the url into my browser, again I get the meta data information but no real data.
This error has to do with cross domain access. There is a file that you need to add, but I cannot recall the name right now. I will try to find it and post it…
I installed Fiddler and the httprequest did get sent. However, Fiddler showed that the response was encoded. It looks like the web response string I returned from the web service method contains the “<data>…” instead of “…”. Do you think XCelsius failed because of this? Thanks!
I had the same error using Flynet Viewer. This is the information provided by flynet to resolve the problem:
Error 2032 and other Flash Errors in Xcelsius. Adding a Cross-Domain policy file (Crossdomain.Xml)
KBA-01012
Problem
In an exported flash file (.swf) from Xcelsius (Dashboard) a Flash security error can occur if a Web service is connected to the dashboard from another domain. This can occur as Flash Error 2032 and other various error messages. External Data will not be returned to the Dashboard until a Crossdomain.xml policy file is created.
Solution
A Cross domain policy file (crossdomain.xml) must be added to the Internet Information Services (IIS) root level directory where the Web service resides.
Additional Comments
Creating a Crossdomain.Xml file.
Open Notepad and cut and paste the following code into the Notepad file.
<?xml version='1.0'?>
Save the file by clicking File>Save as Enter the File Name as: crossdomain.xml and the Save As Type: All Files this is important otherwise it will be saved with a .txt extension.
The file must now be placed in the root level directory of IIS.
To find the Root level directory of IIS first go to IIS Manager , go to Control Panel>Administrative Tools>IIS
Expand the Web Sites tree and find the Web Site containing the Web Service , the default is ‘Default Web Site’
Right-Click on the Web site and select ‘Properties’
Click on the ‘Home Directory’ tab.
The Root level directory is shown in the property box for ‘Local Path’ this is usually ‘C:\inetpub\wwwroot’ by default.
Place your Crossdomain policy file in the Root level directory.
For more information and details of Cross-Domain policy files go to http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_14213
For added security the Domain can be specified in the policy file itself. To do this you can add lines to the policy file above, e.g
Thank you TimothyVB! Your instructions were very helpful, I got passed the error 2032. My next question is, I wanted to use the webservice connection to return xml data (using same xml format as returned by XML data connection), but the soap response returned the xml string with “<” and “>” and I suspect XCelsius does not handle this response string correctly. Can anyone confirm that this is true? Thanks!