microsoft / r-server-campaign-optimization Goto Github PK

I tried to execute the powershell script SQLR\Campaign_Optimization.ps1 on MSSQL 2017. In the step 3b, I'm getting this error

Invoke-Sqlcmd : A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
During startup - Warning message:
In setJsonDatabasePath(system.file("extdata/capabilities.json", :
bytecode version mismatch; using eval
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Could not open data source.
Error in doTryCatch(return(expr), name, parentenv, handler) :
Could not open data source.
Calls: source ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call
Error in execution. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in execution. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
STDOUT message(s) from external script:
[Microsoft][ODBC Driver Manager] Connection not open
ODBC Error in SQLDisconnect
At D:\mssql-r\r-server-campaign-optimization\SQLR\Campaign_Optimization.ps1:79 char:5

• Invoke-Sqlcmd -ServerInstance $ServerName  -Database $DBName -Use ...
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

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

The user I used for this execution is the DB owner and I granted script execution permissions as mentioned here
https://docs.microsoft.com/en-us/sql/advanced-analytics/security/user-permission?view=sql-server-ver15

Can you help me with a work around ?

Hi all,

I'm having in invalid object CM_AD1 when training the RandomForest model.

cheers

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

The Product and Campaign_Detail tables have a Category field. It seems that the Campaign_Detail one is used, at this SQL statement during the merge phase: (

Campaign_Detail.Category value is always 'Acquisition'... Is it adding a constant value to the machine learning model?

What do I get wrong here?

Thanks,
G.

This repository is currently missing a LICENSE file.

A license helps users understand how to use your project in a compliant manner. You can find the standard MIT license Microsoft uses at: https://github.com/microsoft/repo-templates/blob/main/shared/LICENSE.

If you would like to learn more about open source licenses, please visit the document at https://aka.ms/license (Microsoft-internal guidance).