致命错误：无法创建'R_TempDir' [英] Fatal error: cannot create 'R_TempDir'

问题描述

我按照https://msdn.microsoft.com/library/mt604883%28SQL.130%29.aspx安装了SQL Server 2016 CTP3并尝试运行：



-----------------------------------
$
执行sp_execute_external_script

  @language = N'R'

，@ ss = N'OutputDataSet< - InputDataSet;'
$
，@ input_data_1 = N'SELECT *  FROM MyData;'

WITH RESULT SETS（（[NewColName] int NOT NULL））;

-------------------- ---------------

基于 

I installed SQL Server 2016 CTP3 as per https://msdn.microsoft.com/library/mt604883%28SQL.130%29.aspx and tried to run:

-----------------------------------
execute sp_execute_external_script
  @language = N'R'
, @script = N' OutputDataSet <- InputDataSet;'
, @input_data_1 = N' SELECT *  FROM MyData;'
WITH RESULT SETS (([NewColName] int NOT NULL));
-----------------------------------
based on 

https://msdn.microsoft.com/en-US /library/mt591996.aspx

https://msdn.microsoft.com/en-US/library/mt591996.aspx

但由于以下原因而被停止：

------------------ -----------------

消息39012，级别16，状态1，行1

无法与运行时通信对于'R'脚本。请检查'R'运行时的要求。

来自外部脚本的STDERR消息： 

致命错误：无法创建'R_TempDir'





------------------------------- ----
$
什么可能是MIA？

but got stopped on account of:
-----------------------------------
Msg 39012, Level 16, State 1, Line 1
Unable to communicate with the runtime for 'R' script. Please check the requirements of 'R' runtime.
STDERR message(s) from external script: 
Fatal error: cannot create 'R_TempDir'


-----------------------------------
What might be MIA?

推荐答案

请你发帖子的内容吗？ rlauncher.config"文件？此文件位于"< sqlserver_instance> \ binn"下。目录。你能检查你的操作系统音量/驱动器是否打开了8.3名称生成？ R无法使用 空格
和其他字符处理路径。根据您发布的内容，我可以建议解决方法。

Can you please post the contents of "rlauncher.config" file? This file will be under the "<sqlserver_instance>\binn" directory. Can you check if your OS volume/drive have 8.3 name generation turned on? R cannot handle paths with whitespace and other characters. Depending on what you post, I can suggest the workaround.

这篇关于致命错误：无法创建'R_TempDir'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！