Content Management and Capture

Content Management and Capture

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Expand all | Collapse all

Retrieve Lost document broken(missed metadata from database)

  • 1.  Retrieve Lost document broken(missed metadata from database)

    Posted Sun January 17, 2021 07:01 AM

    FileNet Object store database(Oracle) crushed and the recent back-up was 5-days ago, the question is there is any possible way to retrieve those 5-days missing document? its in the storage as orphans document with no record in the database?



    #FileNet
    #Support
    #SupportMigration


  • 2.  RE: Retrieve Lost document broken(missed metadata from database)

    Posted Sun January 17, 2021 02:47 PM

    What type of storage?



    #FileNet
    #Support
    #SupportMigration


  • 3.  RE: Retrieve Lost document broken(missed metadata from database)

    Posted Mon January 18, 2021 08:00 AM

    Hi gerold.krommer ,

    FileSystem



    #FileNet
    #Support
    #SupportMigration


  • 4.  RE: Retrieve Lost document broken(missed metadata from database)

    Posted Mon January 18, 2021 12:09 PM

    As a first approximation you could list all files in your directory tree, probably stuff it into a database table for easier processing. The filename ist the GUID of the object. Then look up every single one in docversion. If not found -> was added since last restore time.

    This can take a while ... :-(

    There is not way that I know of to get the complete filename out of the content_referal blob (I know how to get the Centera clip ID out of that, hence my question).

    Hope this helps,

    /Gerold



    #FileNet
    #Support
    #SupportMigration