Ошибка /0/rest/UsrIntegrationService/Orders 200 при передаче: {
"ordersData": [
{
"orderNumber": "СА000024583",
"orderID1C": "2fcb3685-a952-11e9-80d7-0050560118b6",
"orderDate": "2019/07/18 15:07:21",
"orderContactUsrID1C": "63b52eeb-d63b-11e5-a1d7-984be16421ed",
"orderUsrAccountID1C": "cf6ed7af-7187-11e9-80d6-0050560118b6",
"orderDepartmentID1C": "da3b59a3-d1b8-11e0-860a-002215b20579",
"orderScheduledAmount": "0",
"orderPaidAmount": "0",
"orderProductInfo": [
{
"productID1C": "187c6eb8-d127-11e7-80ca-005056013062",
"quantity": "3",
"usrOrderPrice": "290.8",
"usrAmount": "872.39",
"orderScheduledQuantity": "3",
"orderShippedCanceledQuantity": "0",
"orderLeftToShipQuantity": "3",
"orderReserveQuantity": "0",
"orderFreeRemainderQuantity": "0",
"orderRemainsToProvideQuantity": "243"
},
{
"productID1C": "5d2665d2-7fc5-11e6-8297-984be16421ed",
"quantity": "2",
"usrOrderPrice": "6316.75",
"usrAmount": "12633.5",
"orderScheduledQuantity": "2",
"orderShippedCanceledQuantity": "0",
"orderLeftToShipQuantity": "2",
"orderReserveQuantity": "0",
"orderFreeRemainderQuantity": "0",
"orderRemainsToProvideQuantity": "107.2"
},
{
"productID1C": "f477eaa4-7ef7-11e6-8297-984be16421ed",
"quantity": "15",
"usrOrderPrice": "774.59",
"usrAmount": "11618.82",
"orderScheduledQuantity": "15",
"orderShippedCanceledQuantity": "0",
"orderLeftToShipQuantity": "15",
"orderReserveQuantity": "0",
"orderFreeRemainderQuantity": "0",
"orderRemainsToProvideQuantity": "75"
}
]
}
]
} Ответ: {"Result":1,"ResultCodeDescription":[{"Key":"InternalError","Value":"Record not saved; System.Data.SqlClient.SqlException (0x80131904): Ошибка преобразования значения nvarchar \"107.2\" в тип данных int.\r\n   в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   в System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n   в System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n   в System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n   в System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n   в System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n   в Polly.Policy.<>c__DisplayClass119_0`1.<Execute>b__0(Context ctx, CancellationToken ct)\r\n   в Polly.Policy.<>c__DisplayClass129_0`1.<ExecuteInternal>b__0(Context ctx, CancellationToken ct)\r\n   в Polly.Policy.<>c__DisplayClass103_0.<NoOp>b__1(Context ctx, CancellationToken ct)\r\n   в Polly.NoOp.NoOpEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken)\r\n   в Polly.Policy.<>c.<NoOp>b__103_0(Action`2 action, Context context, CancellationToken cancellationToken)\r\n   в Polly.Policy.ExecuteInternal[TResult](Func`3 action, Context context, CancellationToken cancellationToken)\r\n   в Polly.Policy.Execute[TResult](Func`3 action, Context context, CancellationToken cancellationToken)\r\n   в Polly.Policy.Execute[TResult](Func`1 action)\r\n   в Terrasoft.DB.MSSql.MSSqlExecutor.FailoverExecute[TResult](DbCommand command, Func`1 func)\r\n   в Terrasoft.Core.DB.DBExecutor.ExecuteCommand[TResult](Func`2 commandExecutionCallback, String sqlText, QueryParameterCollection queryParameters, CancellationToken cancellationToken)\r\n   в Terrasoft.Core.DB.DBExecutor.Execute(String sqlText, QueryParameterCollection queryParameters)\r\n   в Terrasoft.Core.DB.BaseInsert.Execute()\r\n   в Terrasoft.Configuration.UsrIntegrationService.Order(OrderData order)\r\nClientConnectionId:2e52605e-821a-49cb-bfd9-4bc89b0a257d\r\nError Number: 245, State: 1, Class: 16"}]}