'Timberline Version Changed' appears when anterraDataCenter opens

'Timberline Version Changed' appears when anterraDataCenter opens

Background

When anterraDataCenter opens, a dialog box with the title "Timberline Version Changed" appears
Each time anterraDataCenter opens, a message appears that has the following text in it: "Timberline version has recently been updated. SQL databases need to be updated to match the updated Timberline structure. If resolved then click Yes to hide the message".


Explanation

The purpose of this dialog is to alert you when anterraDataCenter detects that there has been an upgrade applied to your version of Sage Timberline Office. While anterraDataCenter will automatically add any new or updated field changes to each table during the update process, it will not delete any fields that have been removed or changed. This could lead to a situation where the SQL tables have fields that do not exist in Sage.

Resolution

Anterra recommends that you perform the following:
  1. If the Sage upgrade is a minor point or year-end upgrade (for example, 18.4 to 18.5), you do not need to do anything as the schema changes are normally very minor. Go ahead and click the 'Yes' button so that this dialog box does not appear again until Sage is upgraded once more.
  2. If the Sage upgrade is a major point (example 17.x to 18.x), you should drop all tables in the SQL Server database. Steps to perform dropping the SQL tables are listed in the article Sage 300 CRE Upgrade guide, Once tables have been dropped, run the update for anterraDataCenter either overnight or by manually running the scheduled task, and tables will be recreated and populated using the new schema. Anterra will automatically recreate all active tables during the update process.

    • Related Articles

    • Sage 300 CRE Upgrade Guide for anterraDataCenter

      Background Upgrading Sage 300 CRE to V17 or V18 can interrupt ADC syncs and disable your Windows Server Scheduled Tasks. We have prepared this guide to assist you in upgrading anterraDataCenter and preventing sync and scheduled task outages.  Please ...

    • AnterraDataCenter 5.x Prerequisites Documentation

      AnterraDataCenter™ Prerequisites Documentation Contents Required Software Components Sage ODBC Sage ODBC is required to be fully operational for each computer running the AnterraDataCenter™ tools. This requires a Sage server or client install with a ...

    • Set up SQL Data connections for Sage Crystal Reports

      32 Bit DSN Manager 1. Create a DSN pointing to the SQL Database. 2. Connect to Sage SQL Server and Instance that has anterraDataCenter database. 3. Use Windows Authentication. 4. Change the database to your anterraDateCenter database. 5. Use Defaults ...

    • Excluding Sage 300 CRE Jobs from AnterraBI

      The implementation of this feature involves the customization of customer's AnterraBI environment. Contact support for an estimate of fees and timing. How To Configure The strategy to exclude jobs from AnterraBI leverages the Sage 300 CRE, Job Setup ...

    • Anterra Version v25.2 Release Notes

      Anterra Version 25.2 Release Notes Updates to Anterra Pivot Grids These are general updates that apply to most of the grids through every module (Finance, Construction, and Service Management) Setting the Default Date for a Pivot Grid - KB Pivot ...