Database Setup fails in Wise Repository Manager

Article:TECH45029

Created: 2009-09-17

Updated: 2012-07-21

Article URL http://www.symantec.com/docs/TECH45029

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

Installing Wise Package Studio as a new install without prior upgrades, but the database setup fails.

Wise Package Studio 7.0 SP3 - Wise Repository Manager - Workbench Upgrade to 7.02 = "Failed":

Wise Package Studio 7.0 SP3 - Wise Repository Manager - Workbench Upgrade to 7.02 = "Failed"

Excerpt from Admin.log:

SQL Error: Column names in each table must be unique. Column name 'ProjectDirEx'
SQL Error: in table 'Projects' is specified more than once.
SQL Error: Table 'Tasks' already has a primary key defined on it.
SQL Error: Could not create constraint. See previous errors.
SQL Error: Invalid column name 'Type'.
SQL Error: Invalid column name 'Type'.
TaskRun result=-1
SQL Error: Column names in each table must be unique. Column name 'ProjectDirEx'
SQL Error: in table 'Projects' is specified more than once.
SQL Error: Table 'Tasks' already has a primary key defined on it.
SQL Error: Could not create constraint. See previous errors.

Environment

Wise Package Studio 7 (All Service Packs)

Cause

Likely due to creating a database shell for WPS databases and then pointing to the databases during the Database Setup.

Solution

Delete your databases and allow Wise Package Studio to create the databases from the start.

If the Workbench Database fails on the Last Upgrade (Wise Package Studio 7 SP3) they can do the following:

1. Close your Wise Repository Manager.
2. Open up SQL Server Management Studio. Once logged in select New Query.
3. Below the New Query button is a database field. By default it says Master. Click the dropdown and switch it to your Workbench database.
4. IN the Query field paste the Workbench Database query in it's entirety. ( The SQL Script Query is in a text file attached to this article).
5. Execute this query.
6. Reopen the Wise Repository Manager. Click on the Workbench database and select run or run all. It should then show completed.

Attachments

Workbench DB Query.txt (7 kBytes)

Legacy ID

49145