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.
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.