An Error Occurred While Processing This Request Odata
Contents |
I came across this while working with a customer and quickly found that the error triggers a known issue in my Bulk Edit app as well which was
Sorry An Error Occurred While Processing This Request
causing some unexpected errors using the app for some people, however this is sorry an error occurred while processing this request instagram a broader issue as it causes basic OData feeds to fail completely with the following message: Error message accessing /_api/ProjectData/Projects a database error occurred while processing this request
An Error Occurred While Processing The Request On The Server
you will see the following log entries (showing only the interesting bits): Project Server Database agxfb Exception [bucketHash:7C60C52B] SqlException occurred in DAL (ProjectWebApp@NB): Class 16, state 1, line 1, number 8156, procedure , error code -2146232060, exception: System.Data.SqlClient.SqlException (0x80131904): The column ‘Campaignstatus' was specified multiple times for ‘OdataSelect'. Project Server OData abljj High [Forced due to logging gap, Original Level: Verbose] PWA:http://nb/PWA, ServiceApp:Project Server Service Application,
Mvc Sorry An Error Occurred While Processing Your Request
User:i:0#.w|blah\ml, PSI: Exception encountered when trying to instantiante the OdataResultItemCollection As error logs go that is a pretty helpful one! Cause - Duplicate Custom Fields The issue is caused by the Enterprise Custom Field configuration of the Project Server, specifically to looks like there are some duplicate named fields (Campaignstatus in my error above), now of course that is of course not possible! However when you look at the OData feed you can see that a few things happen: Spaces are removed from field names; so e.g. Campaign Status becomes CampaignStatus, etc. Duplicate named fields (after space removal) are numbered, so for example you may see CampaignStatus1. However there is a bug, OData is case-sensitive while SQL is not. So in my example above it seems that there are two fields the same name but with different cases, specifically I have the following two fields configured: Campaign Status and Campaignstatus. In my case if the second field was named CampaignStatus then this issue would not occur as it would have a number appended in the feed! (While this might sound a little esoteric actually I've already seen this a couple of times in German PWA instances where words are typically conjugated, etc) Solution Simple, either; Rename the aforementio
Raju MSFTJune 18, 200810 0 0 0 When an error occurred while processing your request iis developing your service , you might run
An Error Occurred While Processing Your Request Reference 97
into some issues and you want to debug your service. Imagine an error occurred while processing your request facebook that you are inserting data into the store using astoria and you start getting DataServiceExceptions in your client http://nearbaseline.com/2014/09/odata-error-processing-this-request/ code. The normal error message would be ..
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/26400489/wcf-dataservice-returns-an-error-occurred-while-processing-this-request about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up WCF DataService returns An error occurred while processing this request up vote error occurred 0 down vote favorite I have a strange promblem with DataServices when executing specific query: http://localhost:58362/DataService.svc/A?$expand=B/C works as expected http://localhost:58362/DataService.svc/C?$expand=D works as expected On Query: http://localhost:58362/DataService.svc/A?$expand=B/C/D I get { odata.error: { code: "" message: { lang: "en-EN" value: "An error occurred while processing this request." } } } No exceptions in visual. Just this result without more messages. Can it be connected with amount of data? c# wcf wcf-data-services error occurred while share|improve this question asked Oct 16 '14 at 9:10 Arek Żelechowski 1,047619 Try to get more info about the error: stackoverflow.com/questions/2312894/… –Alberto Oct 16 '14 at 10:46 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted Problem is solved now. There was QueryInterceptor, which filtered out some C models. That caused empty C property in some B elements in http://localhost:58362/DataService.svc/A?$expand=B/C/D. Trying expanding with D was breaking the result. Solution is to prepare QueryInterceptor, which does not filter C models in some situations or prepare QueryInterceptor for B. share|improve this answer answered Oct 16 '14 at 13:55 Arek Żelechowski 1,047619 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged c# wcf wcf-data-services or ask your own question. asked 1 year ago viewed 704 times active 1 year ago Linked 17 WCF Data Service - How To Diagnose Request Error? Related 2WC