Sage 500 upgrade utility fails is yet another common trouble many subscribed users of this software application face. There are some technical glitches that trigger this error message when you are trying to upgrade your Sage 500 ERP software app.
Table of Contents
When the user encounter Sage 500 upgrade utility fails error message, the error log will point towards the given two notifications:
- While loading the SQL Script File pre_app.sql Error – generateprocessspDF_FixPendBatchForDBUpgrade
- The Microsoft SQL Server Native Customer 11.0 Error 3604: The process ‘sys.sp_dbcmptlevel’ cannot be implemented within an operation.
How to Troubleshoot Sage 500 Upgrade Utility Fails?
Solution 1: Ensure to run the spDF_FixPendBatchForDBUpgrade script prior you decide to run the update straight from SQL Server below an account with system administrator level authorizations.
Solution 2: Ensure you update the Sage 500 ERP database ready as contrasting to creating a backup copy, reinstating to new sql server, and running the Sage 500 Upgrade Utility counter to that database. For updating your Sage 500 ERP database, you need to perform the given methods in the order as stated below:
- Broadcast all open batches in the computer and if is quite essential try to generate batches in Account Receivables, Process Invoices and Choose Consignments, and then broadcast.
- Generate backups and record of all types of databases (be it app, sys, iapp, pt or pl).
- Reinstate the databases to a check server or databases (ensure to use unique name) so the fabrication setting is not impacted. Assess the Sage 500 ERP Installation and related System Configuration Tutorial for guidelines to backup and reinstate the databases and use of the Sage 500 ERP Database Synchronization Utility.
- Open DBCC CHECKDB in contrast to the databases and confirm their uniformity.
- Reconstitute indexes on the databases (DBCC DBREINDEX) provided not done lately. This strengthens index reliability.
- Run DBCC UPDATEUSAGE in contrast to the databases. This will upgrade the in use and free space details for the databases.
- Update Microsoft SQL Server if required. Follow online instructions and once it is updated repeat step 4 till 6.
- Validate whether there is sufficient free database space in the databases in line with the guidelines in the Sage 500 ERP Resource Guide.
- Confirm that the temp db database has been apportioned 1 GIG least or 1/3rdsize of the application database, whichever is greater, and right growth parameters.
- Set the appropriate database selections (Form/Upgrade Statistics, Torn Page Recognition and Compatibility Level).
- Ensure you set the right database recovery model.
- If the application database is massive (exceeding 10 GB) but the data capacities are not unique, implement the sp_spaceused ‘tciMaintAuditLog’ and sp_spaceused ‘tciDBActivityLog’ queries in contrast to the application database.
- In case, the audit journal is remarkably massive, try removing some of the doings by choosing the Audit Journal option in the delete attribute in each component.
- In case, the database action journal is extremely outsized, eliminate any delinquent rows that may have been slotted in.
- Back up the databases provided you performed any modifications.
- Update the databases using the Sage 500 ERP Database Update tool. If required, install latest databases with the Sage 500 ERP Express Install tool. Ensure to choose the test server or databases for update.
- Back up any instinctive tailored Crystal logs on the customer machine, they can be easily overwritten.
- Install the latest Sage 500 ERP customer version on a single customer system and cross-check the latest databases to authenticate the outcomes of the update.
- Run DBCC CHECKDB on the updated databases and cross-check the results.
- In contrast to the updated database(s), reconstitute indexes.
- Check the functionality on the updated databases with the updated customer computer.
- Try taking the backup of databases, reinstate them to the fabrication server or fabrication database fixed on the subordinate Microsoft SQL Server, bring into line with databases using the Sage 500 ERP Database Synchronization tool, cross-check them once more with the updated customer, and then continue to update the rest of the customer computers.
Looking for Sage 500 assistance?