Start-Bits error; MicrosoftML & ScaleR load package errors; sp_execute_external_script errors

[mkrasmus]

Hi

From the log file I see a run of errors. Is there anything that can be fixed given my desktop environment?

Cheers
Michael

---

Windows PowerShell transcript start
Start time: 20200313112337
Username: XXXX
RunAs User: XXXX
Configuration Name:
Machine: XXXXXXX (Microsoft Windows NT 10.0.18362.0)
Host Application: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Process ID: 3356
PSVersion: 5.1.18362.628
PSEdition: Desktop
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.18362.628
BuildVersion: 10.0.18362.628
CLRVersion: 4.0.30319.42000
WSManStackVersion: 3.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1

---

Transcript started, output file is c:\tmp\hospital_setup_log.txt
Start time: 3/13/2020 11:23:37 AM
This Solution was created on non DVSM Sku

Installing SQLServer Power Shell Module or Updating to latest
NuGet provider is required to continue
PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet provider must be available in 'C:\Program Files\PackageManagement\ProviderAssemblies' or 'C:\Users\XXXX\AppData\Local\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running 'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and import the NuGet provider now?
&Yes &No &Suspend
Y
Cloning into 'C:\Solutions\Hospital'...
remote: Enumerating objects: 3, done.
remote: Counting objects: 100% (3/3), done.
remote: Compressing objects: 100% (2/2), done.
remote: Total 562 (delta 1), reused 1 (delta 1), pack-reused 559
Receiving objects: 100% (562/562), 88.44 MiB | 2.08 MiB/s, done.
Resolving deltas: 100% (320/320), done.

Servername set to XXXXX

Switching SQL Server to Mixed Mode

Configuring SQL to allow running of External Scripts

SQL Server Configured to allow running of External Scripts

Restarting SQL Services

SQL Services Restarted

Done with configuration changes to SQL Server

Installing latest Power BI.......
PS>TerminatingError(Start-BitsTransfer): "The operation being requested was not performed because the user has not logged on to the network. The specified service does not exist. (Exception from HRESULT: 0x800704DD)"
Start-BitsTransfer : The operation being requested was not performed because the user has not logged on to the network.
The specified service does not exist. (Exception from HRESULT: 0x800704DD)
At C:\users\XXXX\documents\projects\r-server-hospital-length-of-stay\resources\actionscripts\HospitalSetup.ps1:
179 char:1

• Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ...

•   + CategoryInfo          : NotSpecified: (:) [Start-BitsTransfer], COMException
    + FullyQualifiedErrorId : 
  

System.Runtime.InteropServices.COMException,Microsoft.BackgroundIntelligentTransfer.Management.NewBitsTransferCommand
Start-BitsTransfer : The operation being requested was not performed because the user has not logged on to the
network. The specified service does not exist. (Exception from HRESULT: 0x800704DD)
At C:\users\XXXX\documents\projects\r-server-hospital-length-of-stay\resources\actionscripts\HospitalSetup.ps1
:179 char:1

• Start-BitsTransfer -Source "https://go.microsoft.com/fwlink/?LinkId=5 ...

•   + CategoryInfo          : NotSpecified: (:) [Start-BitsTransfer], COMException
    + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,Microsoft.BackgroundIntelligentTransfer.Mana
   gement.NewBitsTransferCommand
  
  
  

Help Files Copied to Desktop

ServerName set to XXXXXXXX
This Version of SQL is not compatible with Py , Py Code and DB's will not be Created

Creating SQL Database for R
Calling Script to create the Hospital_R database

SQLServerDB Hospital_R Created

Calling Script to create the objects in the Hospital_R database
invoke-sqlcmd : Incorrect syntax near '='.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a
change tracking context clause, the previous statement must be terminated with a semicolon.
At C:\Solutions\Hospital\Resources\ActionScripts\ConfigureSQL.ps1:129 char:1

• invoke-sqlcmd -inputfile $CreateSQLObjects -serverinstance $ServerNam ...

•   + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
  

invoke-sqlcmd : Incorrect syntax near '='.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a
change tracking context clause, the previous statement must be terminated with a semicolon.
At C:\Solutions\Hospital\Resources\ActionScripts\ConfigureSQL.ps1:129 char:1

