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

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

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
Helper V
Helper V

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

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

Highlighted
Community Support
Community Support

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

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
Continued Contributor
Continued Contributor

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

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (4,406)