none
DPM reports configuration file or table? RRS feed

  • Question

  • At some point DPM reporting stopped working.

    Checked sql reporting server. that looks fine, and I can browse the reportingserver and reports site.

    I can also run a report to get te latest information, from this site.

    Reporting in DPM isn't working. I would like to know were DPM is searching for it's reporting site.

    Is there a configuration file or maybe a table inside the DPM database were this information is stored?

    Thanks for your reply.


    • Edited by mheijkant Tuesday, November 13, 2012 6:21 PM
    Tuesday, November 13, 2012 6:15 PM

All replies

  • Hi,

    What is the error you get when trying to generate a report in DPM Ui ?

    Have you checked this site for the error ?

    Troubleshooting Reporting Issues
    http://technet.microsoft.com/en-us/library/ff399667.aspx

    The Configuration file is C:\Program Files\Microsoft DPM\SQL\MSRS10.MSDPM2010\Reporting Services\ReportServer\rsreportserver.config 


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, November 13, 2012 7:26 PM
    Moderator
  • When opening de DPM reporting menu following error appears:

    DPM could not connect to SQL Server Reporting Services.
    Restart SQL Server Reporting Services, and then try the operation again.
    ID: 3013

    The lines from rsreportserver.config look like the ones below. Are these correct?

    I have my doubts. Or what else should I look for.

    <URLReservations>
            <Application>
                <Name>ReportServerWebService</Name>
                <VirtualDirectory>ReportServer</VirtualDirectory>
                <URLs>
                    <URL>
                        <UrlString>http://+:8080</UrlString>
                        <AccountSid>S-1-5-20</AccountSid>
                        <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>
                    </URL>
                </URLs>
            </Application>
            <Application>
                <Name>ReportManager</Name>
                <VirtualDirectory>Reports</VirtualDirectory>
                <URLs>
                    <URL>
                        <UrlString>http://+:8080</UrlString>
                        <AccountSid>S-1-5-20</AccountSid>
                        <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>
                    </URL>
                </URLs>
            </Application>
        </URLReservations>

    Tuesday, November 13, 2012 8:26 PM
  • Well,  I can say that the above output is incomplete, it should look like the following.  I get the same ID: 3013 error as you if I truncate my .config file to look like yours.

    GOOD DPM2012 version of rsreportserver.config looks like the below.

    <?xml version="1.0"?>
    <Configuration>
      <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAhlCDGz09rUuumIpQezFimAQAAAAiAAAAUgBlAHAAbwBy
    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAAAb+k33qXbHeWcvHP+b+HIEAAAAA
    BIAAAKAAAAAQAAAAc/fjd7kNpm2YUEhdN+ZjoggBAACjxv686eyDU9JwZojL3hZwdKD3JxCpQHuY
    vQugjIisNtcyD3v3Nd1REahIBjVE727yHt2cE594K+ml5WBWgZC6crWVIg/wjwyIW/Qyz0HECPqG
    j0ztTucDuRbyOoEhvD3VkhpBymyRFVBLQQ9CwwdW4PLhIXLF0HiDACMAJ/3l32IQiYjDCCmF4R50
    ElsYlsiAbSJ6J1gENyzps+TxmRi2sHFFV5ZpF+zCa5JiNWAqopcR2mg9RgX1nVamUQ/7F6G+aoIK
    25mQmliLuJGvhjudthH07oHNjyteubR6YASBe6gDY4YbF9zL5PPGbHsGkJSQIWrAjL5lySQG0fsc
    Lx5DJNspQsrR6MQUAAAAFHuWhmQ+mtgrkm1HvGmPm0w7lY8=</Dsn>
      <ConnectionType>Default</ConnectionType>
      <LogonUser>
      </LogonUser>
      <LogonDomain>
      </LogonDomain>
      <LogonCred>
      </LogonCred>
      <InstanceId>MSRS10_50.MSDPM2012</InstanceId>
      <InstallationID>{c9bdc508-c445-4b3b-b166-d751f466c50e}</InstallationID>
      <Add Key="SecureConnectionLevel" Value="0" />
      <Add Key="CleanupCycleMinutes" Value="10" />
      <Add Key="MaxActiveReqForOneUser" Value="20" />
      <Add Key="DatabaseQueryTimeout" Value="120" />
      <Add Key="RunningRequestsScavengerCycle" Value="60" />
      <Add Key="RunningRequestsDbCycle" Value="60" />
      <Add Key="RunningRequestsAge" Value="30" />
      <Add Key="MaxScheduleWait" Value="5" />
      <Add Key="DisplayErrorLink" Value="true" />
      <Add Key="WebServiceUseFileShareStorage" Value="false" />
      <!--  <Add Key="ProcessTimeout" Value="150" /> -->
      <!--  <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
      <!--  <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
      <!--  <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
      <!--  <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
      <Add Key="WatsonFlags" Value="0x0428" />
      <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException" />
      <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException" />
      <URLReservations>
        <Application>
          <Name>ReportServerWebService</Name>
          <VirtualDirectory>ReportServer_MSDPM2012</VirtualDirectory>
          <URLs>
            <URL>
              <UrlString>http://+:80</UrlString>
              <AccountSid>S-1-5-20</AccountSid>
              <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>
            </URL>
          </URLs>
        </Application>
        <Application>
          <Name>ReportManager</Name>
          <VirtualDirectory>Reports_MSDPM2012</VirtualDirectory>
          <URLs>
            <URL>
              <UrlString>http://+:80</UrlString>
              <AccountSid>S-1-5-20</AccountSid>
              <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>
            </URL>
          </URLs>
        </Application>
      </URLReservations>
      <Authentication>
        <AuthenticationTypes>
          <RSWindowsNegotiate />
          <RSWindowsNTLM />
        </AuthenticationTypes>
        <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
        <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
        <EnableAuthPersistence>true</EnableAuthPersistence>
      </Authentication>
      <Service>
        <IsSchedulingService>True</IsSchedulingService>
        <IsNotificationService>True</IsNotificationService>
        <IsEventService>True</IsEventService>
        <PollingInterval>10</PollingInterval>
        <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
        <MemorySafetyMargin>80</MemorySafetyMargin>
        <MemoryThreshold>90</MemoryThreshold>
        <RecycleTime>720</RecycleTime>
        <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
        <MaxQueueThreads>0</MaxQueueThreads>
        <UrlRoot>
        </UrlRoot>
        <UnattendedExecutionAccount>
          <UserName>
          </UserName>
          <Password>
          </Password>
          <Domain>
          </Domain>
        </UnattendedExecutionAccount>
        <PolicyLevel>rssrvpolicy.config</PolicyLevel>
        <IsWebServiceEnabled>True</IsWebServiceEnabled>
        <IsReportManagerEnabled>True</IsReportManagerEnabled>
        <FileShareStorageLocation>
          <Path>
          </Path>
        </FileShareStorageLocation>
      </Service>
      <UI>
        <ReportServerUrl>
        </ReportServerUrl>
        <PageCountMode>Estimate</PageCountMode>
      </UI>
      <Extensions>
        <Delivery>
          <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
              <FileShareConfiguration>
                <ExcludedRenderFormats>
                  <RenderingExtension>HTMLOWC</RenderingExtension>
                  <RenderingExtension>NULL</RenderingExtension>
                  <RenderingExtension>RGDI</RenderingExtension>
                </ExcludedRenderFormats>
              </FileShareConfiguration>
            </Configuration>
          </Extension>
          <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
              <RSEmailDPConfiguration>
                <SMTPServer>
                </SMTPServer>
                <SMTPServerPort>
                </SMTPServerPort>
                <SMTPAccountName>
                </SMTPAccountName>
                <SMTPConnectionTimeout>
                </SMTPConnectionTimeout>
                <SMTPServerPickupDirectory>
                </SMTPServerPickupDirectory>
                <SMTPUseSSL>
                </SMTPUseSSL>
                <SendUsing>2</SendUsing>
                <SMTPAuthenticate>
                </SMTPAuthenticate>
                <From>
                </From>
                <EmbeddedRenderFormats>
                  <RenderingExtension>CSV</RenderingExtension>
                </EmbeddedRenderFormats>
                <PrivilegedUserRenderFormats>
                </PrivilegedUserRenderFormats>
                <ExcludedRenderFormats>
                  <RenderingExtension>HTMLOWC</RenderingExtension>
                  <RenderingExtension>NULL</RenderingExtension>
                  <RenderingExtension>RGDI</RenderingExtension>
                </ExcludedRenderFormats>
                <SendEmailToUserAlias>True</SendEmailToUserAlias>
                <DefaultHostName>
                </DefaultHostName>
                <PermittedHosts>
                </PermittedHosts>
              </RSEmailDPConfiguration>
            </Configuration>
          </Extension>
          <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">
            <MaxRetries>3</MaxRetries>
            <SecondsBeforeRetry>900</SecondsBeforeRetry>
            <Configuration>
              <DocumentLibraryConfiguration>
                <ExcludedRenderFormats>
                  <RenderingExtension>HTMLOWC</RenderingExtension>
                  <RenderingExtension>NULL</RenderingExtension>
                  <RenderingExtension>RGDI</RenderingExtension>
                </ExcludedRenderFormats>
              </DocumentLibraryConfiguration>
            </Configuration>
          </Extension>
          <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider" />
        </Delivery>
        <DeliveryUI>
          <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
            <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
            <Configuration>
              <RSEmailDPConfiguration>
                <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
              </RSEmailDPConfiguration>
            </Configuration>
          </Extension>
          <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider" />
        </DeliveryUI>
        <Render>
          <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering" Visible="False" />
          <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="False" />
          <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering" Visible="False" />
          <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="False" />
          <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering" Visible="True" />
          <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="False" />
          <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="True" />
          <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="True" />
          <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="True" />
          <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="False" LogAllExecutionRequests="false" />
          <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering" Visible="False" />
          <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="False" />
        </Render>
        <Data>
          <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions" />
          <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw" />
          <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase" />
          <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions" />
        </Data>
        <SemanticQuery>
          <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
              <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
          </Extension>
          <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
              <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
          </Extension>
          <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
              <EnableMathOpCasting>False</EnableMathOpCasting>
            </Configuration>
          </Extension>
          <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
              <EnableMathOpCasting>True</EnableMathOpCasting>
              <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>
              <EnableUnistr>False</EnableUnistr>
              <DisableTSTruncation>False</DisableTSTruncation>
            </Configuration>
          </Extension>
          <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
            <Configuration>
              <EnableMathOpCasting>True</EnableMathOpCasting>
              <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>
            </Configuration>
          </Extension>
          <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling" />
        </SemanticQuery>
        <ModelGeneration>
          <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" />
          <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" />
          <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" />
          <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine" />
          <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling" />
        </ModelGeneration>
        <Security>
          <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization" />
        </Security>
        <Authentication>
          <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization" />
        </Authentication>
        <EventProcessing>
          <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
            <Event>
              <Type>ReportHistorySnapshotCreated</Type>
            </Event>
          </Extension>
          <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
            <Event>
              <Type>TimedSubscription</Type>
            </Event>
          </Extension>
          <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">
            <Event>
              <Type>RefreshCache</Type>
            </Event>
          </Extension>
          <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
            <Event>
              <Type>SnapshotUpdated</Type>
            </Event>
          </Extension>
        </EventProcessing>
      </Extensions>
      <MapTileServerConfiguration>
        <MaxConnections>2</MaxConnections>
        <Timeout>10</Timeout>
        <AppID>(Default)</AppID>
        <CacheLevel>Default</CacheLevel>
      </MapTileServerConfiguration>
    </Configuration>
    Try replacing your file with the above contents, then restart the "SQL Server Reporting Services (MSDPM2012)"  (MSDPM2010 depnding on your DPM version) Service and then restart the DPM Console and see if that fixes the issue.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, November 13, 2012 8:52 PM
    Moderator