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

[TesDA]

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)

[v-siky-msft]

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]

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

[v-siky-msft]

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

[DavidJennaway]

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