Veeam Backup MP

[felyjos]

Hello,

I trying to run the Veeam Backup reports from the MP in SCOM.

Veeam Backup is version 7.0

Veeam Backup MP 6.5.0.1549

any incompatibilty?

- Capacity Planning. Protected VMs, Top/Bottom Backup Proxies are okay

- Backup and Replication Status is failing with the following error:

An error has occurred during report processing.
Query execution failed for dataset "AnalysisDS'
The EXECUTE permission was denied on the object 'Veeam_Backup_BRJobStatusGet', database 'OperationsManagerDW', schema 'dbo'.

The Backup Copy Job Overview is failing with another error:
an error occurred during report processing

any idea?

Thanks,
Dom
System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

[Vitaliy S.]

Hi Dom,

Veeam Backup is version 7.0

Veeam Backup MP 6.5.0.1549

any incompatibilty?

Actually this is the only supported configuration. Veeam MP for backup supports only Veeam B&R v7.

- Backup and Replication Status is failing with the following error:

An error has occurred during report processing.
Query execution failed for dataset "AnalysisDS'
The EXECUTE permission was denied on the object 'Veeam_Backup_BRJobStatusGet', database 'OperationsManagerDW', schema 'dbo'.

The Backup Copy Job Overview is failing with another error:
an error occurred during report processing

What about other parts of the MP? Job Views etc? Does everything work? Do you have a case ID, so I could check the reason of the failures with the dev team?

Thanks!

[Vitaliy S.]

BTW, can you please tell me how much time did pass since Backup MP has been deployed? Do you have any data in the Reporting warehouse yet? Also can you please confirm that Veeam MP was deployed successfully with no errors in Operations Manager log?

[felyjos]

Hello Vitaly,

"What about other parts of the MP? Job Views etc? Does everything work? Do you have a case ID, so I could check the reason of the failures with the dev team?"

Other parts seem working fine Vies, Jobs etc... no ticket opened yet as I have already two on-going!!! Veeam Backup and Veeam One...

Thanks,
Dom

[felyjos]

can you please tell me how much time did pass since Backup MP has been deployed? Do you have any data in the Reporting warehouse yet? Also can you please confirm that Veeam MP was deployed successfully with no errors in Operations Manager log?
Veeam Backup MP installed last week 10/24
Other reports are showing data do you have a specific to check?
Let me review the operation log again

[Vitaliy S.]

Dom,

Veeam Backup MP installed last week 10/24

Ok, thanks! This time period is enough to have some data in all reports.

Other reports are showing data do you have a specific to check?

It was just a health check. If other reports show the correct data, then it must be something with these particular ones.

Let me review the operation log again

If you do not see any errors, then contact our technical team for further investigation.

Also I would check the permissions for the dataset in question. Here is a similar example of how to do that.

Thank you!

[Alec King]

Dom,

Could you also confirm your version of SCOM, and especially your version of SQL server?

Thanks
Alec

[felyjos]

Vitaly, Alec,

SCOM 2007 R2 - 6.1.7221.110
Windows Server 2008 Enterprise Service Pack 2 - 6.0.6001.18005
SQL Server 2008 SP1 - 10.0.2531

Thanks,
Dom

[sergey.g]

Ho Dom,

Thank you very much for this information, we think we are getting closer to the root cause.

Is it possible that you are runing failing reports from within SCOM console which is launched under account with weaker permissions? Also could you check that Protected VMs report correctly display VMs which really have backups?

Also could you please try to run Verified VMs report and let me know if you encounter same error as with B&R Status?

This looks like something weird thing with your SQL permissions or SQL schemas, and I'm afraid this issue will require additional investigation, we might need to check SQL profiler and run some troubleshooting queries.

But first, your help with questions above would be highly appreciated.

Thanks.

[felyjos]

Hello,

"Is it possible that you are runing failing reports from within SCOM console which is launched under account with weaker permissions?"
- Which account is supposed to be used for the VeeamBackup reports? Is it a Veeam Account? a SCOM Account?
- Which permissions it should have?

"Also could you check that Protected VMs report correctly display VMs which really have backups?"
- Protected VMs report is working but reporting all VMs as unprotected...
Unprotected (754)
No Backup (754)
No RestorePoints (754)

"Also could you please try to run Verified VMs report and let me know if you encounter same error as with B&R Status?"
- Yes Same error ...
An error occured during report processing
Query execution failed for dataset 'AnalysisDS'
The EXECUTE permission was denied on the object 'Veeam_Backup_VmsVerification', database 'OperationsManagerDW', schema 'dbo'

This looks like something weird thing with your SQL permissions or SQL schemas, and I'm afraid this issue will require additional investigation, we might need to check SQL profiler and run some troubleshooting queries.
- It is okay to run SQL Profiler after we verified we have the correct account in question 1.

Thanks,
Dom

[felyjos]

Hello,

Last question:
if it is SQL Permissions
Which database is involved? OperationsManagerDW? OperationsManager? vSphere41?
Which account? MomDatawarehouseAccount? MomActionAccount? a Veeam account?

Thanks,
Dom

[sergey.g]

Hi Dom,

We think something strange is happening with your configuration. We need specifi permissions for running SQl stored procedures in OperationsManagerDW database and these permissions should be applied during the MP deployment, but the fact that some of you reports are working means that necessary permissions are there. We think that there is a differences in how and which SPs are called from certain reports and looks like this is causing an issue in your environment.

We really appreciate all of your help with the issue and your patience. We've built those reports to work, not to produce errors and we think we understand the root cause of these errors. We need some time to understand how to quickly solve the issue for you and then we'll investigate what happened in your environment.

The specific permission that is required is "Execute" for all Veeam Backup stored procedures (Veeam_Backup_BRJobStatusGet for instance). We think that if you are runing reports under database admin - everything should work for your environment.

I'll update your with more details.

Thanks.

[Vitaliy S.]

Dom, also please include your support case ID, as it is required by our forum rules. Thanks.

[felyjos]

Vitaly,

Case Number just opened:
00471238

Thanks,
DOm