cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TesDA
Level: Powered On

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
v-siky-msft
Level 10

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

 

TesDA
Level: Powered On

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...

v-siky-msft
Level 10

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

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,665)