You’re offline. This is a read only version of the page.
Hey Everyone,
Try to debug my ssis from yesterday but no success. My SSIS script component keep throwing Metadata contains a reference that cannot be resolved: 'crm.domain/.../Organization.svc;sdkversion=8.2'.
I m using Dynamics 365 on premise version 1612(8.2.0.749)(DB 8.2.0.749). The Dynamics 365 was IFD.
To create SSIS package, I already,
1) Using latest dynamics 365 Sdk version 8.2.1.1
2) Yeah, also install this sdk into my GAC. Then reboot my server.
3) To check wether my organization url is correct, I also paste my OrganizationService url in browser and its return a service.
But still the same.
This is my sample code:
Share
Reportstatic void Main(string[] args)
{
IOrganizationService organizationservice;
// Get the CRM connection string and connect to the CRM Organization
ClientCredentials Credentials = new ClientCredentials();
Credentials.UserName.UserName = "username";
Credentials.UserName.Password = "password";
Credentials.Windows.ClientCredential = System.Net.CredentialCache.DefaultNetworkCredentials;
organizationservice = new OrganizationServiceProxy(
new Uri("crm.domain/.../Organization.svc"), null, Credentials, null);
}
I tried my ssis using trial version of Dynamics 365 online and its working fine. I have no Idea and kinda lost.
*This post is locked for comments
Hi Mark ,
I would suggest please post your issue and details in a new thread -
Could you please tell me how to do that,
Thanks very much
Hello,
Could you tell me how to do that?
Thanks
You just saved my life.
Update Microsoft.Xrm.Sdk.dll
OR
Use this code above connection string
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
It worked like a charm! Thank you!
Changing the security setting worked. That was the only thing that worked for me.
Thanks mr cha
It did work!! Thanks..
This problem occurs when the client computer cannot send an HTTP request. The client computer cannot send the HTTP request because the connection has been closed or is unavailable. And Today I realize that My DB server was using TLS1.2 not SSL as a protocol to connect to CRM App Server, so when making a connection from DB to CRM via console app, I must explicitly set the TLS version on the ServicePointManager. Just have this code run anytime before you make the call to CRM organization service.
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12
Hope this will benefit someone in future.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (