none
SQL server data tools business intelligence for visual studio 2013, data retrieval error

    Question

  • I tried to install SQL server data tools business intelligence for visual studio 2013

    However I get the failed to retrieve data for this request.

    Any ideas or suggestions?

    Also this is the full log:

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2146233088
      Exit facility code:            19
      Exit error code:               5376
      Exit message:                  Failed to retrieve data for this request.
      Start time:                    2017-01-15 12:13:19
      End time:                      2017-01-15 12:14:00
      Requested action:              Install
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.2430.0&EvtType=0x98CE2BA5%400x0D4B5B1D&EvtType=0x98CE2BA5%400x0D4B5B1D

    Machine Properties:
      Machine name:                  LAPTOPGREG
      Machine processor count:       8
      OS version:                    Windows 8
      OS service pack:               
      OS region:                     United States
      OS language:                   Nederlands (Nederland)
      OS architecture:               x64
      Process architecture:          32 Bit
      OS clustered:                  No

    Package properties:
      Description:                   Microsoft SQL Server 2014 
      ProductName:                   SQL Server 2014
      Type:                          RTM
      Version:                       12
      Installation location:         C:\Users\Gregory\Downloads\SSDTBI_x86_ENU (1)\x86\setup\
      Installation edition:          Express

      Slipstream:                    True

    Product Update Status:
      Success: KB 2999197

    Product Updates Selected for Installation:
      Title:                         Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013
      Knowledge Based Article:       KB 2999197
      Version:                       12.0.2430.0
      Architecture:                  x86
      Language:                      All

      Update Source:                 MU


    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                <empty>
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   <empty>
      CLTRESULTDIR:                  <empty>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <empty>
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 <empty>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    false
      ENU:                           true
      ERRORREPORTING:                false
      FEATURES:                      
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTSQLSERVERLICENSETERMS:  false
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files (x86)\Microsoft SQL Server\
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          AllFeatures_WithDefaults
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  false
      TCPENABLED:                    0
      UIMODE:                        AutoAdvance
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           true

      Configuration file:            C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20170115_121309\ConfigurationFile.ini

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               The rule result report file is not available.

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException
        Message: 
            Failed to retrieve data for this request.
        HResult : 0x80131500
        Data: 
          HelpLink.ProdName = Microsoft SQL Server
          HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
          HelpLink.LinkId = 20476
          HelpLink.EvtType = 0x98CE2BA5@0x0D4B5B1D
          DisableWatson = true
        Stack: 
            at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.ProcessDTbl(DataTable dt, Int32 level)
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.ProcessDTbl(DataTable dt, Int32 level)
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectSqlDiscoveryData(String machineName)
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectDiscoveryData(String machineName)
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
            at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
        Inner exception type: System.InvalidCastException
            Message: 
                    Unable to cast object of type 'System.Int64' to type 'System.String'.
            HResult : 0x80004002
            Stack: 
                    at Microsoft.SqlServer.Discovery.Feature.GetReleaseTrainFromARPRegKeyByPatchLevel(String matchedSqlProductIdName, String matchedSqlProductIdValue, String patchLevel, String& patchReleaseTrain)
                    at Microsoft.SqlServer.Discovery.Feature.GetReleaseTrain(FeatureInformation featureInfo)
                    at Microsoft.SqlServer.Discovery.Feature.GetColumnData(String column, FeatureInformation featureInfo)
                    at Microsoft.SqlServer.Discovery.Feature.AddRow(DataTable dt, FeatureInformation featureInfo)
                    at Microsoft.SqlServer.Discovery.Feature.PopulateDataSet(EnumResult result, DataTable contextUrns)
                    at Microsoft.SqlServer.Discovery.Feature.GetData(EnumResult erParent)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)

    Sunday, January 15, 2017 11:47 AM

All replies

  • Is this relevant at all?

    https://connect.microsoft.com/SQLServer/feedback/details/482103/unable-to-cast-com-object-of-type-system-comobject-to-interface-type-microsoft-visualstudio-ole-interop-iserviceprovider

    Edward Dixon has a workaround - check the workaround tab.

    regsvr32 "C:\Program Files\Internet Explorer\ieproxy.dll"

    if you are running 64 bit windows, try this:

    regsvr32 "C:\Program Files (x86)\Internet Explorer\ieproxy.dll"

    and perhaps reregistering actprxy.dll.

    Sunday, January 15, 2017 2:03 PM