Excel services issues with Project Web Access sites
Hi,
I am trying to access the excel services API of a project workspace site created through project web access and am not able to add the web reference even though the workspace sites exposes the webservice and methods.
The following error is given in the web service description box:
<<
The document at the urlhttp://litware:104/_vti_bin/ExcelService.asmx?wsdl was not recognized as a known document type.
The error message from each known type may help you fix the problem:
- Report from 'DISCO Document' is 'Root element is missing.'.
- Report from 'WSDL Document' is 'There is an error in XML document (0, 0).'.
- Root element is missing.
- Report from 'XML Schema' is 'Root element is missing.'.
>>
Is this webservice supported in Project Server sites?
Anirudhmk,
Aside from the Project Server licensing issues the error you have shown occurs if you are not referencing a valid site collection. In your example you may will not have created a site collection at the root. You can add the reference using the link
http://litware:104/sites/myprojectsite/_vti_bin/Excelservice.asmx?wsdl
This assumes you have a site collection at the location sites/myprojectsite rather than forcing you to create a root level site.
HTH
Andrew
<<
The document at the url http://litware:104/_vti_bin/ExcelService.asmx?wsdl was not recognized as a known document type.
The error message from each known type may help you fix the problem:
- Report from 'DISCO Document' is 'Root element is missing.'.
- Report from 'WSDL Document' is 'There is an error in XML document (0, 0).'.
- Root element is missing.
- Report from 'XML Schema' is 'Root element is missing.'.
>>
Yep Andrew. That helped me. I too had the same problem and I thought may be wsdl document is disabled @ web.config level. The reason is, as a newbie, when we look at IIS and browse the websites from IIS, we are confused by many web.config files at different levels. So the lesson: I may not see the _vti_bin folder within the
http://..../sites/service.asmx within IIS but while searching for web references in the computer, but that's what I've to use to view the wsdl and add that service as reference.
