rxPredict抛出SQL Server不存在或访问被拒绝错误 [英] rxPredict throws SQL Server does not exist or access denied error

问题描述

大家好，

我正在尝试MSDN上的SQL Server R服务教程 - 链接如下：

https：/ /msdn.microsoft.com/en-us/library/mt629164.aspx

当我运行rxPredict命令时：

rxPredict（modelObject = logitObj ，data = featureDataSource，outData = scoredOutput，  


          predVarNames =" Score"，类型= QUOT;响应"，  


          writeModelVars = TRUE，覆盖= TRUE）&NBSP ;

我收到以下错误：

 ====== SG01NB-4300092（进程1）已开始运行2016-07-04 09：43：35.00 ====== 
 
 [Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SQL Server不存在或访问被拒绝。 
文件中的捕获异常：CxAnalysis.cpp，行：5682。ThreadID：13560 Rethrowing。 
文件中的捕获异常：CxAnalysis.cpp，行：5249。ThreadID：13560 Rethrowing。 
 
 [微软] [ODBC驱动程序管理器]未打开连接
 
 ODBC错误在调用SQLDisconnect 
错误doTryCatch（回报（表达式），姓名，parentenv，处理程序） ：
 [Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SQL Server不存在或访问被拒绝。 
来电：来源... tryCatch  - > tryCatchList  - > tryCatchOne  - > doTryCatch  - > .Call 
执行暂停
  rxCompleteClusterJob中的错误（hpcServerJob，consoleOutput，autoCleanup）：
无可用结果 - 最终作业state：failed  

我确保我的rxSetComputeContext（cc）使用的是有效的用户登录信息创建表格。我也在我正在处理的本地计算机上安装SQL Server，因此它不会成为网络问题。

是否有人遇到此问题并设法成功运行此语句？

感谢您的回复和帮助！

Ian

解决方案

大家好，

我发现，问题在于outData = scoredOutput声明。如果我设置outData = NULL并将服务器上下文更改为本地，我可以从rxPredict生成输出。

我决定然后使用rxSetComputeContext执行rxPredict（ "本地"）得到的输出数据帧（outDF），然后使用rxDataStep（INDATA = outDF，不过outFile = scoredOutput，重写= TRUE）

如果任何人将其重新保存到SQL Server有更好的方法请告诉我！

谢谢

Ian

Hi everyone,

I am trying out the SQL Server R services tutorial on MSDN - link below:

https://msdn.microsoft.com/en-us/library/mt629164.aspx

When I run the rxPredict command:

rxPredict(modelObject = logitObj, data = featureDataSource, outData = scoredOutput,  
          predVarNames = "Score", type = "response",  
          writeModelVars = TRUE, overwrite = TRUE) 

I get the following error:

======  SG01NB-4300092  ( process  1 ) has started run at  2016-07-04 09:43:35.00  ====== 
 
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. 
Caught exception in file: CxAnalysis.cpp, line: 5682. ThreadID: 13560 Rethrowing. 
Caught exception in file: CxAnalysis.cpp, line: 5249. ThreadID: 13560 Rethrowing. 
 
[Microsoft][ODBC Driver Manager] Connection not open 
 
ODBC Error in SQLDisconnect 
Error in doTryCatch(return(expr), name, parentenv, handler) : 
  [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. 
Calls: source ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call 
Execution halted 
Error in rxCompleteClusterJob(hpcServerJob, consoleOutput, autoCleanup) : 
  No results available - final job state: failed

I have made sure that my rxSetComputeContext(cc) is using a valid user login that can create tables. I am also installing SQL Server on the local machine I am working on so it cannot be a network issue.

Has anyone encountered this issue and manage to run this statement successfully?

Thanks for any replies and help!

Ian

解决方案

Hi everyone,

I found that the problem lies with outData = scoredOutput statement. If I set the outData=NULL and change the server context to local, I am able to generate an output from rxPredict.

What I decided was to then execute the rxPredict with the rxSetComputeContext("local") get the output data frame (outDF) and then save it back to the SQL Server using rxDataStep(inData = outDF, outFile = scoredOutput, overwrite=TRUE)

If anyone has a better approach please let me know!

Thanks

Ian

这篇关于rxPredict抛出SQL Server不存在或访问被拒绝错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！