locked
Sql Server Error RRS feed

  • Question

  • Question:

    Subject: We tried to insert phonecall activitys in already existing contacts .

    We are trying to integrate phonecall api into webapplication. we got status 204 but while we trying to open that activity in "online-dynamic-crm", we got the "Sql Server Error".

    Request using "patch" method:

    https://companyname.crm8.dynamics.com/api/data/v8.1/phonecalls(461b3782-0bd8-e611-810c-c4346bdc3c21)

    Header:

    Content-Type : application/json
    Authorization : Bearer + token

    Body:

    {  
       "subject":"call-log 24-1-17 : 02:34",
       "description":"description test 24-1-17",
       "phonenumber":"9595959595",
       "directioncode":"true",
       "actualdurationminutes":"10",
       "phonecall_activity_parties":[  
          {  
             "partyid_systemuser@odata.bind":"/systemusers(8f507b6b-6631-4f4c-9488-d2144b03969a)",
             "participationtypemask":1
          },
          {  
             "partyid_contact@odata.bind":"/contacts(461b3782-0bd8-e611-810c-c4346bdc3c21)",
             "participationtypemask":2
          }
       ]
    }

    Response:

    Status:204 No Content

    Comments:
    Systemuser Id: 8f507b6b-6631-4f4c-9488-d2144b03969a
    Contact Id : 461b3782-0bd8-e611-810c-c4346bdc3c21


    Note: Below is the downloaded log file from "Dynamic 365".

    Error Details:

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #938206A1Detail: 
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
      <ActivityId>ceb623ac-5140-4de6-9250-be9bbc183d2c</ActivityId>
      <ErrorCode>-2147220970</ErrorCode>
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #938206A1</Message>
      <Timestamp>2017-01-24T09:49:05.4235962Z</Timestamp>
      <ExceptionSource i:nil="true" />
      <InnerFault>
        <ActivityId>ceb623ac-5140-4de6-9250-be9bbc183d2c</ActivityId>
        <ErrorCode>-2147204784</ErrorCode>
        <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
        <Message>Generic SQL error.</Message>
        <Timestamp>2017-01-24T09:49:05.4235962Z</Timestamp>
        <ExceptionSource i:nil="true" />
        <InnerFault i:nil="true" />
        <OriginalException i:nil="true" />
        <TraceText i:nil="true" />
      </InnerFault>
      <OriginalException i:nil="true" />
      <TraceText i:nil="true" />
    </OrganizationServiceFault>


    Wednesday, January 25, 2017 5:27 AM

All replies

  • Good morning, have you tried the CRMRESTBUILDER available for free from codeplex?
    Friday, February 10, 2017 9:00 AM