Issue with oData Query Designer

Mar 13, 2011 at 11:18 AM

Hi,

It seems to be wonderful tool, unfortunately i get this error while trying to access the query tool

 

[Async_ExceptionOccurred]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.60129.0&File=System.dll&Key=Async_ExceptionOccurred

   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at CRM.Tools.ODataQueryDesigner.CrmSdk.ExecuteCompletedEventArgs.get_Result()
   at CRM.Tools.ODataQueryDesigner.Readers.MetadataReader.ExecuteRetrieveEntities_ExecuteCompleted(Object sender, ExecuteCompletedEventArgs response)

 

Regards,

Thiru

Mar 13, 2011 at 11:38 PM

Hello Thiru, thankyou for your feedback. Can you provide some more information to help me diagnose the problem please. I have seen the same error message with my Metadata Browser tool when a user had a French language pack installed.

1. Are using a language pack and what is the language of your CRM instance?

2. Does this happen when accessing the tool from the Server and a client?

3. Are you using on-premise or CRM Online?

 

Thank you,

Rhett

Mar 16, 2011 at 7:30 PM

Rhett.  Was this resolved?  I'm getting this as well.

 

[Async_ExceptionOccurred]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.60129.0&File=System.dll&Key=Async_ExceptionOccurred

   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at CRM.Tools.ODataQueryDesigner.CrmSdk.ExecuteCompletedEventArgs.get_Result()
   at CRM.Tools.ODataQueryDesigner.Readers.MetadataReader.ExecuteRetrieveEntities_ExecuteCompleted(Object sender, ExecuteCompletedEventArgs response)
   at CRM.Tools.ODataQueryDesigner.CrmSdk.OrganizationServiceClient.OnExecuteCompleted(Object state)

Mar 16, 2011 at 8:49 PM

No I cannot reproduce this on my test system and it seems to be a select few who are experiencing this. I have an updated version which should provide futher details in the error window, would you be ok if I emailed it to you to test. My email is rhett.clinton AT gmail.com , email me and I will email it back.

Another item that would be great would be if someone could run fiddler and post me the info (even screen shots) of the packets sent/received.

Obviously I wouldn't normally request these types of actions though I can simply not replicate the error to then debug it myself.

Mar 18, 2011 at 11:40 AM

Can you check your server's eventlog for a System.ServiceModel.ServiceActivationException error and any error log items that seem assocated to it when this occurs and send me the details please.

Thankyou.

Mar 23, 2011 at 6:31 PM

Try accessing crm using the server name and then access the tool.

Mar 24, 2011 at 6:15 PM
Hi,

I tired accessing by server name and as well as by server IP, issue is still the same.

Btw, thanks for looking into this and it would be wonderful tool if it works...

Regards,
Thiru


From: [email removed]
To: [email removed]
Date: Wed, 23 Mar 2011 10:30:41 -0700
Subject: Re: Issue with oData Query Designer [crm2011odatatool:249484]

From: RhettClinton
Try accessing crm using the server name and then access the tool.
Read the full discussion online.
To add a post to this discussion, reply to this email (crm2011odatatool@discussions.codeplex.com)
To start a new discussion for this project, email crm2011odatatool@discussions.codeplex.com
You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.
Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com
Mar 24, 2011 at 6:35 PM

Have you tried from the server and/or a client?

Mar 28, 2011 at 6:00 PM
Edited Mar 28, 2011 at 6:09 PM

Hi Rhett.

I am also experiencing the same error.  I deployed it at an OnPremse implementation.  Any ideas?  No language packs (other than English) have been deployed.  I don't, however, get an error on CRM Online.  But when I execute the query on the OnLine version, I get the following error:

Security error.

   at System.Net.Browser.ClientHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.ClientHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at CRM.Tools.ODataQueryDesigner.QueryDesignerViewModel.<>c__DisplayClass1a.<>c__DisplayClass1c.<DownloadRawContentATOM>b__19() 

