locked
fetchxml-based report error RRS feed

  • Question

  • Hi all,

    I able to view normal report which is built by SQL filteredview without any error.

    But it fails when the report is built by fetchxml. Error log is at below, can anyone help me? Thanks a lot.

    Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at System.ServiceModel.ICommunicationObject.Open()
       at Microsoft.Crm.Sandbox.SandboxClientBase`1.Open()
       at Microsoft.Crm.Sandbox.Reporting.ReportServerSandboxSdkClient.Execute(SandboxSdkContext requestContext, String operation, Byte[] serializedRequest)
       at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.SandboxFetchProxy.Execute(OrganizationRequest request)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.SdkMetadataProvider.GetEntity(String name)
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.SdkMetadataProvider.GetEntity(String name)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.MetadataHelper.GetEntity(String name)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.AttributeExpression.get_AttributeMetadata()
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.PropertyExpressionFactory.GetProperties(AttributeExpression attribute)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.MetadataBoundFieldExpression..ctor(AttributeExpression attribute)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.FetchProcessor.InitializeEntityFields(XmlNode entityNode, EntityExpression parentEntityExpression, IList`1 reportFieldNames)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.FetchProcessor.InitializeFields(XmlDocument fetchDocument)
       at Microsoft.Crm.Reporting.DataExtension.Common.Fetch.Utility.FetchProcessor..ctor(String fetchXml, ICrmDataParameterCollection parameters, IMetadataHelper metadataHelper)
       at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionCommand.<ExecuteReader>b__0()
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException[TResult](Func`1 body)
       at Microsoft.Crm.Reporting.DataExtension.Server.Fetch.FetchDataExtensionCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
       --- End of inner exception stack trace ---;
    processing!ReportServer_0-57!78c!04/06/2011-17:38:59:: e ERROR: An exception has occurred in data set 'DataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    Microsoft.Crm.CrmException: An unexpected error occurred.
    System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://devcrm02/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:20.9962144. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808.
    System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://devcrm02/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:20.9962144. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808
       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
       at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
       at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
       --- End of inner exception stack trace ---

     

    processing!ReportServer_0-2!b08!04/06/2011-17:57:54:: e ERROR: An exception has occurred in data source 'DataSource1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    System.Data.SqlClient.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
    Login failed for user '3PSOLUTIONSDEV\DEVSQLRPT02$'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
    Login failed for user '3PSOLUTIONSDEV\DEVSQLRPT02$'.
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
       at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
       at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.IsPrivilegeUserGroupMember(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.ValidateCaller(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Crm.CrmDbConnection.Open()
       at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
       at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
       at Microsoft.Crm.ServerLocatorService.RetrieveById(String tableName, Object primaryKey, String[] columns)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.IsPrivilegeUserGroupMember(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.ValidateCaller(SecurityIdentifier user)
       at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbConnectionExtension.Open(String userSid)
       at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtConnection.Open()
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenConnection(DataSource dataSourceObj, DataSet dataSetObj, OnDemandProcessingContext pc)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessTransactionAndConnection(IJobContext jobContext, Int32 numDataSets, Boolean& concurrentDataSets, IDbConnection& connection, Boolean& closeConnection, TransactionInfo& transInfo, Boolean& isTransactionOwner, Boolean& transactionCanSpanConnections, Boolean& addedTransactionToGlobalDataSourceInfo)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process()
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet)

    Thursday, April 7, 2011 7:40 AM

Answers

  • Hi.

    We have the same problem with CRM 2011.

    I solved it by disabling firewall in crm server.

     

    Check firewall settings for server devcrm02

    By default TCP/IP port 808 is blocked by windows firewall.

     

    Alex.


    Thursday, May 26, 2011 9:06 AM

All replies

  • Hi,

        You use incorrect connection to data source. You need to check  credentials for your report.

    Thursday, April 7, 2011 9:50 AM
  • thanks for your reply, but i think datasource is not a problem.

    normally the datasource need to be correct during report building, and it is not critical when i import it to CRM.

    Thursday, April 7, 2011 10:33 AM
  • Looks like security / connection issue:

     An exception has occurred in data set 'DataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    Microsoft.Crm.CrmException: An unexpected error occurred.
    System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://devcrm02/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:20.9962144. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808.
    System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 192.168.19.26:808 --->

    An exception has occurred in data source 'DataSource1'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    System.Data.SqlClient.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
    Login failed for user '3PSOLUTIONSDEV\DEVSQLRPT02$'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
    Login failed for user '3PSOLUTIONSDEV\DEVSQLRPT02$'.

    I don't have the details of your environment, how you built the fetch report, how it was uploaded to CRM, etc. so not able to offer much more than that.

     


    Regards, Donna

    • Proposed as answer by hery halim Monday, September 19, 2011 9:13 AM
    Saturday, April 9, 2011 9:10 PM
  • Please start Net.Tcp Listener Adapter service, then try to run the report again. If it still failed, please paste the error log here.
    Please remember to click “Mark as Answer” on the post that helps you. Jackie Chen, Microsoft Online Community Support
    Monday, April 11, 2011 7:21 AM
  • Hi.

    We have the same problem with CRM 2011.

    I solved it by disabling firewall in crm server.

     

    Check firewall settings for server devcrm02

    By default TCP/IP port 808 is blocked by windows firewall.

     

    Alex.


    Thursday, May 26, 2011 9:06 AM
  • i also encountered the same error.

     

    Has anyone found the solution yet?

    i checked the firewall has all been disabled.

    Any idea?

     

    thanks

     

    regards,

     

    hery halim

    Monday, August 15, 2011 9:41 AM
  • Did you try the suggestion,

    "Please start Net.Tcp Listener Adapter service, then try to run the report again. If it still failed, please paste the error log here"

    Do you have a copy of the error log?


    Regards, Donna

    Sunday, August 21, 2011 2:12 AM
  • A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond XX.Xx.xx.xx:808

     

    --> donna and alexsandr G right in my case. It was port 808 that was by default closed by the administrator.

    i just request the firewall admin to open it. And everything work fine now.

     

    thanks guys

    • Proposed as answer by hery halim Monday, September 19, 2011 9:16 AM
    Monday, September 19, 2011 9:16 AM
  • Great, I'm glad it is working now.  Please feel free to mark the responses as Answered that answered your question.

    Regards, Donna

    Monday, September 19, 2011 11:40 AM
  • Hello, I have the same problem. The port 808 is open but sandbox service is on another server than crm web app. The error is:

    Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DSMain'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
    Microsoft.Crm.CrmException: An unexpected error occurred.
    System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://ed-crmweb01/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0468750. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.29.3.4:808.
    System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.29.3.4:808 ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: An unexpected error occurred. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Could not connect to net.tcp://ed-crmweb01/CrmSandboxSdkListener-w3wp. The connection attempt lasted for a time span of 00:00:21.0468750. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.29.3.4:808.  ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.29.3.4:808

    The report is trying to connect to net.tcp://ed-crmweb01/CrmSandboxSdkListener-w3wp (10.29.3.4:808) but sandbox service is running on net.tcp://ed-crmasp01/CrmSandboxSdkListener-w3wp. Is there any possibility how to change it?

    Thanks 


    Pavel Brestovsky
    Wednesday, October 19, 2011 9:25 AM