Forum Discussion

bruphi10's avatar
bruphi10
Level 3
7 years ago

Archives restored by "fsautility -b" loose their modification times

Hi all,

We have some problems  to recall FSA archives for which placeholder is still present on the Netapp filer.
We use fsautility -b for that.
Files are normally restored but the the modification time is lost. In the VaultStore we can see that this information is present with EVS  but it seems not to be restored by fsautility.
If we have a look on the properties of the restored files in Windows explorer, modification time is 01/01/1970.
We also loose initial creation date but less annoying for us.
Original files on Netapp filer ( DOT 8.2.4  7-Mode )
EV Version : 12.2.0.1437.
Upgrade from EV11 done 2 one year ago.

Any idea ?
Thanks 

Bruno

13 Replies

Sort By
  • plaudone1's avatar
    plaudone1
    Level 6
    7 years ago

    Hi Bruno,

    This was an issue fixed in 12.2.3 and was due to change in the supported schema.https://www.veritas.com/support/en_US/article.100041232

    I would suggest updating to this version  ASAP.  You should stop archiving as these files will get archived an replace the previous version of the file.  If items have been archived with this date then I would suggest opening a case so that the items can be deleted.  This will revert the item to the last version of the file which should have the correct modified date. 

    The below query run against the vault store will help to identify if any items have been archived with the incorrect modified date. 

    SELECT
    IdTransaction
    ,IdDateTime
    ,ArchivedDate
    ,cast(FolderPath as nvarchar(max)) + '\' +
    CASE
    WHEN LEFT(SavesetProperty.properties,1) = '<' and RIGHT(SavesetProperty.properties,1) = '>' THEN SUBSTRING(properties, (CHARINDEX('<filename>', properties)+10), (CHARINDEX('</filename>', properties)-(CHARINDEX('<filename>', properties)+10)))
    WHEN LEFT(SavesetProperty.properties,6) = 'FSA/3/' THEN SUBSTRING(properties, 7, CHARINDEX('/', properties, 7)-7)
    END AS Filename
    FROM
    SavesetProperty
    JOIN Saveset on SavesetProperty.SavesetIdentity = Saveset.SavesetIdentity
    JOIN Vault on Saveset.VaultIdentity = Vault.VaultIdentity
    JOIN EnterpriseVaultDirectory.dbo.Root RT on Vault.VaultID = RT.VaultEntryId
    JOIN EnterpriseVaultDirectory.dbo.ArchiveFolder AF on RT.RootIdentity = AF.RootIdentity

    WHERE IdDateTime < '1971-01-01 00:00:00'

     

    Thanks,

    Patrick 

     

    • bruphi10's avatar
      bruphi10
      Level 3
      7 years ago

      Hello Patrick

      Thank you for your quick response.
      I just upgraded EV to 12.2.3.
      Now i would like to restore my FSA archives with  correct creation/modification times.
      I think that i have to execute a script on my database to correct bad informations stored.
      I have an open case on french EV support but responses are likely tardy ( new response on September 4 !! ).
      Do you have such a script or be able to get it quickly ?
      Thanks 

      • plaudone1's avatar
        plaudone1
        Level 6
        7 years ago

        Hi,

        Good, the issue should not occur on the upgraded version.  We will need to clean up if the script return items?  If so, yes we will have to run another script to remove those items from the DB.  This will revert the item to the last item version.  If you are not Pruning items to 1 (EV keeps all versions by default) then it should be good. 

        Please send me your case ID and upload the output from the previous query to that case. I can then ensure we get it looked at from the Support side.

        Regards,

        Patrick