My Oracle Support Banner

Argus Upgrade To 8.4.2 Fails In Step Changelogs/bridge/prerequisite_checks.xml::7::safety-upgrade Due to Duplicate Entries in Filestore (Doc ID 3049222.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Oracle Life Sciences Argus Safety - Version 8.4.2 and later
Information in this document applies to any platform.

Goal

Argus upgrade to 8.4.2 fails when executing bridge/841/factorydata/bulk.xml


The fix for Bug 36093338 - Upgrade fails when there is a common documentum_id is present in more than 1 case resolved the below issue:

 

Problem Description

Upgrade fails when there is a common documentum_id is present in more than 1 case. This issue was observed due to duplicate records created in ARGUS_BRIDGE.FILE_STORE table due to merging the data from CASE_NOTES_ATTACH table.

This was fixed in 8.4.2 upgrade scripts to eliminate duplicate entries in ARGUS_BRIDGE.FILE_STORE table by using the DISTINCT statement.


However, it can still fail if there are also multiple file types or filenames for the same ID.

For example on a query against the case_notes_attach table:

|COUNT(*)|DOCUMENTUM_ID |FILETYPE |
|--------|----------------|---------------------------------------------------------------------------------------------------------|
|3 |0902bc39818292b4|Literature_J1805463 |
|1 |0902bc39818292b4|Literature_J1805463.pdf

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.