Thanks!


Mar 29, 2011 at 7:39 AM
I have tried it from the client..... Will try the same from server and update you.


From: [email removed]
To: [email removed]
Date: Thu, 24 Mar 2011 10:35:41 -0700
Subject: Re: Issue with oData Query Designer [crm2011odatatool:249484]

From: RhettClinton
Have you tried from the server and/or a client?
Read the full discussion online.
To add a post to this discussion, reply to this email (crm2011odatatool@discussions.codeplex.com)
To start a new discussion for this project, email crm2011odatatool@discussions.codeplex.com
You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.
Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com
Apr 6, 2011 at 1:03 PM
Edited Apr 6, 2011 at 1:06 PM

Same error here.  OnPremise and upgraded 4.0 organization.

Editted: It works just fine when I use the computer name in the URL and not the FQDN.  http://crm2011dev/... works but http://crm2011dev.dev.com does not.

Apr 6, 2011 at 6:06 PM

Thanks for that, I will be posting an updated version soon that should resolve the cross-domain issue you guys have been experiencing.

Silverlight prevents cross-domain calls unless you have a clientaccesspoilicy file on the server.  The tool uses the Xrm.Page.context.getServerUrl() function to get the url to use and if this is different from what you access CRM with than its classed as cross-domain.

I will implement a version that looks at your current url first and then fallback to the Xrm.Page.context.getServerUrl() if it fails.

Apologies for the delay.

Apr 15, 2011 at 1:22 AM

I am experiencing the same error. My environment is an online version of CRM 2011. 

[Arg_SecurityException]Arguments: Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.50917.0&File=mscorlib.dll&Key=Arg_SecurityException

Cheers!

Oct 18, 2011 at 1:06 AM

If you still experience the same error please download the latest version 1.0.0.4 and if you see an error please forward it to me.

Many thanks,

Rhett

Jul 8, 2014 at 10:27 PM
Edited Jul 8, 2014 at 10:29 PM
I have this problem too! Help! What's the fix?

I just posted my situation here at https://dynamicsxrmtools.codeplex.com/workitem/1766 before I noticed this thread.

Could this be a Silverlight problem? Is there a particular version of Silverlight I must have installed?

Might this have anything to do with ADFS? ADFS and IFD/Claims is implemented for our CRM Organization and it is not possible to bypass logging in via ADFS. I noticed some "banter" about this tool having various "issues" with ADFS, could that be the issue? Is there a fix or work around of some kind?

I have installed the managed solution DynamicsXRMTools_2_0_0_0_managed.zip into my CRM 2011 organization and downloaded the OData Query Designer Tool.

I can open it and create queries without incident. When I click the "Generate" button, I have no issues.

However when I click the "Execute" button, I experience nothing but problems. All of them are security related.

I am a system administrator of CRM so I have access to every part of it. I cannot imagine what these security errors are about.

Attempt # 1, 2, 3, and 4 on CRM Environment A

Security error. at System.Net.Browser.ClientHttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at DXTools.UI.Modules.ODataQueryDesigner.ViewModels.DesignerViewModel.<>c__DisplayClass36.<>c__DisplayClass38.<DownloadRawContentATOM>b__35()

Attempt # 1, 2, 3, and 4 on CRM Environment B

[Arg_SecurityException]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.00&File=mscorlib.dll&Key=Arg_SecurityException
at System.Net.Browser.ClientHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at DXTools.UI.Modules.ODataQueryDesigner.ViewModels.DesignerViewModel.<>c__DisplayClass36.<>c__DisplayClass38.<DownloadRawContentATOM>b__35()

I get these two types of errors every time and am unable to actually "Execute" the query which is causing me a problem.

Is there any possible way you can debug this or advise me on how to determine exactly what the problem is?
Jul 8, 2014 at 10:59 PM
Hello, it may have to do with http/https internally when using IFD. You could run Fiddler and see if the error message via soap is any better to go on.

