Scenario: During the a product update the following error message is encountered.
Error Log During Update
Error in statement #1:
Error occured calling TDBAUtils.ExecSQLUsingIB:
unsuccessful metadata update
CREATE TABLE TEMP_SUMMSALES_ITEM failed
Tabl;e TEMP_SUMMSALES_ITEM already exists
Solution:
We have discovered that Norton Anti-Virus can disrupt our database update process while Norton is sending our exe files to their server for validation causing the above error message to occur. We recommend that you temporarily disable the Anti-Virus program and then re-run the installer. After you have successfully updated, re-activate your anti-virus program.