Handling Errors while running the scripts of TelcoChurn-Main.sql and TelcoChurn-Operationalize.sql.

Hi,
After installing SQL Server 2016 developer edition and trying for this Telco Customer churn sql server scripts.
I got certain error while running scripts TelcoChurn-Main.sql and TelcoChurn-Operationalize.sql.
For first , after google I found out we need to change the Memory_Limit_percent in order to run above sql scripts. so, just add MEMORY_LIMIT_PERCENT=50 into the config file for Rlauncher.config which can be found in below location:
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn
Change as below;
RHOME=C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\R_SERVICES
MPI_HOME=C:\Program Files\Microsoft MPI
INSTANCE_NAME=MSSQLSERVER
TRACE_LEVEL=1
JOB_CLEANUP_ON_EXIT=1
USER_POOL_SIZE=0
WORKING_DIRECTORY=C:\PROGRA1\MICROS3\MSSQL11.MSS\MSSQL\EXTENS1
MEMORY_LIMIT_PERCENT=50

While running this script TelcoChurn-Operationalize.sql we need to firstly installed the required R packages,
I have also uploaded one SQL File which installed required R packages before running the scripts of telco customer churn into my fork repository for sql-server-samples. The file contains Enabling sp_execute_external_script to run R scripts in SQL Server 2016 and installing required R packages in order to run the Script TelcoChurn-Main.sql and TelcoChurn-Operationalize.sql sucessfully. since we need to install those R packages before we run the scripts in order to avoid the error .
https://github.com/maharjananil/sql-server-samples/blob/master/samples/features/r-services/Telco%20Customer%20Churn/SQL%20Server/Enabling%20R%20scripts%20to%20run%20and%20Installing%20required%20R%20Packages.sql

so, I think it will be helpful to upload the new SQL file in official repository too.

Thanks,
Anil Maharjan

Start with samples/features/r-services/Telco Customer Churn/SQL Server/TelcoChurn-Main.sql and TelcoChurn-Operationalize.sql, then review the linked fork file, Enabling R scripts to run and Installing required R Packages.sql. Verify the setup steps and package requirements against SQL Server 2016 before determining where the additional SQL file belongs.