"Existence of REport" Code Exception

• Question

• 

  

  0

  Sign in to vote

  Hi

  I have made a Report manually

  Now im checking its existance in C#. I get an exception

  Im Putting code here

  Kindly Check it and tell me where i am Doing mistake.

  
  

  Public void CheckCrmReport (string szReport, string szDomain, string szUser)

  {

                  m_szErrorMsg = "User doesn't exist in Crm";

                  m_CrmService = m_DCRM4ServiceEgine.Service;

  
  

                  #region RetrieveByOrganization                 

                  ColumnSet colsOrganization = new ColumnSet();

                  colsOrganization.Attributes = new string[] { "name", "reportid" };

  
  

                  // Create a ConditionExpression.

                  ConditionExpression conditionUsersInOrganization = new ConditionExpression();                 

                  conditionUsersInOrganization.AttributeName = "address1_city";

                  conditionUsersInOrganization.Operator = ConditionOperator.Equal;

                  conditionUsersInOrganization.Values = new object[1] { "Okara" }; //new object[1];

                 

                  FilterExpression filterUsersInOrganization = new FilterExpression();                

                  filterUsersInOrganization.FilterOperator = LogicalOperator.And;

                  filterUsersInOrganization.Conditions = new ConditionExpression[] { conditionUsersInOrganization };

                   

                  QueryExpression queryUsersInOrganization = new QueryExpression();                

                  queryUsersInOrganization.EntityName = CRMServer.EntityName.report.ToString();//"systemuser";// 

                  queryUsersInOrganization.ColumnSet = colsOrganization;

                  queryUsersInOrganization.Criteria = filterUsersInOrganization;

                   

                  RetrieveMultipleRequest retrieveUsersInOrganization = new RetrieveMultipleRequest();                

                  retrieveUsersInOrganization.Query = queryUsersInOrganization;

                                  

   RetrieveMultipleResponse retrievedUsers=(RetrieveMultipleResponse)m_CrmService.Execute(retrieveUsersInOrganization);                 

                  foreach (BusinessEntity entity in retrievedUsers.BusinessEntityCollection.BusinessEntities)

                  {

                      report user = (report)entity;

                      if (!string.IsNullOrEmpty(user.name))

                      {

                          if (user.name.ToLower() == szUserName.ToLower())

                          {

                              Console.WriteLine("fullname: " + user.name);

                              Console.WriteLine("domainname: " + user.createdon);

                              Console.WriteLine("systemuserid: " + user.reportid.Value);

                              

                              m_szErrorMsg = "User exists in Crm";

                              return true;

                              break;

                          }

                      }

  
  

                  }

  }

  
  

  
  

  
  

  
  

  Im getting exception on this line

   RetrieveMultipleResponse retrievedUsers=(RetrieveMultipleResponse)m_CrmService.Execute(retrieveUsersInOrganization);

  
  

  Exception is

  "Server was unable to process request"

  
  

  Where i am doing mistake

  
  

  Can anyone tell me

  
  

  Any little help will be appreciated

  
  

  Thanks in Advance

  
  

  Regards

  Sohaib Qazi

  Thursday, December 10, 2009 8:57 AM