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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot install Micros RES 3700 5.7 - Rebuild Failed - SQL error: Incorrect or missing encryption key

Status
Not open for further replies.

chipmotley

Technical User
Jun 21, 2018
17
US
Hello, my current Micros Server is version 5.2 3700 with EM installed.
I have a new server which I am installing Micros 5.7 too.
On the new server, I installed the Micros prerequisite and then installed Micros 5.7 (I have NOT installed EM)
During the Micros portion of the install, I chose to update the 5.2 database using a Backup from the night before (MICROS_2018_12_02_04_34.mbz5 but the Database failed to rebuild. (see results from the DB Manager below)

12/2/2018 1:35:17 PM Client trust passphrase change succeeded.
12/2/2018 3:24:30 PM Converting database: D:\Micros\Database\data\MICROS_2018_12_02_04_34.mbz5
12/2/2018 3:24:30 PM Restoring Micros backup file D:\Micros\Database\data\MICROS_2018_12_02_04_34.mbz5
12/2/2018 3:24:30 PM Decompressing backup file.
12/2/2018 3:24:36 PM Restoring passwords and encryption keys.
12/2/2018 3:24:36 PM Restoring passwords and encryption keys complete.
12/2/2018 3:24:47 PM Rebuilding database file
12/2/2018 3:24:47 PM D:\MICROS\Database\Data\Rebuild\MICROS.DB
12/2/2018 3:24:47 PM Please wait...rebuilding definitions and data will take
12/2/2018 3:24:47 PM a while. The actual time is dependent on the size of
12/2/2018 3:24:47 PM the database and the computer hardware configuration.
12/2/2018 3:24:47 PM Find the collation compatible with current operating system.
12/2/2018 3:24:55 PM The compatible collation: 1252LATIN1 and the compatible charset: windows-1252
12/2/2018 3:25:10 PM ** Rebuild Failed! **
12/2/2018 3:25:10 PM Check Micros DMRebuild.log for errors.

DMRebuild:

SQL Anywhere Unload Utility Version 17.0.8.4148
Connecting and initializing
***** SQL error: Incorrect or missing encryption key

After this Fail, I created a new backup at the live store backing up the database plus the passwords and keys. I re-ran the rebuild on the new server from the cmd line (DM -U d:\micros\database\data\micros.db) Unfortunately, I received the same error message (below). I hope someone can help me with this error. I am confused because during the first restore the DB Manager finds the password and encryption keys but fails moments later during the rebuild process. Should I have installed EM before I tried to rebuild the database?



12/4/2018 8:44:59 AM DM Return Code = 1
12/4/2018 9:22:07 AM DM Return Code = 0
12/4/2018 9:32:52 AM Converting database: d:\micros\database\data\micros.db
12/4/2018 9:32:55 AM Restoring Micros backup file d:\micros\database\data\micros.db
12/4/2018 9:32:55 AM Restoring d:\micros\database\data\micros.db
12/4/2018 9:33:42 AM Rebuilding database file
12/4/2018 9:33:42 AM D:\MICROS\Database\Data\Rebuild\MICROS.DB
12/4/2018 9:33:42 AM Please wait...rebuilding definitions and data will take
12/4/2018 9:33:42 AM a while. The actual time is dependant on the size of
12/4/2018 9:33:42 AM the database and the computer hardware configuration.
12/4/2018 9:33:42 AM Find the collation compatible with current operating system.
12/4/2018 9:33:52 AM The compatible collation: 1252LATIN1 and the compatible charset: windows-1252
12/4/2018 9:34:07 AM ** Rebuild Failed! **
12/4/2018 9:34:07 AM Check Micros DMRebuild.log for errors.

DMRebuild log:

SQL Anywhere Unload Utility Version 17.0.8.4148
Connecting and initializing
***** SQL error: Incorrect or missing encryption key
 
Try rotating the encryption keys through DB , then rebuild
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top