Database Installation Error: There was a Failure in Executing the Script to Upgrade the Service Database

Database Installation Error: There was a Failure in Executing the Script to Upgrade the Service Database

There was a failure in executing the script to upgrade the Service database.

Root Cause:

This message usually indicates a rare situation where your database has some unique data conditions or database content which is unexpected by the upgrade, leading your SQL server to raise some form of SQL error. 

Unfortunately, at this point of the installation, your installation is suspect, and the upgrade is not complete. If you click OK and allow the database installation to complete, some unknown part of the upgrade will not completed. If possible, keep your system offline and waiting at this point, providing time to troubleshoot and resolve the issue. It is not recommended to use this system in production until the issue is resolved.

Workaround:

The actual SQL error has to be determined, and from the error, further actions or a resolution can be determined. 

The actual SQL error may be logged in the database installation log file created specifically for the database tasks during the installation.  

Have your local IT or system administrator locate and review Servicing Director installation log files, particularly the DBInstall.log file for a new full version upgrade or the DBInstallUpdate.log for a service pack upgrade.  For more information about the log files, review Finding the Servicing Director Installation Log File which can be selected from the Related Articles. 

Note: Not all information in the DBInstall.log or DBInstallUpdate.log files represent a relevant error message.  Also, error messages with longer text will be truncated in the log, so the log may not show the entire SQL command or error message.  Have Servicing Director Support advise on the messages found in the log. 

If the database installation fails again, submit a case through Case Management to contact support to upload your backup of the Servicing Director database for more research. Attach the installation logs and include your SQL server version when you submit your case through Case Management.

ArticleNumber:

000043712