Hi,
I am trying to load data into CDS entity just 10 rows, i asked it to create a new entity before load which it did but threw an error while loading the data. Please look into this. Please let me know what causes it, i have been pulling my hair to get this thing right and even i have deleted my old environment and created a new one but data load fails with one or other error which i posted already but did not get much response. All i want to know is i cannot understand whether i am doing something wrong or is it an issue with powerapps. Please advise.
Load to Common Data Service failed. Details: [(([Table with name 'cr689_xboxproductid2s' does not exist], The remote server returned an error: (404) Not Found.), Unable to retrieve metadata for CRM environment: https://unitedstates-002.azure-apim.net/apim/commondataservice/24b3c765-8dca-4ad9-9664-f2229597b4da/$metadata.json/datasets/default.cds/tables/cr689_xboxproductid2s)], One or more errors occurred.. (Job ID: 41f9b5a6-4229-4cf8-8e31-7aea6aa14c76)
Also note that if i load the data into table which already exists i am getting below error.
Load to Common Data Service failed. Details: ID: https://org46963a05.crm.dynamics.com/api/data/v8.2/cr689_xboxproductids?$select=cr689_xboxproductid,cr689_xboxproductidid&$filter=cr689_xboxproductid eq '00000000-0000-4000-8000-0000454107d7' or cr689_xboxproductid eq '00000000-0000-4000-8000-00004d4a07da' or cr689_xboxproductid eq '00000000-0000-4000-8000-00005451085d' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107d5' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107d7' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107e0' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107e9' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107ea' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107ec' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107ef' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107f2' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107f4' or cr689_xboxproductid eq '00000000-0000-4000-8000-0000584107f8': {"error":{"code":"0x0","message":"Could not find a property named 'cr689_xboxproductid' on type 'Microsoft.Dynamics.CRM.cr689_xboxproductid'.","innererror":{"message":"Could not find a property named 'cr689_xboxproductid' on type 'Microsoft.Dynamics.CRM.cr689_xboxproductid'.","type":"Microsoft.OData.ODataException","stacktrace":" at Microsoft.OData.UriParser.SelectPathSegmentTokenBinder.ConvertNonTypeTokenToSegment(PathSegmentToken tokenIn, IEdmModel model, IEdmStructuredType edmType, ODataUriResolver resolver)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.ProcessTokenAsPath(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.Visit(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectBinder.Bind(SelectToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandBinder.Bind(ExpandToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandSemanticBinder.Bind(ODataPathInfo odataPathInfo, ExpandToken expandToken, SelectToken selectToken, ODataUriParserConfiguration configuration)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpandImplementation(String select, String expand, ODataUriParserConfiguration configuration, ODataPathInfo odataPathInfo)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpand()\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.ThrowIfExpandWithRefForNonLookupNavProp(ODataQueryOptions queryOptions, String edmEntityName)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.RetrieveEdmEntityCollection(CrmODataExecutionContext context, String entityCollectionName, String castedEntityName, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.<>c__DisplayClass35_0.<GetEntitySetInternal>b__1()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetInternal(String entitySetName, String castedEntityName, CrmODataExecutionContext context, CrmEdmEntityObjectCollection crmEdmEntityObjectCollection, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetImplementation(String entitySetName)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}}}. (Job ID: 5124b8b3-513e-400a-9156-6684a1acd41c)
Regards,
Shiva M
Hi @v-shimud ,
Could you please clear cache and cookies and refresh your browser and test it again?
Or could you please try it with another environment?
Here is the case whice has similar issue:
Hope this could be helpful.
Best Regards.
Yumia
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1