CODEWITHSUNDEEP
acumatica
Yuriy Zaletskyy
Yuriy Zaletskyy

Reputation: 5151

How to ignore all errors in Acumatica updater

I've executed update of Acumatica data base and faced following error messages:

enter image description here

For now I'd like to ignore all errors during update. Is there a way automatically to ignore all error messages during update of Acumatica database?

Upvotes: 0

Views: 140

Answers (1)

Marco Villaseñor
Marco Villaseñor

Reputation: 498

There is no way to ignore database errors as far as I know, but the error you are seeing seems related to temporary keys.

You could try to optimize the database before upgrading by going to SYSTEM->MANAGEMENT->MANAGE->Companies, selecting your company and clicking on "OPTIMIZE DATABASE".

Optimize Company DB

Another option would be to temporarily disable constraints on the table that triggers the errors but I would test this before trying it on a production environment and you need to enable (rebuild) the index once you are done.

More info here: https://learn.microsoft.com/en-us/sql/relational-databases/indexes/disable-indexes-and-constraints

Upvotes: 1

Related Questions