Did 7.40 have an "app" and "sys" database still? Sage 500 used to have two databases, e.g. mas500_app and mas500_sys. Seems like you are missing the sys DB maybe?

Darrick

I have _app, _iapp, _pl, _pt, and _sys databases.  I manually created tciSystemDatabase inside of _app, then the Sync tool began throwing errors of columns not existing in the table, so I assume the table should exist in the _app database.  When we upgraded to 7.4, we kept our database names of best_* instead of mas500_*, I will need to see if this could be part of the problem as well.

I have _app, _iapp, _pl, _pt, and _sys databases.  I manually created tciSystemDatabase inside of _app, then the Sync tool began throwing errors of columns not existing in the table, so I assume the table should exist in the _app database.  When we upgraded to 7.4, we kept our database names of best_* instead of mas500_*, I will need to see if this could be part of the problem as well.

I suggest you re-synchronize your DBs, and specify the other databases in the Sync tool. Also, you could try profiling the upgrade and see what the statement is that references tciSystemDatabase.

Darrick

RKL eSolutions

Profiling the upgrade process, good idea, I do this all the time and never gave it a thought.  Thank you.

The solution was to only select the _app database and everything went well