M
Massimo
Hi All,
I need to retrieve some data (for instance, CalendarExceptions data ….
exceptions is not intended as an error here) provided by Project Server 2007.
As per SDK documentation such infos are provided by the webservice method
Calendar.ReadCalendars Method (WebSvcCalendar) (please refer
http://msdn.microsoft.com/en-us/library/websvccalendar.calendar.readcalendars.aspx).
The data I need to get will be exposed by a SSRS Report.
I defined a Shared Data Source (XML type) and I am able to connect to the
same without any issue.
I defined a data set for the Calendar.ListCalendars Method (WebSvcCalendar)
as (this method does not require parameters)
<Query>
<Method Name="ListCalendars"
Namespace="http://schemas.microsoft.com/office/project/server/webservices/Calendar">
<Parameters>
<Parameter Name="Item">
<DefaultValue>/</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
<SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Calendar/ListCalendars</SoapAction>
</Query>
and I am successfully retrieving all the data
Once I try to obtain data from Calendar.ReadCalendars Method
(WebSvcCalendar) using the following command (The method requires 2
parameters: <filter>string</filter>;<autoCheckOut>boolean</autoCheckOut>)
<Query>
<Method Name="ReadCalendars"
Namespace="http://schemas.microsoft.com/office/project/server/webservices/Calendar">
<Parameters>
<Parameter Name="Item">
<DefaultValue>/</DefaultValue>
</Parameter>
<Parameter Name="filter">
<DefaultValue></DefaultValue>
</Parameter>
<Parameter Name="autoCheckOut">
<DefaultValue>false</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
<SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Calendar/ReadCalendars</SoapAction>
</Query>
I get the following exceptions (unfortunately here exception is synonymous
of error)
<?xml version="1.0" encoding="utf-8"?><soap:Envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>System.Web.Services.Protocols.SoapException:
ProjectServerError(s) LastError=CalendarFilterInvalid Instructions: Pass this
into PSClientError constructor to access all error information
at
Microsoft.Office.Project.Server.WebService.Calendar.ReadCalendars(String
filter, Boolean
autoCheckOut)</faultstring><faultactor>http://psat_01:56737/SharedServices1/PSI/Calendar.asmx</faultactor><detail><errinfo><general><class
name="Value cannot be null.
Parameter name: s"><error id="13043" name="CalendarFilterInvalid"
uid="e7990118-8e27-41f4-8a42-46d3bb722545"
/></class></general></errinfo></detail></soap:Fault></soap:Body></soap:Envelope>
Any enlightening?
Thanks,
Massimo
I need to retrieve some data (for instance, CalendarExceptions data ….
exceptions is not intended as an error here) provided by Project Server 2007.
As per SDK documentation such infos are provided by the webservice method
Calendar.ReadCalendars Method (WebSvcCalendar) (please refer
http://msdn.microsoft.com/en-us/library/websvccalendar.calendar.readcalendars.aspx).
The data I need to get will be exposed by a SSRS Report.
I defined a Shared Data Source (XML type) and I am able to connect to the
same without any issue.
I defined a data set for the Calendar.ListCalendars Method (WebSvcCalendar)
as (this method does not require parameters)
<Query>
<Method Name="ListCalendars"
Namespace="http://schemas.microsoft.com/office/project/server/webservices/Calendar">
<Parameters>
<Parameter Name="Item">
<DefaultValue>/</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
<SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Calendar/ListCalendars</SoapAction>
</Query>
and I am successfully retrieving all the data
Once I try to obtain data from Calendar.ReadCalendars Method
(WebSvcCalendar) using the following command (The method requires 2
parameters: <filter>string</filter>;<autoCheckOut>boolean</autoCheckOut>)
<Query>
<Method Name="ReadCalendars"
Namespace="http://schemas.microsoft.com/office/project/server/webservices/Calendar">
<Parameters>
<Parameter Name="Item">
<DefaultValue>/</DefaultValue>
</Parameter>
<Parameter Name="filter">
<DefaultValue></DefaultValue>
</Parameter>
<Parameter Name="autoCheckOut">
<DefaultValue>false</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">*</ElementPath>
<SoapAction>http://schemas.microsoft.com/office/project/server/webservices/Calendar/ReadCalendars</SoapAction>
</Query>
I get the following exceptions (unfortunately here exception is synonymous
of error)
<?xml version="1.0" encoding="utf-8"?><soap:Envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>System.Web.Services.Protocols.SoapException:
ProjectServerError(s) LastError=CalendarFilterInvalid Instructions: Pass this
into PSClientError constructor to access all error information
at
Microsoft.Office.Project.Server.WebService.Calendar.ReadCalendars(String
filter, Boolean
autoCheckOut)</faultstring><faultactor>http://psat_01:56737/SharedServices1/PSI/Calendar.asmx</faultactor><detail><errinfo><general><class
name="Value cannot be null.
Parameter name: s"><error id="13043" name="CalendarFilterInvalid"
uid="e7990118-8e27-41f4-8a42-46d3bb722545"
/></class></general></errinfo></detail></soap:Fault></soap:Body></soap:Envelope>
Any enlightening?
Thanks,
Massimo