Micros upgrade 4.9 to 5.0

[sms341]

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.

 

[Jackba]

Why not rename the database folder and let the new installation create its own DB?

and what error is on the dm.log?

 

[CGN212]

Did you run the pre-convert script?

 

[sms341]

thankyou for reply

yes i have added pre-convert script
i don't want to create new DB coz i have total in current DB same i need to upgrade.

 

[Jackba]

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

 

[Jackba]

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"

 

[CGN212]

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.

 

[POSINSAM]

Should Have used the search function. I posted about this problem a while back. Solution here:

http://www.tek-tips.com/viewthread.cfm?qid=1743007