locked
Best Practices Analyzer Cannot Access Analysis Services

    Pregunta

  • I'm running the December 2011 Power Tools release of the TFS Best Practices Analyzer. The critical issue 'Cannot access Analysis Services' is reported. The AT, DT and Sql Server 2008 Standard Edition are running on a single Windows Server 2003 R2 Enterprise Edition box. I've tried running TfsBpa under two different Administrator accounts.

    Here's a run log for a Team Foundation Server Warehouse Health Check:

    10:42:31.564: ================= Starting PreScan data collection =================

    10:42:53.329: ================= Completed PreScan data collection =================

    10:42:55.688: Starting Collecting Data phase.

    10:42:57.470: Detecting TFSSERVICE account for AT - myserver.

    10:42:57.688: Starting data collection for Machine - myserver.

    10:43:00.891: Processing computer and OS information for myserver.

    10:43:18.531: Processing event log information for myserver.

    10:43:46.031:Obtaining network information for myserver

    10:43:56.765: Handled Exception:

    System.Management.Automation.RuntimeException

    You cannot call a method on a null-valued expression.

    Script = Get-WebService-WarehouseControllerSvcGetProcessingStatusOLAP.ps1

    ScriptParam1 (Key5) = http://myserver:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

    10:43:58.218: Handled Exception:

    System.Management.Automation.RuntimeException

    You cannot call a method on a null-valued expression.

    Script = Get-WebService-WarehouseControllerSvcGetProcessingStatusRELATIONAL.ps1

    ScriptParam1 (Key5) = http://myserver:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

    10:43:58.265: Starting data collection for RS - http://myserver/Reports.

    10:43:58.280: Obtaining services information for myserver.

    10:44:26.842: Starting data collection for AS - myserver.

    10:44:26.842: Obtaining services information for myserver.

    10:44:27.826: Completed Collecting Data phase.

    10:44:29.060: Starting Postprocessing Rules phase.

    10:44:29.154: Completed Postprocessing Rules phase.


    Any clues as to what the issue might be?

    Thanks,

    Mike

    martes, 27 de marzo de 2012 18:05

Todas las respuestas

  • What is the actual state of your Analysis Services? Can you connect to it from SQL Server Management studio and look at the TFS_Anaysis cube successfully.

    Trevor Hancock (Microsoft)
    Please remember to "Mark As Answer" the replies that help.

    miércoles, 28 de marzo de 2012 21:10
  • The cube appears to be loaded and functioning properly. I am able to connect to the cube, query data, and can see the data in the cube is current.

    Thanks,

    Mike

    miércoles, 28 de marzo de 2012 22:00
  • Please send me your BPA log: MS_TREVORH at HOTMAIL.

    Trevor Hancock (Microsoft)
    Please remember to "Mark As Answer" the replies that help.

    lunes, 02 de abril de 2012 15:45
  • Still waiting on log. Do you still need help with this, Mike?

    Trevor Hancock (Microsoft)
    Please remember to "Mark As Answer" the replies that help.

    miércoles, 04 de abril de 2012 15:19
  • Yes, please. I sent the logs a little earlier today.
    jueves, 05 de abril de 2012 20:14
  • Mike,

    From the logs it looks as like you ran the "Scan Type" as "Team Foundation Server Warehouse Health Check". It would be best to run "Team Foundation Server Complete Health Check". Can you do that and re-send the logs, please?


    Trevor Hancock (Microsoft)
    Please remember to "Mark As Answer" the replies that help.

    lunes, 09 de abril de 2012 15:32
  • Mike – thank you for the new scan. Just to set your expectations – we are very close to a point where you may have to open a support case. There is only so much we can do via a forum thread \ e-mail like this, and we’d need a support case to proceed further.
     
    The last suggestion we have is to explicitly add the account “win\tfssetup1” in the SSAS server admin role (http://msdn.microsoft.com/en-us/library/ms178471.aspx) and then re-run the BPA.

    If it is already there, then we have to dig into the AS code in BPA to find what possible reason it would not be picking up the metadata. That will need a case, as I’ve said.


    Trevor Hancock (Microsoft)
    Please remember to "Mark As Answer" the replies that help.

    martes, 10 de abril de 2012 16:51
  • Thanks, Trevor. That account is indeed already in an SSAS server admin role. I'll consider getting a case open for this.

    Mike

    jueves, 12 de abril de 2012 21:39