********************** PowerShell transcript start Start time: 20180321180357 Username: EDHPRDPFTW02\pftw02 RunAs User: EDHPRDPFTW02\pftw02 Configuration Name: Machine: EDHPRDPFTW02 (Microsoft Windows NT 6.2.9200.0) Host Application: C:\Program Files\PowerShell\6.0.2\pwsh.dll Process ID: 5676 PSVersion: 6.0.2 PSEdition: Core GitCommitId: v6.0.2 OS: Microsoft Windows 10.0.10240 Platform: Win32NT PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.2 PSRemotingProtocolVersion: 2.3 SerializationVersion: 1.1.0.1 WSManStackVersion: 3.0 ********************** Transcript started, output file is c:\tmp\setup_log.txt Start time: 3/21/2018 6:03:57 PM Installing SQLServer Power Shell Module or Updating to latest PS>TerminatingError(Import-Module): "Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'." Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Cloning into 'C:\Solutions\Fraud'... remote: Counting objects: 567, done. remote: Compressing objects: 100% (18/18), done. remote: Total 567 (delta 19), reused 23 (delta 12), pack-reused 537 | 530.00 Receiving objects: 94% (533/567), 67.32 MiB | 530.00 KiB/s Receiving objects: 100% (567/567), 67.44 MiB | 425.00 KiB/s, done. Resolving deltas: 100% (320/320), done. invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure ServerName set to Switching SQL Server to Mixed Mode Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Configuring SQL to allow running of External Scripts Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException SQL Server Configured to allow running of External Scripts Restarting SQL Services WARNING: Waiting for service 'SQL Server Analysis Services (MSSQLSERVER) (MSSQLServerOLAPService)' to start... WARNING: Waiting for service 'SQL Server Analysis Services (MSSQLSERVER) (MSSQLServerOLAPService)' to start... ********************** PowerShell transcript start Start time: 20180321183402 Username: EDHPRDPFTW02\pftw02 RunAs User: EDHPRDPFTW02\pftw02 Configuration Name: Machine: EDHPRDPFTW02 (Microsoft Windows NT 6.2.9200.0) Host Application: C:\Program Files\PowerShell\6.0.2\pwsh.dll Process ID: 3700 PSVersion: 6.0.2 PSEdition: Core GitCommitId: v6.0.2 OS: Microsoft Windows 10.0.10240 Platform: Win32NT PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.2 PSRemotingProtocolVersion: 2.3 SerializationVersion: 1.1.0.1 WSManStackVersion: 3.0 ********************** Transcript started, output file is c:\tmp\setup_log.txt Start time: 3/21/2018 6:34:02 PM Installing SQLServer Power Shell Module or Updating to latest PS>TerminatingError(Import-Module): "Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'." Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Solution has already been cloned invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure ServerName set to Switching SQL Server to Mixed Mode Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Configuring SQL to allow running of External Scripts Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException SQL Server Configured to allow running of External Scripts Restarting SQL Services WARNING: Waiting for service 'SQL Server Analysis Services (MSSQLSERVER) (MSSQLServerOLAPService)' to start... ServerName set to Fraud Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:62 char:17 + $isCompatible = Invoke-Sqlcmd -ServerInstance $ServerName -Database M ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:62 char:17 + $isCompatible = Invoke-Sqlcmd -ServerInstance $ServerName -Database M ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException You cannot call a method on a null-valued expression. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:63 char:1 + $isCompatible = $isCompatible.Item(0) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:63 char:1 + $isCompatible = $isCompatible.Item(0) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull There is not a py version of this solution There is not a R Version for this Solution so R will not be Installed Done with configuration changes to SQL Server Installing latest Power BI... Start-BitsTransfer : The term 'Start-BitsTransfer' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:204 char:1 + Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ... + ~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Start-BitsTransfer:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Start-BitsTransfer : The term 'Start-BitsTransfer' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:204 char:1 + Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ... + ~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Start-BitsTransfer:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Help Files Copied to Desktop npm : The term 'npm' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:230 char:1 + npm install + ~~~ + CategoryInfo : ObjectNotFound: (npm:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException npm : The term 'npm' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:230 char:1 + npm install + ~~~ + CategoryInfo : ObjectNotFound: (npm:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException r-server-fraud-detection Workflow Finished Successfully! Total Deployment Time = 00:02:30.3964151 ********************** PowerShell transcript end End time: 20180321183632 ********************** ********************** PowerShell transcript start Start time: 20180321185007 Username: EDHPRDPFTW02\pftw02 RunAs User: EDHPRDPFTW02\pftw02 Configuration Name: Machine: EDHPRDPFTW02 (Microsoft Windows NT 6.2.9200.0) Host Application: C:\Program Files\PowerShell\6.0.2\pwsh.dll Process ID: 9836 PSVersion: 6.0.2 PSEdition: Core GitCommitId: v6.0.2 OS: Microsoft Windows 10.0.10240 Platform: Win32NT PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.2 PSRemotingProtocolVersion: 2.3 SerializationVersion: 1.1.0.1 WSManStackVersion: 3.0 ********************** Transcript started, output file is c:\tmp\setup_log.txt Start time: 3/21/2018 6:50:07 PM Installing SQLServer Power Shell Module or Updating to latest PS>TerminatingError(Import-Module): "Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'." Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Import-Module : Could not load type 'System.Management.Automation.PSSnapIn' from assembly 'System.Management.Automation, Version=6.0.2.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'. At C:\SetupVM.ps1:52 char:5 + Import-Module -Name SqlServer -MaximumVersion 21.0.17199 -Force + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-Module], TypeLoadException + FullyQualifiedErrorId : System.TypeLoadException,Microsoft.PowerShell.Commands.ImportModuleCommand Solution has already been cloned invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException invoke-sqlcmd : The term 'invoke-sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:138 char:11 + $si = invoke-sqlcmd -Query $Query + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (invoke-sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\SetupVM.ps1:139 char:5 + $si = $si.Item(0) + ~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure The variable cannot be validated because the value is not a valid value for the serverName variable. At C:\SetupVM.ps1:140 char:23 + $serverName = if ($serverName -eq $null) {$si} + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : MetadataError: (:) [], ValidationMetadataException + FullyQualifiedErrorId : ValidateSetFailure ServerName set to Switching SQL Server to Mixed Mode Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:147 char:9 + Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N'HKEY_LOCAL_ ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:150 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:153 char:9 + Invoke-Sqlcmd -Query $Query -ErrorAction SilentlyContinue + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Configuring SQL to allow running of External Scripts Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:158 char:1 + Invoke-Sqlcmd -Query "EXEC sp_configure 'external scripts enabled', ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:161 char:1 + Invoke-Sqlcmd -Query "RECONFIGURE WITH OVERRIDE" + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException SQL Server Configured to allow running of External Scripts Restarting SQL Services WARNING: Waiting for service 'SQL Server Analysis Services (MSSQLSERVER) (MSSQLServerOLAPService)' to start... ServerName set to Fraud Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:62 char:17 + $isCompatible = Invoke-Sqlcmd -ServerInstance $ServerName -Database M ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Invoke-Sqlcmd : The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:62 char:17 + $isCompatible = Invoke-Sqlcmd -ServerInstance $ServerName -Database M ... + ~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Invoke-Sqlcmd:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException You cannot call a method on a null-valued expression. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:63 char:1 + $isCompatible = $isCompatible.Item(0) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\Solutions\Fraud\Resources\ActionScripts\ConfigureSQL.ps1:63 char:1 + $isCompatible = $isCompatible.Item(0) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull There is not a py version of this solution There is not a R Version for this Solution so R will not be Installed Done with configuration changes to SQL Server Installing latest Power BI... Start-BitsTransfer : The term 'Start-BitsTransfer' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:204 char:1 + Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ... + ~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Start-BitsTransfer:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Start-BitsTransfer : The term 'Start-BitsTransfer' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\SetupVM.ps1:204 char:1 + Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ... + ~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Start-BitsTransfer:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException Help Files Copied to Desktop