Rserve - data transformations - eval failed

Toshimitsu Murakami shared this question 6 months ago
Answered

I saw this article below.

https://community.yellowfinbi.com/topic/rserve-data-transformations-connection-refused


and same error message like this. But I couldn't get returned data. :

YF:2018-05-30 11:34:58: INFO (FileUploadAjaxAction:info) - FileUploadAjaxAction entered

YF:2018-05-30 11:35:01: INFO (RLoader:info) - Initiating Rserve connection..

YF:2018-05-30 11:35:01: INFO (RLoader:info) - Testing Rserve connection..

YF:2018-05-30 11:35:01: INFO (FileUploadAjaxAction:info) - FileUploadAjaxAction entered

YF:2018-05-30 11:35:12: INFO (FileUploadAjaxAction:info) - FileUploadAjaxAction entered

YF:2018-05-30 11:35:12: INFO (AbstractETLCachedStep:info) - Begin processing zendesk

YF:2018-05-30 11:35:12: INFO (AbstractETLCachedStep:info) - Finished processing zendesk in 1ms; Rows Processed: {e37a1b4f-59fd-466d-af2e-ec5c5d23b95b=1199}

YF:2018-05-30 11:35:12: INFO (AbstractETLCachedStep:info) - Begin processing Rスクリプト

YF:2018-05-30 11:35:12: INFO (RStep:info) - Initiating Rserve connection..

YF:2018-05-30 11:35:12: INFO (RStep:info) - Testing Rserve connection..

YF:2018-05-30 11:35:12: INFO (RLoader:info) - Initiating Rserve connection..

YF:2018-05-30 11:35:12: INFO (RLoader:info) - Testing Rserve connection..

YF:2018-05-30 11:35:12: INFO (RStep:info) - Rserve connection established.

YF:2018-05-30 11:35:12:ERROR (RStep:error) - Unable to create R dataframe out of provided table

org.rosuda.REngine.Rserve.RserveException: eval failed

at org.rosuda.REngine.Rserve.RConnection.eval(RConnection.java:234)

at rstep.RStep.processEndRows(RStep.java:423)

at com.hof.mi.etl.step.AbstractETLCachedStep.endRows(AbstractETLCachedStep.java:122)

at com.hof.mi.etl.step.AbstractETLCachedStep.D(AbstractETLCachedStep.java:189)

at com.hof.mi.etl.step.AbstractETLCachedStep.endRows(AbstractETLCachedStep.java:125)

at com.hof.mi.etl.runner.ExecutionHead.call(ExecutionHead.java:29)

at com.hof.mi.etl.runner.ExecutionHead.call(ExecutionHead.java:15)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

YF:2018-05-30 11:35:12:ERROR (RStep:error) - com.hof.mi.etl.ETLException

YF:2018-05-30 11:35:12:ERROR (AbstractETLCachedStep:error) - Error

com.hof.mi.etl.ETLException

at rstep.RStep.processEndRows(RStep.java:432)

at com.hof.mi.etl.step.AbstractETLCachedStep.endRows(AbstractETLCachedStep.java:122)

at com.hof.mi.etl.step.AbstractETLCachedStep.D(AbstractETLCachedStep.java:189)

at com.hof.mi.etl.step.AbstractETLCachedStep.endRows(AbstractETLCachedStep.java:125)

at com.hof.mi.etl.runner.ExecutionHead.call(ExecutionHead.java:29)

at com.hof.mi.etl.runner.ExecutionHead.call(ExecutionHead.java:15)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)


I guess that I can connect Rserve instance. but it doesn't work well.

The message is like 'This step failed process execution due to error. No matches data.' I'm sorry. I use the Japanese language. So This is a free translation.

I use MacOS and attached some screenshot and Rscript.

R version : 3.5.0 Rserve : 1.7.3

Rserve said : long vectors not supported yet: qap_encode.c:36

Fatal error: unable to initialize the JIT


I'm appreciated if you could give me some advice.

Comments (5)

photo
1

Hi Toshimitsu,

I will not have time to investigate this until tomorrow, but this appears to be related to the dataset that you are providing to the R-step.

Are you using the CSV import step, or import from database?

Could you provide me with the dataset that you are using?

Nathan

photo
1

Hi Nathan,

It's Okay. I tried using the single table and report from a database at input step. But I can do that neither.

the data is three or four digits (Numeric).

I attached csv file which is exported. and I tried to replace 'tid' *2.5.

Thanks,

Toshi

photo
1

Hi Nathan,

I found this article. Does this have anything to do with the issue?

https://github.com/s-u/Rserve/issues/102

photo
2

Hi Toshimitsu,

Very sorry for the delay here. The data set you are using looks quite standard, and works on my instance. The article you are referencing does seem appropriate here, but it is difficult to say without trying it.

Does resetting the Rserve instance correct the issue?

Is this the only dataset that this occurs on?

Nathan

photo
1

Hi Nathan,


Thank you for your reply.

I tried some R version. as a result, I could access my local Rserve on R3.4.4.

However, I encountered an error with 'couldn't find a function: withautoprint ' on R3.3.3.


The plugin might be available R3.4~only so far.

Anyway, I appreciate your help, Nathan.


Toshi