fbpx

DPM Reporting – An error has occurred during report processing

I hit an issue on launching the DPM reporting.  The DPM is functioning well except the reporting.  It’s the issue of the SQL Reporting settings.

image

It stated as :

An error has occurred during report processing. (rsProcessingAborted).
Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)
Invalid object name ‘vw_DPM_Replica’.

Steps taken to resolve :

  • Launch the Reporting Services Configuration Manager in the DPM

image

  • Select the Report Manager URL on the left panel
  • Click on the URL on the right panel

image

  • Double-click on the DPMReporterDataSource

image

  • The Connection string is missing.
  • Minimize this screen

image

  • Create a file call dbtest.udl on the desktop (it’s a build in Windows)
  • Double click on it.

image

  • Once the Data Link Properties launch, Select the server name (using the drop down)
  • Use the Windows NT integrated security for the credential
  • Select the database (using the drop down)
  • Click Test Connection

image

  • Click OK once it’s successful

image

  • Right-click on the dbtest.udl and open with notepad

image

  • Copy the text from “Intergrated ….. “till the end of the line

image

  • Maximize the DPMReporterDataSource
  • Paste the copied text into the Connection string.
  • Click on Test Connection (may request to key in password again)
  • Once successful, click Apply.

Launch the DPM reporting with no issue occurred.

keyword : DPM, SQL, SRSS, Reporting Services, rsErrorExecutingCommand, rsProcessingAborted, dataset, query execution failed, invalid object name

This post first appeared on Systems Center - Virtualization. Read the original article.