Wednesday, April 19, 2017

Error occur on update using CRM web API: The requested resource does not support http method_other (405 method not allowed )

Error occur on update using CRM web API: The requested resource does not support http method_other (405 method not allowed )

When i update the single property using patch on CRM web API. The above error so I use put to update the singe property.

E.g:

var objSalesOrder= new Object();
objSalesOrder.customerRequest=true;


When i update the sales order using patch the above error occured.

Update a single property value
If you want to update a single property then use the HTTP PUT verb. And append the property name with the Url

Request

PUT [organization URI]/api/data/v8.0/accounts(00000000-0000-0000-0000-000000000001)/name HTTP/1.1
Content-Type: application/json
OData-MaxVersion: 4.0
OData-Version: 4.0
{"value": "Updated Sample Account Name"}

Response

HTTP/1.1 204 No Content
OData-Version: 4.0

Monday, April 17, 2017

CRM Unable to login. In the event viewer,The same client browser session has made '6' requests in the last '2' seconds

The CRM server URL as a trusted site in IE, but not the ADFS URL. After trying to fix the issue I found this knowledge base article: http://support.microsoft.com/kb/2514318 and after adding the domain which covers CRM and ADFS to the IE trusted site list (https://*.domain.com.au) 

I was able to login.

Wednesday, April 5, 2017

LOCAL DB Check and commands

To check Local DB installed
[HKLM\SOFTWARE\Microsoft\Microsoft SQL Server Local DB\Installed Versions\11.0
SqlLocalDB can be found in
C:\Program Files\Microsoft SQL Server\110\Tools\Binn
or
C:\Program Files\Microsoft SQL Server\120\Tools\Binn


Server Local DB\Instances\v11.0), and type:
Delete Local DB

  • sqllocaldb delete "v11.0" 

Create Local DB

  • sqllocaldb create "v11.0"
Start Local DB

  • sqllocaldb Start "v11.0" 

--LocalDB instance "v11.0" created with version 11.0

Check Local DB status

  • sqllocaldb Info "v11.0"