Regards,
Rhett

Jul 8, 2014 at 11:19 PM
I will run fiddler tomorrow when I get back to the office and provide an update.

Is there a work around for this type of issue or is more info needed in order to propose a workaround?
Jul 9, 2014 at 7:25 AM
Very few people have encountered it based on feedback and I have been unable to reproduce it.

Regards,
Rhett

Jul 9, 2014 at 6:44 PM
Rhett,

Here are the details of both the fiddler readings and the corresponding errors in your solution that pop-up.

We normally use ONLY ADFS on HTTPS Port 443 and CRM on HTTPS Port 444 so the error message that appears in your solution for that on this latest test was:

[Arg_SecurityException]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.00&File=mscorlib.dll&Key=Arg_SecurityException
at System.Net.Browser.ClientHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at DXTools.UI.Modules.ODataQueryDesigner.ViewModels.DesignerViewModel.<>c__DisplayClass36.<>c__DisplayClass38.<DownloadRawContentATOM>b__35()

The fiddler logs for that session were as follows:

session_using_https444_with_claims_adfss_enabled_crm_using_https443

For comparison purposes, I also disabled adfs/claims so that the environment is solely windows authentication and does not use any adfs/claims authentication.

This means that for this particular test I accessed the CRM environment on HTTP Port 80 using normal windows authentication.

I found that I also got errors when I clicked the execute button but the error message was slightly different:

[AsyncCallbackException]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.00&File=System.ServiceModel.dll&Key=AsyncCallbackException
at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.OnGetResponse(IAsyncResult result)
at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClass19.<InvokeGetResponseCallback>b__17(Object state2)
at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
Inner Exception: [AsyncCallbackException]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.00&File=System.ServiceModel.dll&Key=AsyncCallbackException
at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.FinishSend(IAsyncResult result, Boolean completedSynchronously)
at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.SendCallback(IAsyncResult result)
at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)
Inner Exception: [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer
at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)
at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
at System.ServiceModel.ClientBase1.ChannelBase1.EndInvoke(String methodName, Object[] args, IAsyncResult result)
at DXTools.Core.CrmSdk.OrganizationServiceClient.OrganizationServiceClientChannel.EndExecute(IAsyncResult result)
at DXTools.Core.CrmSdk.OrganizationServiceClient.DXTools.Core.CrmSdk.IOrganizationService.EndExecute(IAsyncResult result)
at DXTools.UI.Modules.ODataQueryDesigner.ViewModels.DesignerViewModel.<.ctor>b__0(IAsyncResult result)
at System.ServiceModel.AsyncResult.Complete(Boolean completedSynchronously)
Inner Exception: [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer
at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
Inner Exception: [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=5.1.30214.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer
at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__1(Object sendState)

The fiddler logs for that session were as follows:

session_using_http_with_claims_adfss_disabled

I am hoping that is enough information to enable you to provide a fix.

One concern I have is that once fiddler is running, it appears that if authentication must occur, the process errors out with fiddler in the middle.

I tested this by launching fiddler and then attempting to log into CRM using HTTPS/ADFS/Claims and again using HTTP/Windows Auth.

Without fiddler, I am able to log into both without any issue and then click over to your solution.

With fiddler running, I am not able to log in to CRM because of issues that seem to arise with fiddler being in the middle.

If I temporarily disable fiddler to log in, then re-enable it I am good and can click through to any application screen.

So for both these tests, I logged into CRM, then enabled fiddler, then accessed your solution and ran the odata query generator then attempted to click the execute button.

I can also give you access to my environment if that would enable you to quickly troubleshoot and resolve the issue.
Jul 9, 2014 at 8:48 PM
Ok cool, thanks for the detailed response, I will need to have a look over this and see if I can narrow down the options. Hopefully I can suggest a few things and otherwise may need access so I can debug but may not be this week.

In the mean time you can just click Show in Browser and this will test your odata query.

Thanks,
Rhett