an unhandled exception of type system.nullreferenceexception occurred in Microsoft.XRM.Tooling.Connector.dll

(0) Share

Report

Posted on by Community Member

string crmConnectionString = ConfigurationManager.AppSettings["CRMConnectionString"];
CrmServiceClient service = new CrmServiceClient(crmConnectionString);
WhoAmIResponse whoAmIResponse = (WhoAmIResponse)service.Execute(new WhoAmIRequest());

QueryExpression query_Contacts = new QueryExpression("contact");
query_Contacts.ColumnSet = new ColumnSet("Accountname", "Fullname");
EntityCollection coll_Contacts = service.RetrieveMultiple(query_Contacts);

Can anyone tell me why I am getting error :

an unhandled exception of type system.nullreferenceexception occurred in Microsoft.XRM.Tooling.Connector.dll

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi,

Could you please debug and see if you are getting the connection in "service" variable.

Also use before the connection.

ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;

lastly , please share your "CRMConnectionString".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

query_Contacts.ColumnSet = new ColumnSet("parentcustomerid", "fullname");

Use above line. i don't think there is a field Accountname on contact. Please verify all the fieldnames in columnset are present in crm record and field names in columnset should be in lower case.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

<appSettings>

<add key="CRMConnectionString" value="AuthType='Office365'; Url='https://**************.dynamics.com/'; Username='Za.aa.com'; Password='XX';" />

</appSettings>

That was my CRMConnectionString and when I debug it gets stuck at

Waiting for your kind response.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi,

Can you simply use:

<connectionStrings>

<add name="MyCRMServer" connectionString="AuthType=AD;Url=http://contoso:8080/Test;" />

</connectionStrings>

and code :

CrmServiceClient crmSvc = new CrmServiceClient(ConfigurationManager.ConnectionStrings["MyCRMServer"].ConnectionString);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I want to see the records of Contact Entity and so I was trying the below code which is now showing error because i dont have service anymore

QueryExpression query_Contacts = new QueryExpression("contact");

query_Contacts.ColumnSet = new ColumnSet(true);

EntityCollection coll_Contacts = service.RetrieveMultiple(query_Contacts);

Can you suggest please

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

Hi ,

Take a look below reference code -

goutamdascrm.wordpress.com/.../connecting-dynamics-365-online-using-console-application-c

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I tried to use only these few lines to connect to CRM through windows application but getting error -

System.ServiceModel.FaultException occured in .exe

Can anyone please advice

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi Suchisuchi,

Could you please try this SDK sample (Example 2) and see if it works. Notice the check "if (crmSvc != null && crmSvc.IsReady)" and else part to display the message if there is a problem in connection.

msdn.microsoft.com/.../dn688174.aspx

Basically you need to isolate and find if there is a problem in connecting to CRM or executing the retrieve multiple for contact. Break your code to just return the WhoAmI response first and see if that works or not.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

<Server>", "<Port>", "<OrgName>");

What are these information, Mine is CRM online, i wont know servername, so not sure how to try that, Ravi

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can anyone please give me one error free code for connecting to CRM through C# Windows form, I tried everything from net. Noways are helping me to connect. It throws so many errors that I got fed up.

Was this reply helpful? Yes No