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!

Error in Upgrade from RES 4.7 to RES 5.5 MR1

Status
Not open for further replies.

Mirko981

Programmer
Jul 28, 2011
31
PE
I having a problem when execute dm -u, appears a message in DM.log

11/07/2019 6:04:28 PM Could not execute statement. Cannot use view 'v_R_employee_time_card' because it is invalid SQLCODE=-1040, ODBC 3 State="42000" File: "CreateViews.sql" on line 57705, column 1
11/07/2019 6:04:28 PM **Error Updating Database**, Database Update Failed!
11/07/2019 6:04:28 PM Check Micros dm.log for errors.
11/07/2019 6:04:28 PM Database was upgraded successfully but failed to apply micros scripts. Try to start the service and use "DM -u" to update the database.


I rebuild and Enable the view "v_R_employee_time_card" and made again dm -u, but the error appears again with the same log and view.

I deleted the view, and run dm -u and the process create the view again and the error message was the same.

How can i correct this?

Thanks for your help.

Mirko.
 
If you have another machine on 5.5 you can copy the view from it.
 
Hi Morgelen, thank you for your answer. I'll do it.
I have a question, after copied the view, i must do dm -u, ?
Thanks.
Mirko
 
Hi Morgelen,
I copied the view from another server with 5.5 and after do the upgrade, the message is the same.
The last upgrade was yesterday using cmd window and opened as Administrator and the message is different but not complete the upgrade.

02/10/2019 12:27:07 PM Could not execute statement. Cannot use view 'v_R_employee_time_card' because it is invalid SQLCODE=-1040, ODBC 3 State="42000" File: "CreateViews.sql" on line 57705, column 1
02/10/2019 12:27:07 PM **Error Updating Database**, Database Update Failed!
02/10/2019 12:27:07 PM Check Micros dm.log for errors.
02/10/2019 12:27:07 PM Database was upgraded successfully but failed to apply micros scripts. Try to start the service and use "DM -u" to update the database.
02/10/2019 12:29:53 PM DM Return Code = 1


I review the file createviews.sql and the line 57705 is call micros.sp_ValidateViews();
The view v_r_employee_time_card is disabled.

Inside the file Createviews.sql, is the code to create the view, i did manually and make the upgrade, but the upgrade cannot complete.
The problem is the database?
I made a Clear all Totals, but the same error.

Thanks for your help

Mirko


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top