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?