Wise Package Studio 8.0 Upgrade Problem
Updated: 15 Apr 2011 | 10 comments
This issue has been solved. See solution.
Problem on upgrading WPS 7.0 SP3 to WPS 8.0
After upgrading WPS 7.0 to WPS 8.0 followed by a reboot then reconfigure the Wise Repositry Database, it seems to fail to finish the “share point database” job. The former (WPS 7.0) database was not big enough to takes it for 2-3 hours waiting to finish the job. Letting it running the whole night however NO SUCCESS.
Another test was made to deal with problem closer, with same upgrade installation on the same maschine, the difference is a new database and corresponding folder on the file system (share point) created with SUCCESS.
System Specs:
Windows Server 2003 SP2 R2 32 Bit (German)
MSSQL Server 2005 SP4 (German)
WPS 8.0 Build 8.0.69
Discussion Filed Under:
Group Ownership:
Comments
What is your question?
You have made a number of statements in your posting. If you have a question, please indicate what it is.
If your issue has been solved, please use the "Mark as Solution" link on the most relevant thread.
My question is:
How to upgrade WPS 7.0 to WPS 8.0 without getting problems by configuring the Wise Repository Database.
=monaco= machines are faster because they dont think.
Unfortunately, there is no
Unfortunately, there is no magic solution, as there are so many variables that can affect an update.
Sometimes, problems can be caused when the SQL database permissions have been interfered with by SQL DBAs, where the SQL database is hosted on a corporate server rather than a dedicated server used only by the packaging team.
Have you had any error messages? If not, how did you determine that the update had not succeeded?
Are your DB, Sharepoint and SQL database hosted on the same server or on different servers? Are you using remote terminal access to the server hosting WPS?
Did you make a backup of the SQL server prior to upgrade? If so, have you tried restoring to the new WPS database you created successfully?
Try this link which will take you into the Knowledgebase:
http://www.symantec.com/business/support/index?page=answers&startover=y&question_box=database&product_finder=Wise+Package+Studio&productselectorkey=56161&myclicker.x=0&myclicker.y=0
Some common database issues can be found in there, but if your specific scenario is not covered, and none of the suggestions help, then a call to support would be indicated. They have additional information available internally which may be able to pinpoint the solution to your problem.
If your issue has been solved, please use the "Mark as Solution" link on the most relevant thread.
The Windows and likewise
The Windows and likewise SQL user account (NT User Authentication) has a role DBO to the 3 databases - Software Manager, Wise Services , Workbench Databases.
There is no error message at all. During the installation, just after the system reboot, the dialog where the configuration of Wise Repository Database (processing share point database) is, stays for a long while until the next day without sign of progress.
We have 2 different system in our environment, these are the Test-and Productive system. The current installation problem is on the first place at the Test-system which is DB, Sharepoint and SQL-DB are on the same server. The only difference to the Productive-system is, the latter uses an SQL-Cluster. If you mean “remote terminal access” is RDP, yes.
Yes, there are existing backup of the databases. But not yet tried.
=monaco= machines are faster because they dont think.
Working out following your
Working out following your forum entries, using RDP with parameter: mstsc /console,
i have installed WPS 8.0 again and started the repository configuration tool with user “sa” (role DBA) but with the same result.
I tried also a user account with role “DBO” likewise with same result.
I have tried to restore the 3 databases then starting the repository configuration tool again, without success too.
Thanks anyway EdT, one more thing, do i need a maintenance support contract with symantec to post a call?
=monaco= machines are faster because they dont think.
I concur with EdT about
I concur with EdT about installing Wise 8.0 and running repository configuration tool to create the Wise databases as "new", then trying to import your old data from SQL DB backup files.
I have gone through 3 upgrade cycles: Wise v5.6 --> 7.0sp2, 7.0sp2 -- 7.0sp3, 7.0sp3 -->8.0. I've learned that whenever possible, never try to perform an upgrade install to an existing server --especially when going from one major version (7.0) to another (8.0). Ideally, it's best to do a completely fresh install on another server while the old one is still running, so at least you have no down time if/when something goes awry. If that isn't possible, then always backup your 3 Wise DBs, Projects & other data to a safe place, fully uninstall the old Wise, then install v8.0 as a fresh install. It's also a good idea to bring your version of SQL Server current before running the new WSP setup.
Are you configuring Windows
Are you configuring Windows NT authentication or SQL authentication?
I find that using Windows authentication and setting up WPS with the same account as the SQL server allows the whole repository update process to complete using the user login that Wise was installed with. I have never had to use alternative logins to the SQL DB to get the repository working.
Remember that WPS licensing is user specific - if you log in to the box on which WPS is installed using a different account, the product is not licensed and will not work properly.
If your issue has been solved, please use the "Mark as Solution" link on the most relevant thread.
As far as I am aware, you can
As far as I am aware, you can pay for support on a "per incident" basis.
However, have you checked out the SymWise knowledgebase for information on how to migrate SQL servers for WPS, as your best solution now may be to install WPS8 and allow it to create a new DB, then restore the contents of your old DB to the new DB.
Also, I assume you are pointing at the same Sharepoint location for the new version?
If your issue has been solved, please use the "Mark as Solution" link on the most relevant thread.
Thanks a lot! Our
Thanks a lot!
Our Test-System is now running. The Productive-System might also be the same.
=monaco= machines are faster because they dont think.
Thanks
This was great help.
Would you like to reply?
Login or Register to post your comment.