Forum Discussion

Dushan_Gomez's avatar
12 years ago

Error in executing the SIS SQL script

Hi,

I got this error:

 

Msg 208, Level 16, State 1, Line 1

Invalid object name 'view_storagereport_sharingtype'.

What should I change to make the script working again ?

SELECT VaultStoreIdentity, SharingLevel, IsNull(SUM(TotalLogicalSISParts),0) AS TotalArchivedItems, IsNull(SUM(TotalStoredSISParts),0) AS TotalSharableParts,

IsNull(SUM(TotalLogicalOrignalSize),0) AS TotalOrignalSize,

IsNull(SUM(TotalActualCompressedSize),0) AS TotalCompressedSize

FROM view_StorageReport_SharingType

GROUP BY VaultStoreIdentity, SharingLevel

  • Then you should be able to run it against the Vault Store Group (aka, Fingerprint) database.

5 Replies

  • Hi Dushan,

    What version of EV?

    You need to make sure you are running it against the Fingerprint database, not the Vault Store database.  It should be similar to the name of your Vault Store Group.

    Regards,

     

  • Then you should be able to run it against the Vault Store Group (aka, Fingerprint) database.

  • I have right click the database called EVVaultstore1 and then here's what I got:

     

    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'view_StorageReport_SharingType'.
  • I think that is just a vault store db.

    Can you run this?

    USE EnterpriseVaultDirectory

    SELECT * FROM VaultStoreGroup

    That should return the name of the fingerprint db.