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


Issue



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


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


Terms of use for this information are found in Legal Notices