Applies to: All version of Centrify DirectAudit

Question:

How to troubleshoot for SQL Database upgrade failure?

Answer:

In order to investigate the issue during the SQL Database upgrade, we will need to analyze the upgrade logs with the following steps:

1. To retrieve the upgrade log files, login as the user who was performing the Database upgrade

2. Access to the %temp% folder, search for the file that named ‘DirectManage_Audit_Setup_YYYY_MM_DD.log' (See screenshot below)

3. Send it back to Centrify Support to further investigate the issue.

OR

If you are upgrading the Database manually as follow:

1. Run setup.exe / database, then generate the upgrade script

2. Manually execute each of the files in SQL Management Studio (User has to be a member of sysadmin role to perform manual upgrade)

3. ALWAYS upgrade the Audit Store database first, then the Management Database at the end

4. If the manual upgrade fails as well, please help capture a screenshot of the error message and send it back to Centrify Support to further investigate.