Problems Upgrading to 2019 - Anyone know what this error text means if the issue...

Contributing Cover User Fiona2012
9 Posts
Contributing Cover User
Australia
Fiona2012
Contributing Cover User

11Posts

6Kudos

0Solutions

Problems Upgrading to 2019 - Anyone know what this error text means if the issue...

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

Migration Warnings:
- Warning1 : Processing Sale and Purchase Transactions: Exception of type 'System.OutOfMemoryException' was thrown.

Migration errors:
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.RecordManager.GrowRecordCapacity()
at System.Data.RecordManager.NewRecordBase()
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)
at MYOB.Huxley.UpgradeUtility.UpgradeStepsToV1.SaleAndPurchaseTransactionsPostMigrateStep.ProcessStep()
at MYOB.Huxley.UpgradeUtility.UpgradeStep.Process()
at MYOB.Huxley.UpgradeUtility.UpgradeUtility.Upgrade()

Unsuccessful upgrade!

##--------------------------------------------------------------------------------------##

2 REPLIES 2
MYOB Moderator Neil_M
2,000 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11642Posts

1357Kudos

1634Solutions

Re: Problems Upgrading to 2019 - Anyone know what this error text means if the issue...

HI @Fiona2012 

 

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

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Contributing Cover User Fiona2012
9 Posts
Contributing Cover User
Australia
Fiona2012
Contributing Cover User

11Posts

6Kudos

0Solutions

Re: Problems Upgrading to 2019 - Anyone know what this error text means if the issue...

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

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post