History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-2636
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Robin Shen
Reporter: steve fahlbusch
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

(potential user error ) - Rolling back from QB 6.0.27 to 5.0.37

Created: 15/Feb/16 02:55 PM   Updated: 01/Dec/16 08:43 AM
Component/s: None
Affects Version/s: 6.0.27
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
Environment: AIX 7100-03-05-1524


 Description  « Hide
We are in the process of upgrading from QB 5 to QB 6. We had discovered that we had never tested roll back to a previous level to QB so we added that, so that we would have this documented in the event of issues of upgrading Production.

My test started with upgrading 5.0.37 in test to 6.0.27. (all went well).

Attempted the rollback info on site: http://wiki.pmease.com/display/QB60/Backup+and+Restore+Data

 I had a backup.zip file created in 5 prior to the upgrade - so used that instead of step 1.

Did steps 2 thru 7 (with exception of 6)

Did not do step 8 as I didn't think this would apply, but we do have this defined in the hibernate.properties:
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url=jdbc:jtds:sqlserver://CORPSC2HQTTC007:4787/QuickBuild_Test;instance=HQ8

So will we need to delete the instance prior to doing the restore?


9.Open a command line window, switch to directory /quickbuild-new/bin, and run command restore.(bat|sh) /quickbuild-old/backup.zip_ to migrate and restore data of old QuickBuild. - ran this got fatal java errors where I could not bring up old or new version.


Is this the case where I need to delete the old instance, create a new one the restore?

Thanks,
-steve

 All   Comments   Work Log   Change History      Sort Order:
Robin Shen [16/Feb/16 12:40 AM]
Please follow step8 to recreate the database before running the restore tool. Also make sure you are running the restore tool under the old 5.0.37 directory.