Hi there ,

 

We are using Enesys RS Data Extension to access share point list as a data source in SQL Reports – 2005 . However we are facing some issues with this report .

 

There is a Sharepoint inbuilt list UserInfo which is being used in the SQL report , this list is used for populating the full name of the user.

 

However , this report works intermittently and raises exception - execution failed for data set 'UserInfo' .

 

During day time .i.e. when number of  users accessing Share point Portal \ SQL Reports are more , it frequently raises the above exception.

 

We have observed that during night time when traffic is less , this report works fine.

 

As per our analysis , there is no problem with queries written to retrieve list data .

 

Enesys RS Data Extension Version we are using  is : 2.1.0.28200

 

 

Fyi , we have gone through the Support Forum on Enesys.com and one thread - 

http://www.enesyssoftware.com/Forum/tabid/53/forumid/2/threadid/793/threadpage/1/scope/posts/language/en-US/Default.aspx looks similar to that of our issue ,

but could not see any concrete solution provided over there.

Below are few details of exception  : UserInfo'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed

for data set 'UserInfo'. ---> System.Web.Services.Protocols.SoapException: Exception of type

'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse

response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Enesys.SharePoint.Query.WssLists.Lists.GetListItems(String listName, String viewName, XmlNode query, XmlNode

viewFields, String rowLimit, XmlNode queryOptions, String webID)
   at ..GetListItems(String , String , String , XmlNode , XmlNode , String , XmlNode , String )
   at .?.?()
   at ..?(Boolean )
   at Enesys.ReportingServices.Ersde.ErsdeCommand.GetDataTableFromWSS(Boolean onlySchema)
   at Enesys.ReportingServices.Ersde.ErsdeCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()

 

Can you please look into this and let us help to resolve this .

Thanks

Nilesh

 

 

 

 

 

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set

'UserInfo'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed

for data set 'UserInfo'. ---> System.Web.Services.Protocols.SoapException: Exception of type

'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse

response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Enesys.SharePoint.Query.WssLists.Lists.GetListItems(String listName, String viewName, XmlNode query, XmlNode

viewFields, String rowLimit, XmlNode queryOptions, String webID)
   at ..GetListItems(String , String , String , XmlNode , XmlNode , String , XmlNode , String )
   at .?.?()
   at ..?(Boolean )
   at Enesys.ReportingServices.Ersde.ErsdeCommand.GetDataTableFromWSS(Boolean onlySchema)
   at Enesys.ReportingServices.Ersde.ErsdeCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
   --- End of inner exception stack trace ---