@rokop I ran the workspace template rcallerlinearregression.fmwt using FME 2019.2 and it seems to work OK.
Perhaps check that FME is pointing to the expected R Interpreter .
The example doesn't require any special packages to be loaded. rcallerlinearregressionwithgroups.fmwt also seems to work fine in FME 2019.2
@rokop I ran the workspace template rcallerlinearregression.fmwt using FME 2019.2 and it seems to work OK.
Perhaps check that FME is pointing to the expected R Interpreter .
The example doesn't require any special packages to be loaded. rcallerlinearregressionwithgroups.fmwt also seems to work fine in FME 2019.2
Hi,
I must have set the interpreter right as it is all working fine outputting 1 attribute to fmeOutput. Also tried both the 32 and 64 bit versions of Rscript. The error i get:
If take off the encircled attribute meanEst it works and the line where it goes wrong then reads instead:
RCaller (InlineQueryFactory): Processing R script
RCaller (InlineQueryFactory): Generating output 'Output' using query 'SELECT * FROM "Output"'
So it seems to fail on the sql when more than 1 attribute is needed.
Cheers,
Robbert
Hi,
I must have set the interpreter right as it is all working fine outputting 1 attribute to fmeOutput. Also tried both the 32 and 64 bit versions of Rscript. The error i get:
If take off the encircled attribute meanEst it works and the line where it goes wrong then reads instead:
RCaller (InlineQueryFactory): Processing R script
RCaller (InlineQueryFactory): Generating output 'Output' using query 'SELECT * FROM "Output"'
So it seems to fail on the sql when more than 1 attribute is needed.
Cheers,
Robbert
@rokop What OS are you running? Also what version of R do you have installed?
Try using Log Debug under Tools - FME Options - Translation tab - Log Message Filter and attach that log to this conversation.
It is odd that changing the order and number of attributes causes the crash. I don't see that here.
Hi Mark,
I'm on Windows 10 Enterprise. Running R-4.2.0 on fme 2019.2.
Please find attached the run log
Cheers,
Robbert
Hi Mark,
I'm on Windows 10 Enterprise. Running R-4.2.0 on fme 2019.2.
Please find attached the run log
Cheers,
Robbert
@rokop Just checking - can you confirm you have installed the sqldf package ?
@rokop Just checking - can you confirm you have installed the sqldf package ?
Perhaps also check that you do not have two versions of R installed
Hi, I have the same problem. The transformer only works when the output data frame fmeOutput only contains a single value. Otherwise it fails with the error
Error in if (fmeOutput != "") dbWriteTable(dbcon, "Output", fmeOutput, :
the condition has length > 1
This screenshot shows it with the only line of code in the RCaller set to:
fmeOutput<-data.frame(numbers=c(1,2,3))
I wonder if an update to one of the packages used by sqldf has caused this to fail. I have the latest version of sqldf installed from Cran today along with dependencies RSQLite, proto, etc.
Hi, I have the same problem. The transformer only works when the output data frame fmeOutput only contains a single value. Otherwise it fails with the error
Error in if (fmeOutput != "") dbWriteTable(dbcon, "Output", fmeOutput, :
the condition has length > 1
This screenshot shows it with the only line of code in the RCaller set to:
fmeOutput<-data.frame(numbers=c(1,2,3))
I wonder if an update to one of the packages used by sqldf has caused this to fail. I have the latest version of sqldf installed from Cran today along with dependencies RSQLite, proto, etc.
Hi @jo-gay Unfortunately the RCaller doesn't work with R 4.2 - FYI the issue is FMEENGINE-73477
@jo-gay @rokop we think we might have addressed this issue in FME 2022.2 - this will be available as a beta download build 22705 or higher. If someone would like to test it when the beta becomes available.
