Michael Dekoning Dec 18, 2009 6:53 AM
Mark Correct
Correct Answer
You can find this information in the Replication Guide.

Mike
EPDM 2009 SP3
Like • Show 0 Likes0
Actions
- Anand Ramalingam @ Michael Dekoning on Dec 20, 2009 10:50 PM
  Mark Correct
  Correct Answer
  In the guide there is no info. about what i'm looking for.
  Like • Show 0 Likes0
  Actions
  - 1-YJ1IM @ Anand Ramalingam on Dec 21, 2009 9:17 AM
    Mark Correct
    Correct Answer
    Take the document.id from the documents table and convert it to a Hex number. The last digit of the hex number will tell you what folder in the vault the file is located in.
    Like • Show 0 Likes0
    Actions
Jeff Walters Dec 21, 2009 9:01 AM
Mark Correct
Correct Answer
What exactly do you mean by "Archive location"
Like • Show 0 Likes0
Actions
- Anand Ramalingam @ Jeff Walters on Dec 21, 2009 10:03 PM
  Mark Correct
  Correct Answer
  
  All files in a PDMWorks Enterprise file vault have their own file archive folder that is managed by the
  archive server. Inside each archive folder, all versions of a file are stored. The files are not stored using
  the same folder structure as seen by a user in a file vault view, but instead uses hexadecimal ID names
  that are maintained in the file vault database.
  
  My question is, in which DB table the hexadecimal ID name is avilable?
  Like • Show 0 Likes0
  Actions
  - 1-YJ1IM @ Anand Ramalingam on Dec 22, 2009 8:50 AM
    Mark Correct
    Correct Answer
    As I said before, you have to convert the decimal document.id field in the documents table to a hex number. So document with a document.id of 30 you would convert the decimal 30 to a hex number which would be 1E. The last digit of this number will be the folder that this file is located in. So you search the "F" folder in the Archive Location. In that folder you will find a folder with the name "0000001E". This is the folder that has all of the versions of the document with a document.id of 30.
    Like • Show 0 Likes0
    Actions
    - Anand Ramalingam @ 1-YJ1IM on Dec 23, 2009 1:24 AM
      Mark Correct
      Correct Answer
      Yes i know the way to convert the document id to hexadecimal and able to found my files in archeive loaction.My point is IN vault DB there is any table hold this record or not.I know some other system will have this record in DB.
      Like • Show 0 Likes0
      Actions
      - Joy Garon @ Anand Ramalingam on Dec 23, 2009 8:33 AM
        Unmark Correct
        Correct Answer
        Anand -
        
        The answer is no.
        
        Regards,
        Joy
        Like • Show 0 Likes0
        Actions
  - 1-A5CHD1 @ Anand Ramalingam on Dec 22, 2009 9:47 AM
    Mark Correct
    Correct Answer
    To expand on what Wayne explained:
    
    DECLARE @VaultName NVARCHAR(256) SELECT @VaultName = VaultName FROM dbo.SystemInfo ; WITH Docs ( DocumentID, Filename, HexID ) AS ( SELECT DocumentID , Filename , dbo.fnHexNumber(DocumentID, 8, 1) AS HexId FROM Documents ) SELECT Docs.DocumentID , Docs.Filename , @VaultName + '\' + RIGHT(Docs.HexID, 1) + '\' + Docs.HexID AS ArchivePath FROM Docs ORDER BY ArchivePath
    
    dbo.fnHexNumber() is a function already in the vault databases. It converts an integer to hex.
    Like • Show 0 Likes0
    Actions
    - Frank Pampreen @ 1-A5CHD1 on Dec 31, 2009 9:00 AM
      Mark Correct
      Correct Answer
      Lee,
      
      The stored procedures are all locked when ever I create a vault. How can I unlock them and see what they do. I've had to write my own procedures that probably all ready exists but I can't see them an the names are some what confusing. Also would there be any documentation to say what eacj stored procedures does?
      
      Thanks
      Frank
      Like • Show 0 Likes0
      Actions
      - 1-A5CHD1 @ Frank Pampreen on Jan 4, 2010 7:29 AM
        Mark Correct
        Correct Answer
        Frank,
        
        Email me. lyoung @ jetiprinters.com.
        Like • Show 0 Likes0
        Actions

DB record has archive stored file path

Outcomes

Related Content

Recommended Content