Skip to main content
Solved

RCaller - error in library ("sqldf")

  • September 20, 2017
  • 7 replies
  • 108 views
willydevera
Contributor
Forum|alt.badge.img+9

Hi,

I am getting this error message when running FME script with RCaller transformer:

"RCaller(InlineQueryFactory): InlineQueryFactory failed with exit code 1 when executing R script. Output was: Error in library("sqldf") : there is no package called 'sqldf'

Execution halted

InlineQueryFactory failed to execute scripted code.

RCaller(InlineQueryFactory): A fatal error has occurred. Check the logfile above for details"

I have the following settings in FME Options:

R Interpreter Path:

C:\\Program Files\\R\\R-3.2.2\\bin\\x64\\Rscript.exe

Shared FME Folders:

H:\\My Documents\\R\\win-library\\3.2\\sqldf

Please advise whatever I'm missing here.

Thanks,

Wilfredo

Best answer by LizAtSafe

Hi @willydevera, 

You need to open up R Studio or whatever program you use to write your R code and add the package. All R packages need to be installed within R before they can be called in FME. 

In R Studio:

install.packages('sqldf') 
library('sqldf')

After you call library('sqldf') then R will tell you if you need to install any other packages, continue installing the packages and checking with library until there are no error messages, 

Then you should be able to run your workspace in FME. 

View original
Did this help you find an answer to your question?

7 replies

LizAtSafe
Safer
Forum|alt.badge.img+15
  • LizAtSafeSafer
  • Safer
  • Best Answer
  • September 20, 2017

Hi @willydevera, 

You need to open up R Studio or whatever program you use to write your R code and add the package. All R packages need to be installed within R before they can be called in FME. 

In R Studio:

install.packages('sqldf') 
library('sqldf')

After you call library('sqldf') then R will tell you if you need to install any other packages, continue installing the packages and checking with library until there are no error messages, 

Then you should be able to run your workspace in FME. 

nathanatsafe
Safer
Forum|alt.badge.img+7
LizAtSafe wrote:

Hi @willydevera, 

You need to open up R Studio or whatever program you use to write your R code and add the package. All R packages need to be installed within R before they can be called in FME. 

In R Studio:

install.packages('sqldf') 
library('sqldf')

After you call library('sqldf') then R will tell you if you need to install any other packages, continue installing the packages and checking with library until there are no error messages, 

Then you should be able to run your workspace in FME. 

Also don't forget to install the package as an administrator. FME can't access an R package that is installed in a User library!

 

 

willydevera
Contributor
Forum|alt.badge.img+9
  • willydeveraContributor
  • Author
  • Contributor
  • September 21, 2017
LizAtSafe wrote:

Hi @willydevera, 

You need to open up R Studio or whatever program you use to write your R code and add the package. All R packages need to be installed within R before they can be called in FME. 

In R Studio:

install.packages('sqldf') 
library('sqldf')

After you call library('sqldf') then R will tell you if you need to install any other packages, continue installing the packages and checking with library until there are no error messages, 

Then you should be able to run your workspace in FME. 

Thanks Liz.  I will have to request IT to install the packages as Administrator.  I have already installed the packages on R however as user and it didn't work. Will apprise you as the IT request is taking a while :-)

 

 

S

Hi All,

I do get the error when trying to call library(Sqldf).

Loading required package: sqldf Warning messages: 1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, : there is no package called ‘sqldf’

LizAtSafe
Safer
Forum|alt.badge.img+15
  • LizAtSafeSafer
  • Safer
  • October 11, 2017
sasidharayyagar wrote:

Hi All,

I do get the error when trying to call library(Sqldf).

Loading required package: sqldf Warning messages: 1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, : there is no package called ‘sqldf’

Installing the sqldf package needs to be done in R Studio first before FME can access it.

 

 

Here is a link to the RCaller documentation which goes through how to set up the required packages in more detail. There is also a great RCaller tutorial series which I would recommend checking out.

 

 

Hope that helps!

 

 

-Liz

 

willydevera
Contributor
Forum|alt.badge.img+9
  • willydeveraContributor
  • Author
  • Contributor
  • October 26, 2017
willydevera wrote:
Thanks Liz. I will have to request IT to install the packages as Administrator. I have already installed the packages on R however as user and it didn't work. Will apprise you as the IT request is taking a while :-)

 

 

Hi Liz & Nathan,

 

 

Folks, I just want to thank you again - the RCaller transformer works.

 

 

As of today October 26, 2017, IT has just installed R and its library packages as Administrator in my machine. I tested the FME script that has RCaller transformer and it worked! I no longer get that "sqldf" error. :-)

 

 

Kind regards,

 

 

 

Wilfredo

 

 

LizAtSafe
Safer
Forum|alt.badge.img+15
  • LizAtSafeSafer
  • Safer
  • October 27, 2017
willydevera wrote:
Hi Liz & Nathan,

 

 

Folks, I just want to thank you again - the RCaller transformer works.

 

 

As of today October 26, 2017, IT has just installed R and its library packages as Administrator in my machine. I tested the FME script that has RCaller transformer and it worked! I no longer get that "sqldf" error. :-)

 

 

Kind regards,

 

 

 

Wilfredo

 

 

 

@willydevera,

 

Excellent! Glad this worked for you

 

-Liz

Reply


Helpful Members This Week

Community Stats

31,486
Posts
119,369
Replies
39,107
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.