community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Error Using In-DB Predictive with SQL Server 2016

Meteoroid

Hey Community! I am attempting to set up SQL Server 2016 and Alteryx to allow Alteryx to use the supported Predictive Tools In-DB. I have successfully installed R Services on the SQL Server and I can use R in SQL Server using the command EXEC sp_execute_external_script  @language =N'R'. When I attempt to use the Alteryx In-DB Predictive Tools I am met with an error "Score_In_DB (8) Score_In_DB: Error in RxInSqlServer(connectionString = con_str, shareDir = temp_path, :"

If anyone could provide insight or a link to documentation/guide on how to setup or troubleshoot Alteryx In-DB tools I would really appreciate it. I have searched for anything with the error in question and Alteryx and I haven't been able to turn anything up.

 

Thank you!

Alteryx
Alteryx

Hi @jut 

 

Which version of Alteryx Designer are you using?

 

Version 2019.2 requires a R Client 3.5 from Microsoft which hasn't been created quite yet.

 

In the meantime, perhaps use Alteryx Designer version 2019.1 to perfrom your In-DB Predictive process.

 

Let me know if this helps.

 

Kind Regards,

 

James Marks

Meteoroid
We are using 2019.2. I will attempt to run the workflow on 2019.1. Thank you!
Meteoroid

James, I tried Alteryx 2019.1 and I received the same error  Score_In_DB (4) Score_In_DB: Error in RxInSqlServer(connectionString = con_str, shareDir = temp_path, :

Anything else I should be looking at to make sure it's all set up correctly? Thanks for your help!

Meteoroid

@JamesMA Sorry forgot to tag you in the previous reply.

Alteryx
Alteryx

Hi @jut - please e-mail support@alteryx.com if you are still having issues with this and Support will look into it.

Labels