Intermittent Azure SQl Order Save issue
Posted: Tue Oct 01, 2019 1:56 pm
We are getting an issue not all the time related to saving orders under Azure SQL, we have added code to try resaving the order a second time which overcomes the issue most of the time but it does occur on occasion, bar attempting the save multiple times is there any other way to overcome this issue?
- Code: Select all
Line 869: Error Stack Trace at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderLine.DoLineCalculations(String ChangeSource)
Line 869: Error Stack Trace at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderLine.DoLineCalculations(String ChangeSource)
Line 870: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.CompensateTaxRound()
Line 870: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.CompensateTaxRound()
Line 871: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave(Boolean SavingForPrint, Boolean SavingForSplit)
Line 871: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave(Boolean SavingForPrint, Boolean SavingForSplit)
Line 872: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave()
Line 872: at JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder.iSave()
Line 874: at WOrderQueue.OrderConsolidator.CancelBackorder(SalesOrder newsalesorder) in C:\attkey\WOrderQueue SR6\WOrderQueue\OrderConsolidator.cs:line 70
Line 874: at WOrderQueue.OrderConsolidator.CancelBackorder(SalesOrder newsalesorder) in C:\attkey\WOrderQueue SR6\WOrderQueue\OrderConsolidator.cs:line 70
Line 875: at WOrderQueue.OrderConsolidators.CancelBackorders(SalesOrder newsalesorder) in C:\attkey\WOrderQueue SR6\WOrderQueue\OrderConsolidators.cs:line 57
Line 875: at WOrderQueue.OrderConsolidators.CancelBackorders(SalesOrder newsalesorder) in C:\attkey\WOrderQueue SR6\WOrderQueue\OrderConsolidators.cs:line 57