Known Issue with Collaborator v.8 Upgrade and Oracle:
Known Issue with Collaborator v.8 Upgrade and Oracle:
If you plan to upgrade to Collaborator v.8, and your existing server is configured with an Oracle database, there is a known issue to address related to duplicate metadata of external defect names.
You will need to follow these steps BEFORE YOU UPGRADE to ensure a successful upgrade of your Oracle database instance.
1. During an off-peak time, have your DBA perform a backup of your Collaborator instance using your native Oracle database backup utility.
(The migration dump file backup approach won’t work because of this known issue so best to use the native Oracle backup method.)
2. When your backup is complete, login to the Collaborator server as admin.
3. Go to <YourServerURL>/diagnostics?diagnostic=fixDuplicateMetadataValues.
4. When the diagnostic is done, save your screen by doing this: Right-Click > SaveAs > {MyHTMLFile1}.htm (of type Webpage, HTML Only)
5. If Result shows Success for all values tested, you can proceed to upgrade your server as described here:
6. If Result shows Failure for some/all values tested, re-run the "Fix Duplicate Metadata Values" Diagnostic.
7. When the diagnostic is done, save your screen by doing this: right-Click > SaveAs > {MyHTMLFile2}.htm (of type Webpage, HTML Only)
8. If Result shows Failure for some/all values tested, send the latest html file to support@smartbear.com.
9. SmartBear Support will contact you regarding your case and work directly with you and your DBA to manually reconcile the duplicate metadata
before you proceed with your upgrade.
