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!

Micros upgrade 4.9 to 5.0

Status
Not open for further replies.

sms341

Technical User
Aug 1, 2013
22
KW
Dear Experts,

I need your help to upgrade micros from 4.9 to 5.0 DB update gets failed here is the log

5/15/2016 4:44:35 PM Starting database update.
5/15/2016 4:44:35 PM Updating Database
5/15/2016 4:44:51 PM Could not execute statement. Index 'XAK1rpt_template_def' for table 'rpt_template_def' would not be unique SQLCODE=-196, ODBC 3 State="23000" File: "Scripts.sql" on line 26880, column 1
5/15/2016 4:44:51 PM **Error Updating Database**, Database Update Failed!
5/15/2016 4:44:51 PM Check Micros dm.log for errors.
 
Why not rename the database folder and let the new installation create its own DB?

and what error is on the dm.log?
 
Do you have the initial scripts folder for the micros 4.9 when it was installed , according to the logs you db is upgraded but the scripts are not running.

I used to have similar issues with 5.2 but replacing the script folder with the initial scripts seemed to sort the issue but its not a guaranted also your report folders if you can get the once from a fresh installation it might help
 
Found this hope it helps

RES 4.0 HF3 Upgrading to 4.1 fails and the DM.log or 3700d.log says, "Could not execute statement. Index 'XAK1rpt_class_def' for table 'rpt_class_def' would not be unique SQLCODE=-196, ODBC 3 State="23000" File: "Scripts.sql" on line 57255, column 1"

NOTE: This issue might also occur when attempting to upgrade from any versions of 4.0

This issue occurs when there is a report class that is created and the obj_num does not match the rpt_class_seq in the rpt_class_def table. For example, a site had a report class called "Lunch Report" that had a rpt_class_seq of 10007 and an obj_num of 10003 so to resolve the issue I went into DBISQL and ran the following statement:

"update micros.rpt_class_def
set obj_num = 10007
where rpt_class_seq = 10007"

then

"commit"

 
Also make sure you copy the original report templates from the install disc into the Res/reports folder...overwrite all files with them, before you attempt the upgrade.

My upgrade has also failed before because of this.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top