Vault Store Usage Summary : no data available to display

[hkadoun]

Hello,

When trying to display the report " Vault store Usage Summary" in SSRS, I have the following message "there is no data available to display".

But I able to see the information when using the Vault Store Usage Reporter.

Do I need to configure an option to get it?

Thanks.

[TonySterling]

What version of EV are you and what version of SQL Reporting?

[hkadoun]

I'm using EV 9.0.1 with SRS 2008 x64

I know from the compatibility chart that it's not supposed to be supported but discussion on this forum suggest that it should work.

[hkadoun]

I have run a dtrace and i have the following exception when launching "Vault Store Usage Summary" report :

29 11:16:29.766 [1204] (ReportingServicesService) <2344> EV-H {ArchiveSummaryReportDataRegion.GetDataSet} Exception: The SELECT permission was denied on the object 'view_WatchFile2', database 'EVVSVS02_3', schema 'dbo'. 

It seems to be a permission issue on the objet 'view_watchFile2'.

Anyone knows what is this object and where can I check the permissions?

thanks

[TonySterling]

Do your other reports work?

Did you create a specific account for Reporting User?

[hkadoun]

Yes others reports work.

Yes i have created a dedicated user for reporting

[JesusWept3 · Accepted solution]

i've seen this from old old old old installations when people installed EV as something other than the EVAdmin and it set the schema to a table or a view to something other than DBO

You may need to go in to Management studio, expand out Databases -> EVVSVS02_3 -> Views
Do you see "dbo.view_watchFile2" at all?
Or do you see "otherUser.view_watchFile2"?

If you see someone else owning the schema, you would have to run something like
 

USE EVVSVS02_3
EXEC sp_changeObjectOwner 'view_watchfile2', 'dbo'

But it could just as easily be that the user itself just doesn't have the correct permissions to that vault store database

[hkadoun]

I'm able to see dbo.view_watchFile2

I have checked the view and no permissions were set.

What permissions shoud I add on the view?
Also, I'm trying to figure out what's wrong on my installation process that causes this issue.

Should reports deployed before creating vault store?

[hkadoun]

So I added Select permission on  the objet dbo.view_WatchFile2 for each Vault Store Database and the Vault Store Usage Summary report is now available.

Do you have an idea why this permission is not present by default?

[hkadoun]

Anyone gets this problem?