Micros Database restore

[Jackcmann]

Hi

I have installed micros res v4.8 using the following procedure.
V4.0 prerequisite
V4.0 GR
V4.1 prerequisite
V4.3 prerequisite
V4.6 prerequisite
V4.8 cumalitive
I installed this using the shell database.
My question is, I have a v4.8 micros.db copy which I want to restore. I do not have a micros.mbz copy.
Is this possible, and how do I do it ?

 

[CathalMF]

unlikely but you never know.

The mbz contains encryption keys used to access the database. If your micros.db backup used the same encryption keys as the shell database then it might let you restore it.

Create a MBZ backup of the shell database. Open the MBZ with 7zip (MBZ is just an archive). Replace the shell micros.db in the mbz with your 4.8 micros.db.

Try and restore it.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[Jackcmann]

Hi

Thanks for the reply. I have done what you have suggested. The database started up successfully. I then tried to access the database manager, but an error now pops up.

Database Error: Unknown user name or password.
[Sybase][ODBC Driver][Adaptive Server Anywhere]Invalid user ID or password
Alias: micros.

 

[CathalMF]

Ya so basically the encryption keys that get restored contain credentials to access the database.
You have restored invalid credentials so the Micros applications cannot connect to the database.

Do you have any idea that the MICROS database user and the DBA database user passwords were?

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[Jackcmann]

Yes I have the database user and password.

 

[CathalMF]

Ok heres a bit of a mad suggestion but it might work.

1. Restore the shell database again.
2. Open the DatabaseManager -> Change the DBA and Micros user passwords to the same as on your real database.
3. Backup the shell database with the new passwords.
4. Swap out the Micros.db again.
5. Restore the new mbz
6. Now the registry passwords for DBA and Micros should match your live database.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[Jackcmann]

Thank You CathalMF

I have managed to get the database up. However when I start POS Operations it pops up an error. OpsDbs.cpp

 

[CathalMF]

You will need to look into the 3700d log for more information.
d:\micros\res\pos\etc\3700d.log

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[Jackcmann]

Hi

I am getting the following error when starting "RES"

opsdbs.cpp (9794):
UNEXPECTED DATABASE ERROR
Call Failed

I have inserted the 3700d.log file. Please could you assist with this.

Tue Dec 22 15:18:36 2015 | MICROSV4 | OPS | 0 | OPS.exe Version 4.8.4.3620 Built Apr 10 2012 22:27:52 |
Tue Dec 22 15:18:36 2015 | MICROSV4 | OPS | 0 | UI running on thread 5608 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | Periphs | 0 | PeriphsCreateFile(): Failed to open device driver '\\.\PCWSAPI.VXD' |
Tue Dec 22 15:18:37 2015 | MICROSV4 | OPS | 0 | PCWSAPI_APIEventHandlerWrapper running on thread 5732 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | OPS | 0 | ops_main running on thread 5516 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | OPS | 0 | ops_beeper_thread running on thread 3268 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | 3700 Print Manager Version 4.8.3.2655 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PINpad | 0 | IPP | FinalConstruct (Failed to get settings from registry) |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | Built Apr 12 2010 23:33:28 |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | PrintManagerTask thread started |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | PSM 0 thread ready |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | PSM 1 thread ready |
Tue Dec 22 15:18:37 2015 | MICROSV4 | PManager.OPS | 0 | PSM 2 thread ready |
Tue Dec 22 15:18:37 2015 | MICROSV4 | POStoKDS.dll | 0 | PosToKds.dll version = 4.8.3.2655 |
Tue Dec 22 15:18:38 2015 | MICROSV4 | MDSResDbsAdptr | 0 | MDSResDbsAdapter.Dll version [4.8.4.3620] |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:38 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:39 2015 | MICROSV4 | RESDBS | 0 | Error Report: color_combo_seq out of synch |
Tue Dec 22 15:18:44 2015 | MICROSV4 | OPS | 0 | Setting version on download: 1D13CBB-4532C0C0 |
Tue Dec 22 15:18:44 2015 | MICROSV4 | CAAdapter | 0 | CaAdapter - CLogInterface initialized OK |
Tue Dec 22 15:18:44 2015 | MICROSV4 | CAAdapter | 0 | CaAdapter.Dll version [4.8.3.2655] |
Tue Dec 22 15:18:45 2015 | MICROSV4 | CCS | 0 | CCS starting up |
Tue Dec 22 15:18:45 2015 | MICROSV4 | CCS | 0 | Failed to read init data from the registry. |
Tue Dec 22 15:18:46 2015 | MICROSV4 | Periphs | 0 | Inside CPeriphsCommandThread:penOposDevice |
Tue Dec 22 15:18:48 2015 | MICROSV4 | Periphs | 0 | Inside CPeriphsCommandThread:penOposDevice |
Tue Dec 22 15:18:48 2015 | MICROSV4 | Periphs | 0 | OposRearDisplayOpen() 'DM-D202': opos_reardisplay->Open() failed |
Tue Dec 22 15:18:48 2015 | MICROSV4 | OPS | 0 | idle_thread() running on thread 956 |
Tue Dec 22 15:18:48 2015 | MICROSV4 | OPS | 0 | EuroScale Init Did not Work 2147746132 |
Tue Dec 22 15:18:48 2015 | MICROSV4 | OPS | 0 | Reloading UI: Downloading theme files |
Tue Dec 22 15:18:48 2015 | MICROSV4 | OPS | 0 | Reloading UI: ConfigureOpsDisplay |
Tue Dec 22 15:18:49 2015 | MICROSV4 | OPS | 0 | Reloading UI: UnLoadThemes |
Tue Dec 22 15:18:49 2015 | MICROSV4 | OPS | 0 | Reloading UI: LoadTheme |
Tue Dec 22 15:18:49 2015 | MICROSV4 | OPS | 0 | Reloading UI: LoadThemeForegroundColors |
Tue Dec 22 15:18:49 2015 | MICROSV4 | OPS | 0 | Finished Reloading UI |

 

[CathalMF]

The database might be slightly out of sync with your software version.
Open the database manager and do a database update. They will upgrade your database to the version compatible with your software.
NOTE: It only upgrades. If your database is newer than your software version then you will need to manually update the software.

Have a look in the database table rest_status or maybe its rest_def. One of them has the version of the database. Compare it to your software version.



Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/