In this blog post, let’s learn about the error message “1249 Insert into log-table-name log table failed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1249 Insert into log-table-name log table failed.
Reason for the Error
Insert into one of the translation log tables has failed. The log-table-name specifies the translation log table where the insert failed.
Solution
RECOVER must be used to recover from the UPGRADE operation failure. Before attempting the UPGRADE operation again, the failure of insert intolog-table-name has to be corrected
