none
как починить reporting services RRS feed

  • Вопрос

  • Не работает Reporting Services после того как по ошибке была удалена служба SQL Reporting services.

    переустановил, но теперь не реплицируется с scsm, пробовал переустановить Datawarehouse, но не помогло.

    Можно как то исправить данную ситуацию?

    2 ноября 2012 г. 11:33

Ответы

  • Однако SCSM уверен, что служба как минимум не отвечает по порту 5724. Проверьте, порт открыт, что нет никаких сетевых проблем.


    SCSMSolutions
    email: freemanru (at) gmail (dot) com

    • Помечено в качестве ответа _CoopeR_ 9 ноября 2012 г. 5:22
    8 ноября 2012 г. 14:57
    Модератор

Все ответы

  • Хотя бы ошибки выложите. А то все телепаты на море отдыхают.


    SCSMSolutions
    email: freemanru (at) gmail (dot) com

    5 ноября 2012 г. 20:18
    Модератор
  • лог reporting services

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
      <Locale>Русский (Россия)</Locale>
      <TimeZone></TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.SCSM\Reporting Services\Logfiles\ReportServerService__11_06_2012_09_08_18.log</Path>
      <SystemName>SC</SystemName>
      <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
      <OSVersion>6.1.7601</OSVersion>
      <ProcessID>2064</ProcessID>
      <Virtualization>Hypervisor</Virtualization>
    </Header>
    rshost!rshost!ea8!11/06/2012-09:08:18:: i INFO: CLR runtime is initialized.
    rshost!rshost!ea8!11/06/2012-09:08:18:: i INFO: Derived memory configuration based on physical memory as 8246840 KB
    appdomainmanager!DefaultDomain!1f50!11/06/2012-09:08:18:: i INFO: Entered managed ServiceMain in DefaultDomain.
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: e ERROR: Configuration file element UrlReservation has a invalid VirtualRoot. It will be ignored.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing AuthenticationTypes to '5'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing EnableAuthPersistence to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: w WARN: Initializing UrlRoot to default value of ''  because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing IsReportManagerEnabled to 'True'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing MaxConnections to '2'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing AppID to '(Default)'  as specified in Configuration file.
    library!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Initializing CacheLevel to 'Default'  as specified in Configuration file.
    resourceutilities!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Reporting Services starting SKU: Enterprise
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using report server internal url http://localhost:80/ReportServer_SCSM.
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using report server external url http://SC:80/ReportServer_SCSM.
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using url root http://SC:80/ReportServer_SCSM.
    rshost!rshost!1f0c!11/06/2012-09:08:19:: i INFO: Configuring maxPhysicalCpu=8, minLogicalCpu=0
    rshost!rshost!1f0c!11/06/2012-09:08:19:: i INFO: Logical processor per physical processor 4
    rshost!rshost!1f0c!11/06/2012-09:08:19:: i INFO: Maximum logical CPU is 4
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using report server internal url http://localhost:80/ReportServer_SCSM.
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using report server external url http://SC:80/ReportServer_SCSM.
    configmanager!DefaultDomain!1f0c!11/06/2012-09:08:19:: i INFO: Using url root http://SC:80/ReportServer_SCSM.
    appdomainmanager!DefaultDomain!1f0c!11/06/2012-09:08:20:: i INFO: Appdomain:2 WindowsService_0 started.
    resourceutilities!WindowsService_0!1f0c!11/06/2012-09:08:20:: i INFO: Reporting Services starting SKU: Enterprise
    library!WindowsService_0!1e44!11/06/2012-09:08:20:: i INFO: Catalog SQL Server Edition = Enterprise
    rshost!rshost!10d0!11/06/2012-09:08:20:: i INFO: Registered url=http://*:80/ReportServer_SCSM/, vdir=/ReportServer_SCSM, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SCSM\Reporting Services\ReportServer.
    rshost!rshost!10d0!11/06/2012-09:08:20:: i INFO: Currently registered url http://*:80/ReportServer_SCSM/ on endpoint 2
    rshost!rshost!10d0!11/06/2012-09:08:20:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SCSM\Reporting Services\ReportManager.
    rshost!rshost!10d0!11/06/2012-09:08:20:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SCSM/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.SCSM\Reporting Services\ReportServer\ReportBuilder.
    resourceutilities!DefaultDomain!1f0c!11/06/2012-09:08:20:: i INFO: Maximum memory limit is 2097152Mb
    rshost!rshost!1f0c!11/06/2012-09:08:20:: i INFO: Derived memory configuration based on physical memory as 8246840 KB
    servicecontroller!DefaultDomain!1b04!11/06/2012-09:08:20:: i INFO: Total Physical memory: 8444764160
    crypto!WindowsService_0!1e44!11/06/2012-09:08:20:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
    crypto!WindowsService_0!1e44!11/06/2012-09:08:20:: i INFO: Exporting public key
    rpcserver!DefaultDomain!10d0!11/06/2012-09:08:20:: i INFO: Process monitoring started.
    crypto!WindowsService_0!1e44!11/06/2012-09:08:20:: i INFO: Performing sku validation
    crypto!WindowsService_0!1e44!11/06/2012-09:08:20:: i INFO: Importing existing encryption key
    dbpolling!WindowsService_0!1e44!11/06/2012-09:08:21:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!1e44!11/06/2012-09:08:21:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!1e44!11/06/2012-09:08:21:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!1e44!11/06/2012-09:08:21:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!189c!11/06/2012-09:08:21:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
    dbpolling!WindowsService_0!f78!11/06/2012-09:08:21:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
    dbpolling!WindowsService_0!1d1c!11/06/2012-09:08:21:: i INFO: PollingMaintenance: Polling started
    resourceutilities!WindowsService_0!1d1c!11/06/2012-09:08:21:: i INFO: Maximum memory limit is 2097152Mb
    rpcserver!DefaultDomain!1e44!11/06/2012-09:08:21:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!1e44!11/06/2012-09:08:21:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.SCSM'
    appdomainmanager!WindowsService_0!1e44!11/06/2012-09:08:21:: i INFO: Appdomain:2 WindowsService_0 initialized.
    appdomainmanager!DefaultDomain!1f0c!11/06/2012-09:08:48:: i INFO: Appdomain:3 ReportServer_SCSM_0-1-129966521286782486 started.
    appdomainmanager!ReportServer_0-1!1f0c!11/06/2012-09:08:57:: i INFO: RS authentication mode is 5; effective ASP.NET authentication mode is Windows. vdir=/ReportServer_SCSM.
    appdomainmanager!DefaultDomain!1f0c!11/06/2012-09:08:57:: i INFO: Appdomain:3 ReportServer_SCSM_0-1-129966521286782486 initialized (#1).
    webserver!ReportServer_0-1!1f0c!11/06/2012-09:09:51:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Reporting Services starting SKU: Enterprise
    resourceutilities!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Maximum memory limit is 2097152Mb
    library!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: Call to GetItemTypeAction(/).
    library!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
    crypto!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Exporting public key
    crypto!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Performing sku validation
    crypto!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Importing existing encryption key
    library!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: Call to ListParentsAction(/).
    library!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: Call to ListChildrenAction(/, False).
    webserver!ReportServer_0-1!1f0c!11/06/2012-09:09:52:: i INFO: Processed folder '/'
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListParentsAction(/SystemCenter).
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListParentsAction(/SystemCenter).
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListChildrenAction(/SystemCenter, False).
    webserver!ReportServer_0-1!1a08!11/06/2012-09:10:47:: i INFO: Processed folder '/SystemCenter'
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListParentsAction(/SystemCenter/ServiceManager).
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListParentsAction(/SystemCenter/ServiceManager).
    library!ReportServer_0-1!1a08!11/06/2012-09:10:47:: Call to ListChildrenAction(/SystemCenter/ServiceManager, False).
    webserver!ReportServer_0-1!1a08!11/06/2012-09:10:48:: i INFO: Processed folder '/SystemCenter/ServiceManager'
    library!ReportServer_0-1!1f0c!11/06/2012-09:11:02:: Call to ListParentsAction(/SystemCenter/ServiceManager).
    library!ReportServer_0-1!1f0c!11/06/2012-09:11:02:: Call to ListParentsAction(/SystemCenter/ServiceManager).
    library!ReportServer_0-1!1f0c!11/06/2012-09:11:02:: Call to ListChildrenAction(/SystemCenter/ServiceManager, False).
    webserver!ReportServer_0-1!1f0c!11/06/2012-09:11:02:: i INFO: Processed folder '/SystemCenter/ServiceManager'
    library!ReportServer_0-1!1c0c!11/06/2012-09:11:02:: Call to ListParentsAction(/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement).
    library!ReportServer_0-1!1c0c!11/06/2012-09:11:02:: Call to ListParentsAction(/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement).
    library!ReportServer_0-1!1c0c!11/06/2012-09:11:02:: Call to ListChildrenAction(/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement, False).
    webserver!ReportServer_0-1!1c0c!11/06/2012-09:11:02:: i INFO: Processed folder '/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement'
    library!ReportServer_0-1!860!11/06/2012-09:11:48:: i INFO: RenderForNewSession('/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement/ServiceManager.Report.IncidentManagement.ListOfIncidents')
    processing!ReportServer_0-1!860!11/06/2012-09:11:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Отсутствуют данные для поля в позиции 2.;
    library!ReportServer_0-1!860!11/06/2012-09:11:51:: Using folder C:\Program Files\Microsoft SQL Server\MSRS10_50.SCSM\Reporting Services\RSTempFiles for temporary files.
    library!ReportServer_0-1!860!11/06/2012-09:11:55:: i INFO: RenderFromSession('/SystemCenter/ServiceManager/ServiceManager.Console.Reporting.IncidentManagement/ServiceManager.Report.IncidentManagement.ListOfIncidents')
    

    6 ноября 2012 г. 5:14
  • 1. А что в логе OPerations Manager на DW?
    2. http://SC:80/Reports открывается?

    SCSMSolutions
    email: freemanru (at) gmail (dot) com

    6 ноября 2012 г. 19:18
    Модератор
  • 1. А что в логе OPerations Manager на DW?

    Ошибки

    MP Sync failed to connect to Data Access Service on the machine localhost%. Ensure that the service is started and that there are no connectivity issues to localhost% if it is a remote server.

    Ошибка установки состояния свойства . Ошибка: Служба доступа к данным не работает или еще не инициализирована. Дополнительные сведения см. в журнале событий.. Сведения о состоянии: .

    Error creating service group
    Тип исключения:
    ServiceNotRunningException
    Сообщение об исключении:Служба доступа к данным не работает или еще не инициализирована. Дополнительные сведения см. в журнале событий..
    StackTrace:   в Microsoft.EnterpriseManagement.Common.Internal.ExceptionHandlers.HandleChannelExceptions(Exception ex)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.CreateEndpoint[T](EnterpriseManagementConnectionSettings connectionSettings, SdkChannelObject`1 channelObjectDispatcherService)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.ConstructEnterpriseManagementGroupInternal[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore clientCallback)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.RetrieveEnterpriseManagementGroupInternal[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore callbackDispatcherService)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.Connect[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore callbackDispatcherService)
       в Microsoft.EnterpriseManagement.ServiceManagementGroup.InternalInitialize(EnterpriseManagementConnectionSettings connectionSettings, EnterpriseManagementGroupInternal internals)
       в Microsoft.EnterpriseManagement.ServiceManagementGroup..ctor(String serverName)
       в Microsoft.EnterpriseManagement.LinkingFramework.ServerUtility.GetServiceGroup()
    Внутреннее исключение:
    EndpointNotFoundException
    Сообщение об исключении:Не удалось подключиться к net.tcp://localhost:5724/DispatcherService. Попытки подключения выполнялись в течение интервала времени 00:00:02.0359300. Код ошибки TCP 10061: Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение 127.0.0.1:5724. .
    StackTrace:
    Server stack trace:
       в System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
       в System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
       в System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
       в System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
       в System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       в System.ServiceModel.Channels.LayeredChannel`1.OnOpen(TimeSpan timeout)
       в System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       в System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
       в System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
       в System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
       в System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
       в System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
       в System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
       в System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    Exception rethrown at [0]:
       в System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       в System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       в Microsoft.EnterpriseManagement.Common.Internal.IDispatcherService.Connect(SdkClientConnectionOptions connectionOptions)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.ConnectInternal(EnterpriseManagementConnectionSettings connectionSettings)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.Initialize(EnterpriseManagementConnectionSettings connectionSettings, SdkChannelObject`1 channelObjectDispatcherService)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.CreateEndpoint[T](EnterpriseManagementConnectionSettings connectionSettings, SdkChannelObject`1 channelObjectDispatcherService)
    Внутреннее исключение:
    SocketException
    Сообщение об исключении:Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение 127.0.0.1:5724.
    StackTrace:   в System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       в System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
       в System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout

    Предупреждения

    An error countered while attempting to execute ETL Module:
     ETL process type: Load
     Batch ID: 1639
     Module name: LoadOMDWDataMartChangeImplementationResults

     Module name: LoadDWDataMartIncidentUrgency

    Module name: LoadOMDWDataMartChangePriority

     Message: Служба доступа к данным не работает или еще не инициализирована. Дополнительные сведения см. в журнале событий.

     Stack:    в Microsoft.EnterpriseManagement.Common.Internal.ExceptionHandlers.HandleChannelExceptions(Exception ex)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.CreateEndpoint[T](EnterpriseManagementConnectionSettings connectionSettings, SdkChannelObject`1 channelObjectDispatcherService)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.ConstructEnterpriseManagementGroupInternal[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore clientCallback)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.RetrieveEnterpriseManagementGroupInternal[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore callbackDispatcherService)
       в Microsoft.EnterpriseManagement.Common.Internal.SdkDataLayerProxyCore.Connect[T,P](EnterpriseManagementConnectionSettings connectionSettings, ClientDataAccessCore callbackDispatcherService)
       в Microsoft.EnterpriseManagement.EnterpriseManagementGroup.InternalInitialize(EnterpriseManagementConnectionSettings connectionSettings, EnterpriseManagementGroupInternal internalsProxy)
       в Microsoft.SystemCenter.Warehouse.Store..ctor()
       в Microsoft.SystemCenter.Warehouse.Store.get_Instance()
       в Microsoft.SystemCenter.Warehouse.Store.GetWarehouseModule(Guid id)
       в Microsoft.SystemCenter.Warehouse.Etl.ModuleFactory.GetBaseModule(InstanceWrapper iw, Collection`1 depends)
       в Microsoft.SystemCenter.Warehouse.Etl.MetadataStore.RefreshMetadata(String metaConnString)
       в Microsoft.SystemCenter.Warehouse.Etl.MetadataStore..ctor()
       в Microsoft.SystemCenter.Warehouse.Etl.MetadataStore.get_MetaStore()
       в Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)

    2. http://SC:80/Reports открывается?

    да открывается но по адресу http://sc/reportserver_scsm

    7 ноября 2012 г. 6:47
  • А служба-то работает на самом деле?


    SCSMSolutions
    email: freemanru (at) gmail (dot) com

    7 ноября 2012 г. 10:18
    Модератор
  • да работает на обоих серверах и sc и dw
    7 ноября 2012 г. 11:15
  • Однако SCSM уверен, что служба как минимум не отвечает по порту 5724. Проверьте, порт открыт, что нет никаких сетевых проблем.


    SCSMSolutions
    email: freemanru (at) gmail (dot) com

    • Помечено в качестве ответа _CoopeR_ 9 ноября 2012 г. 5:22
    8 ноября 2012 г. 14:57
    Модератор
  • Может ключ шифрования БД "потерялся"?
    8 ноября 2012 г. 15:33
  • спасибо, да проблема заключалась в сети
    9 ноября 2012 г. 5:22