AnsweredAssumed Answered

Error sap Conection, Pentaho Server CE 8.1

Question asked by Alexis Araya on Oct 16, 2018

Hi guys,

I am trying to connect pentaho server, with an SAP ERP instance, in client PDI connects without problem, but when executing a job or transformation on the server I get the following error.

 

java.lang.RuntimeException: Unable to create the destination file R3_QAS.jcoDestination
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.save(SAPConnectionImpl.java:158)
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.open(SAPConnectionImpl.java:83)
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.open(SAPConnectionImpl.java:65)
at org.pentaho.di.trans.steps.sapinput.SapInput.init(SapInput.java:180)
at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.FileNotFoundException: R3_QAS.jcoDestination (Permission denied)
at java.io.FileOutputStream.open0(Native Method)
at java.io.FileOutputStream.open(FileOutputStream.java:270)
at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.save(SAPConnectionImpl.java:154)
SAP_CEPC - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Step [SAP Input CEPC.0] failed to initialize!
ERROR [PdiAction] Kettle.ERROR_0011 - [es_335] Could not prepare transformation for execution

 

R3_QAS is SAP conection name.

in folder /opt/tomcat/lib Copy the libraries to tomcat folder lib

tomcat tomcat 1482226 Oct  3 18:47 sapjco3.jar

tomcat tomcat 5407699 Oct  3 18:36 libsapjco3.so

 

Any ideas? Thank you

Outcomes