Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MICROS 3700 4.8 to 5.7 upgrade problem

Status
Not open for further replies.

themicrosman

IS-IT--Management
Jul 30, 2013
80
US
I am trying to upgrade an old MICROS 4.8 database to MICROS 5.7. I have run the preconvert scripts, against the database. When I try to install the database during the 5.7 installation it fails. Here is what the DM log says. If anyone has any ideas, I would be much appreciative.

17/07/2018 13:30:22 Converting database: C:\Micros\Database\data\Rebuilt.mbz
17/07/2018 13:30:22 Restoring Micros backup file C:\Micros\Database\data\Rebuilt.mbz
17/07/2018 13:30:22 Decompressing backup file.
17/07/2018 13:30:25 Restoring passwords and encryption keys.
17/07/2018 13:30:28 Restoring passwords and encryption keys complete.
17/07/2018 13:30:39 Rebuilding database file
17/07/2018 13:30:39 C:\MICROS\Database\Data\Rebuild\MICROS.DB
17/07/2018 13:30:39 Please wait...rebuilding definitions and data will take
17/07/2018 13:30:39 a while. The actual time is dependant on the size of
17/07/2018 13:30:39 the database and the computer hardware configuration.
17/07/2018 13:30:39 Find the collation compatible with current operating system.
17/07/2018 13:30:51 The compatible collation: 1252LATIN1 and the compatible charset: windows-1252
17/07/2018 13:33:58 The old db collation: 1252LATIN1 and its charset: windows-1252
17/07/2018 13:34:11 Starting newly created database
17/07/2018 13:34:16 Completing Rebuild
17/07/2018 13:34:26 Stopping database
17/07/2018 13:34:35 Completed rebuilding of the database
17/07/2018 13:34:36 Database rebuild success.
17/07/2018 13:34:37 Starting database update.
17/07/2018 13:34:46 Starting Database.
17/07/2018 13:35:46 Database Started.
17/07/2018 13:35:48 Updating Database
17/07/2018 13:36:00 Could not connect to the database. Database server not found SQLCODE=-100, ODBC 3 State="08001"
17/07/2018 13:36:00 **Error Updating Database**, Database Update Failed!
17/07/2018 13:36:00 Check Micros dm.log for errors.
17/07/2018 13:36:00 Database was upgraded successfully but failed to apply micros scripts. Try to start the service and use "DM -u" to update the database.
 
Going from 4.x to 5.6 or higher does require preconvert, not sure why it would fail if you have done that step. I've seen the same issue but it was due to not running preconvert.
 
I would try upgrading the v4 db to mr11 first.
Clear totals and then rebuild
make a backup and migrate to the v5 box
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top