Worksoft Community

Error when upgrading Worksoft Certify database

Wiki Table of Contents

Page Details

First published by:
Yujira
on 17 Sep 2010
Last revision by:
Yujira
on 3 Aug 2011
1 person found this article useful.

100% of people found this useful
Error when upgrading Worksoft Certify database

Issue #1: When running the apply.exe, the user gets error message: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_LogImageData_LogTestStep" (or something similar regarding the FK_log*****)

Root cause: There could be orphaned results data.

Solution: Please run the "Delete Log table orphans.sql" file from DB maintenance folder (from the Site Prep zip file in the Worksoft Certify Installation package) on the database.

 

Issue #2: When running the apply.exe, the user gets the error that the Transaction log for the database is full.

 

Root cause: The transaction log is full.

Solution: Please ask the DBA to shrink the database log. Also it is advisable to set the Autoshrink to true on the database.

 

Recent Comments

Leave the first comment for this page.
©2009-2011 Worksoft, Inc.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems