cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

The value -104 of type System.Double is outside the valid range(0 to 1000000000)

I'm pulling in a table from Azure SQL Server. What should I re-cast() this column as in SSMS in order to get it to not cause this error? Or does this error require a different solution?

 

Load to Common Data Service failed. Details: Bad Request {"error":{"code":"0x80044330","message":
"A validation error occurred for cr883_vps_emp_emporg.cr883_pytdvar2.
The value -104 of type System.Double is outside the valid range(0 to 1000000000).","innererror":{"message":"A validation error occurred for cr883_vps_emp_emporg.cr883_pytdvar2. The value -104 of type System.Double is outside the valid range(0 to 1000000000).","type":"System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]","stacktrace":" at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.CreateInternal(Entity entity, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, Dictionary`2 optionalParameters)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataExecutionContext.CreateOrganizationResponse(Entity entity)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.CreateEdmEntity(CrmODataExecutionContext context, String edmEntityName, EdmEntityObject entityObject, Boolean isUpsert)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.PostEntitySetImplementation(String& entitySetName, EdmEntityObject entityObject)\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: 218e1017-002a-4355-a355-72ff4de8a984)

4 REPLIES 4
Highlighted
Community Support
Community Support

Hi @TesDA ,

Can you share more detail with this issue?

When do you met this issue? Do you want to pass data from SQL DB to CDS entity? How do you import it?

For more information about importing data from SQL to CDS, please refer to this article: Self-service data prep with dataflows .

 

Best regards,

Sik

 

Highlighted

For some reason its working now. I'm not sure what happened...

Highlighted

Hi @TesDA ,

 

In my opinion, the cause of  issue is probably that On-premise Gateway didn't succeed to create connection between SQL DB and PowerApps service. So when you restart the PC and On-premise Gateway, the connection can get back to work.

Best regards,

Sik

Highlighted

Glad to hear this is now working. For reference, the error indicate that a data value is outside the designated range of values (which can be defined as part of the field definition in CDS), and changing the data-type wouldn't resolve this. Instead you'd either need to change the value to one within the range, or omit the field value, or expand the range of supported values in the field definition

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (10,271)