• invoke-sqlcmd -inputfile $CreateSQLObjects -serverinstance $ServerNam ...

•   + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
  
  
  

SQLServerObjects Created in Hospital_R Database

Configuring Hospital Solution for R

Name : Hospital
DsnType : System
Platform : 64-bit
DriverName : SQL Server Native Client 11.0
Attribute : {Database, Server, Trusted_Connection}

Import CSV File(s).

Loading LengthOfStay.csv into SQL Table....

Name : LengthOfStay

LengthOfStay table loaded from CSV File(s).

Loading LengthOfStay_Prod.csv into SQL Table....

Name : LengthOfStay_Prod

LengthOfStay_Prod table loaded from CSV File(s).

Finished loading .csv File(s).

Training Model and Scoring Data...
SqlServer\Invoke-Sqlcmd : A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT
0x80004004.
An external script error occurred:
Error in library("MicrosoftML") :
there is no package called 'MicrosoftML'
Calls: source -> withVisible -> eval -> eval -> library

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
Cannot insert the value NULL into column 'model', table 'Hospital_R.dbo.Models'; column does not allow nulls. INSERT
fails.
A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
Error in library("MicrosoftML") :
there is no package called 'MicrosoftML'
Calls: source -> withVisible -> eval -> eval -> library

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
Error in eval(expr, envir, enclos) :
could not find function "rxSerializeModel"
Calls: source -> withVisible -> eval -> eval

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
Cannot insert the value NULL into column 'model', table 'Hospital_R.dbo.Models'; column does not allow nulls. INSERT
fails.
The statement has been terminated.
The statement has been terminated.
At C:\Solutions\Hospital\Resources\ActionScripts\ConfigureSQL.ps1:189 char:1

• SqlServer\Invoke-Sqlcmd -ServerInstance LocalHost -Database $dbName - ...

•   + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
  

SqlServer\Invoke-Sqlcmd : A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
Error in library("MicrosoftML") :
there is no package called 'MicrosoftML'
Calls: source -> withVisible -> eval -> eval -> library

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
Cannot insert the value NULL into column 'model', table 'Hospital_R.dbo.Models'; column does not allow nulls. INSERT fails.
A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
Error in library("MicrosoftML") :
there is no package called 'MicrosoftML'
Calls: source -> withVisible -> eval -> eval -> library

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
Error in eval(expr, envir, enclos) :
could not find function "rxSerializeModel"
Calls: source -> withVisible -> eval -> eval

Error in ScaleR. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in ScaleR. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
Cannot insert the value NULL into column 'model', table 'Hospital_R.dbo.Models'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
At C:\Solutions\Hospital\Resources\ActionScripts\ConfigureSQL.ps1:189 char:1

• SqlServer\Invoke-Sqlcmd -ServerInstance LocalHost -Database $dbName - ...

•   + CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
    + FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand
  
  
  

R Server Configured in 00:05:05.5789036
npm WARN deprecated sprintf@0.1.5: The sprintf package is deprecated in favor of sprintf-js.
npm WARN deprecated core-js@2.6.11: core-js@<3 is no longer maintained and not recommended for usage due to the number of issues. Please, upgra
de your dependencies to the actual version of core-js@3.

core-js@2.6.11 postinstall C:\Solutions\Hospital\Website\node_modules\core-js
node -e "try{require('./postinstall')}catch(e){}"

Thank you for using core-js ( https://github.com/zloirock/core-js ) for polyfilling JavaScript standard library!

The project needs your help! Please consider supporting of core-js on Open Collective or Patreon:

https://opencollective.com/core-js
https://www.patreon.com/zloirock

Also, the author of core-js ( https://github.com/zloirock ) is looking for a good job -)

npm notice created a lockfile as package-lock.json. You should commit this file.
npm WARN hslos@1.0.0 No repository field.

added 93 packages from 101 contributors and audited 220 packages in 5.745s

2 packages are looking for funding
run npm fund for details

found 0 vulnerabilities

Length of Stay Development Workflow Finished Successfully!

Total Deployment Time = 00:06:50.7079469

---

Windows PowerShell transcript end
End time: 20200313113027

---