locked
Newbie : Unable to 'Retrieve' certain table values in CRM RRS feed

  • Question

  • Dear All,

    We have been trying to use the crmservice retrieve method. It works fine for certain tables ( eg: lead , email etc), while throws a 'Server was unable to process request' error for certain other ones such as 'activityparty' ,'activitypointer' etc

    This  code worked well for us :

            Guid actGuid = new Guid("DEAFAAA8-ECCA-DD11-BE84-005056960EF3");
            lead objLead= new lead();
            objLead= (lead)service.Retrieve(EntityName.lead.ToString(), actGuid, new AllColumns());
            return objLead.lastname;

    While this one throws an error :

            Guid actGuid = new Guid("EE7DF408-4233-DF11-B295-005056960EF3");
            activityparty objact = new activityparty();
            objact = (activityparty)service.Retrieve(EntityName.activityparty.ToString(), actGuid, new AllColumns());
            return objact.partyid.Value.ToString();

    Can anyone tell us what the exact reason for this would be ? Is there a kind of blocking mechanisms of certain table/views ? What would be the possible way to make it work !???

    What could be done to have the needed table/views exposed for consuming the service ?

    Being a newbie in the whole CRM , any help would be highly appreciated !

    Thanks in advance !

    Sanu

    Friday, October 22, 2010 8:30 AM

Answers

All replies

  • Update the web references and try again

    To update web reference go to solution explorer

    right click on the web references and select update

     

     

    Friday, October 22, 2010 8:42 AM
  • Dear Varun,

    Thank you very much for the reply !... Did the update.

    Still there is the same error! In fact, now it seems that the 'email' also shoots the error and only the 'lead' table works fine ....

    Is there any way that some entities are blocked in some way !? Can there be such a chance?

     

    Friday, October 22, 2010 8:51 AM
  • Can you paste the exact error message which you are getting

     

    Also check the event viewer and see if any error are recorded

    Friday, October 22, 2010 8:55 AM
  • The eventviewer of crmserver is not available at the moment .. shall have a check of that too... meanwhile ....

    Error Page is :

    Server Error in '/' Application.

    Server was unable to process request.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Web.Services.Protocols.SoapException: Server was unable to process request.

    Stack Trace:

    [SoapException: Server was unable to process request.]
    System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +431678
    System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204
    CRMs.CrmService.Retrieve(String entityName, Guid id, ColumnSetBase columnSet) +126
    usercontrols_uscXSubmitMIF.GetService() +390
    usercontrols_uscXSubmitMIF.Page_Load(Object sender, EventArgs e) +143
    System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
    System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
    System.Web.UI.Control.OnLoad(EventArgs e) +99
    System.Web.UI.Control.LoadRecursive() +50
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Control.LoadRecursive() +141
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


    Friday, October 22, 2010 9:21 AM
  • hi Sanu, The Retrieve message does not support the activityparty entity. Check out the supported entities and target classes for the Retrieve here http://msdn.microsoft.com/en-us/library/bb959490.aspx
    MSCRM Bing'd - http://bingsoft.wordpress.com

    Check out the CRM 4 to CRM 2011 JavaScript Converter Tool
    Friday, October 22, 2010 9:28 AM
    Moderator
  • Hi Clinton,

    Thanks for your reply. Was able to get a good idea of the whole retrieve stuff and even more!.

    Though still not yet done with the full thing, guess im on the right track.

     

    Regards,

    Sanu

    Friday, October 22, 2010 12:46 PM
  • Friday, October 22, 2010 1:13 PM
    Moderator