Error in Upgrade from RES 4.7 to RES 5.5 MR1

[Mirko981]

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.

 

[Moregelen]

If you have another machine on 5.5 you can copy the view from it.

 

[Mirko981]

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

 

[Mirko981]

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