Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-7862: How to troubleshoot for SQL Database upgrade failure?

Centrify DirectAudit ,  

18 November,16 at 10:34 AM

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.

 

User-added image


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.

 
 

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.

Related Articles

 articleKB-6843: DirectAudit database upgrade fails when there are more than 64 databases articleKB-7865: Centrify Customer Advisory - Security Vulnerability with some Stored Procedures in DirectAudit database articleKB-7555: Unable to login as root after upgrade to Centrify Suite 2016 (CDC 5.3.0) articleKB-2727: How to migrate SQL databases associated with a Centrify_DirectManage Audit 3.x installation from one database server to another articleKB-0408: Troubleshooting 1 Way trust articleKB-1311: Collector unable to connect to SQL database articleKB-1956: SQL30082N Security processing failed with reason "15" ("Processing Failure"). articleKB-4602: Pre-requisite SQL server and database permissions for users articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role?