ExecuteNonQuery error making sales order

[pricerc]

Customer's web site people are attempting to convert Quote to SalesOrder.

Using this URL : http://xxx.xxx.xxx.xxx/Jiwa//SalesQuote ... /MakeOrder, they are getting this error

{
"ResponseStatus": {
"ErrorCode": "InvalidOperationException",
"Message": "ExecuteNonQuery requires an open and available Connection. The connection's current state is open.",
"StackTrace": "[SalesQuoteMAKEORDERRequest: 21/11/2022 4:02:09 AM]:
[REQUEST: {QuoteID:ee65c399b28942df9978}]
System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is open.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at JiwaFinancials.Jiwa.JiwaODBC.database.ExecuteNonQuery(SqlCommand SQLCommand)
at JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue.iSave(String ID)
at JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue.Save(String ID)
at JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValueCollection.Save(String ID)
at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave(Boolean SavingForPrint, Boolean SavingForSplit)
at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave()
at JiwaFinancials.Jiwa.JiwaApplication.BusinessLogic.Maintenance.Save()
at JiwaFinancials.Jiwa.JiwaSales.SalesQuote.SalesQuote.MakeOrder(SalesOrderTypes eOrderType)
at JiwaFinancials.Jiwa.JiwaServiceModel.SalesQuoteServices.Post(SalesQuoteMAKEORDERRequest request)
at lambda_method(Closure , Object , Object )
at ServiceStack.Host.ServiceRunner`1.<ExecuteAsync>d__13.MoveNext()",
"Errors": []
}
}

Any suggestions on where to start looking for a cause?

[SBarnes]

For starters what SR version is this and what version of the REST api plugin is in the Jiwa database?

Also are there nay other enabled plugins that could be attaching to the save end of the sale order?

[pricerc]

They were on SR13 at the time. I've just had them update to SR14, including the API plugin, and have asked them to test.

They do have a plugin that operates on their custom fields. I will check that out, although we've had no previous problems with it.

[SBarnes]

Did this get solved?

The reason I am asking we have had a customer getting similar errors and it looks like its a problem with available licenses.

[pricerc]

They have not reported that same error since they updated to SR14 and loaded the new REST API plugin.

They are having some intermittent problems, but at this stage I'm only half in the loop, so I don't know what errors they're getting.

I know they are having the occasional failure, and the occasional duplicate. I suspect the web site people are not processing the REST API response correctly.