Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
May - last edited May
Unsuccessful: Migration failure
Company File Name : C:\Users\Fiona\AppData\Local\MYOB\Temp\Good Nuts.MYO
Start Time : 01/05/2019 14:52:12 PM
End Time : 1/05/2019 3:23:50 PM
- Warning1 : Processing Sale and Purchase Transactions: Exception of type 'System.OutOfMemoryException' was thrown.
Source : UpgradeUtility
Method : Upgrade
Error : (UpgradeException):
Extra info : System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Data.Common.DecimalStorage.SetCapacity(Int32 capacity)
at System.Data.RecordManager.set_RecordCapacity(Int32 value)
at System.Data.DataTable.NewRecord(Int32 sourceRecord)
at System.Data.DataTable.NewRow(Int32 record)
at MYOB.Huxley.UpgradeUtility.TransactionMigration.TaxTransactionMigrationTask.StoreTaxComponent(Int32 transactionType, Int32 taxTransactionRecordId, Int32 taxCodeRecordId, Nullable`1 linkedAccountId, Decimal taxAmount, Decimal amountForeign, Nullable`1 foreignCurrency, Double taxRate, Decimal threshHold, Decimal thresholdForeign, Decimal calculatedTaxAmt, Decimal taxBasis, Decimal taxBasicAmtForeign, Decimal calcTaxAmtForeign)
at MYOB.Huxley.UpgradeUtility.TransactionMigration.TaxTransactionMigrationTask.MigrateTaxTransaction(Nullable`1 transactionDate, Int32 taxCodeRecordId, IEnumerable`1 taxInformationRows, Boolean isTaxCollected, Decimal lineAmount, Decimal lineInclusiveAmount, Boolean isNegative, Boolean isGeneralJournal, Boolean isTaxInclusive, Int32 lineId, Boolean isInvoice)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.TransactionMigration.BaseEventTaxTransactionMigrationTask.MigrateTaxTransaction(Nullable`1 transactionDate, Int32 taxCodeRecordId, IEnumerable`1 taxInformationRows, Boolean isTaxCollected, Decimal lineAmount, Decimal lineInclusiveAmount, Boolean isNegative, Boolean isGeneralJournal, Boolean isTaxInclusive, Int32 lineId, Boolean isInvoice)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.BaseSaleAndPurchaseEventMigrationTask.MigrateTaxLineProperties(SaleAndPurchaseRow saleAndPurchase, ISaleAndPurchaseTaxEventLine eventLineRow, SaleAndPurchaseLineRow lineRow, IEnumerable`1 taxInformationRows, Boolean isTaxCollected)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.SaleAndPurchaseBusinessEventMigrationTask.CreateBusinessEventLine(Int32 eventType, SaleAndPurchaseRow saleAndPurchase, SaleAndPurchaseLineRow lineRow, IEnumerable`1 taxInformationRows, Boolean isTaxCollected)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.SaleAndPurchaseBusinessEventMigrationTask.MigrateEvent(IEnumerable`1 cashTransactionSet)
It might be worth giving the file a bit of a once over and cleaning it up as much as possible to get the size of the file down. The smaller and tidier a file is the easier it will be to migrate. I recommend following the steps on our forum post, Preparing your company file for upgrading.
This post steps through how to purge old transactions as well as optimizing the file. Optimising the company file compacts the size of the file down as much as possible, and is a great way to tidy up the database after purging old or no longer needed information
4 weeks ago
Thank you Neil_M
Once the file was rolled for the financial year, then optimsed the file size dropped to 30%.The key to this was the optimisation, especially after purging sales data. I have been able to upgrade the file since. Again thank you for your reply