kettle调用RFC接口的表参数怎么处理

[mliusq]

遇到一个用kettle调用SAP的RFC接口的问题，其中一个输入参数是表参数，但是在kettle的SAP input控件中获取的参数好像只能是普通的string类型参数，这样的调用这个接口的时候就会报错，错误信息中还有乱码。不知道有没有哪位大神遇到过这种问题，能否给予解答？在下感激不尽！

2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Unexpected error
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - org.pentaho.di.trans.steps.sapinput.sap.SAPException:
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Cannot excute SAP function
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - （乱码，无法通过网页验证）
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 -
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 -
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Cannot excute SAP function
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - （乱码，无法通过网页验证）
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 -
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 -
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at org.pentaho.di.trans.steps.sapinput.SapInput.processRow(SapInput.java:123)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at java.lang.Thread.run(Thread.java:748)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Caused by: org.pentaho.di.trans.steps.sapinput.sap.SAPException:
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Cannot excute SAP function
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - （乱码，无法通过网页验证）
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 -
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.executeFunctionCursored(SAPConnectionImpl.java:353)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at org.pentaho.di.trans.steps.sapinput.SapInput.processRow(SapInput.java:121)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ... 2 more
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Caused by: com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE:
（乱码，无法通过网页验证）
(raised by system QAS|saptst)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc.generateJCoException(MiddlewareJavaRfc.java:677)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:1918)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:1102)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:935)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1467)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1437)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.AbapFunction.execute(AbapFunction.java:300)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.executeFunctionCursored(SAPConnectionImpl.java:348)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ... 3 more
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Caused by: RfcException raised by system [QAS|saptst]:
message: （乱码，无法通过网页验证）
return code: RFC_SYS_EXCEPTION (3)
error group: 104
key: RFC_ERROR_SYSTEM_FAILURE
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2085)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:1858)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ... 9 more
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Caused by: com.sap.conn.rfc.exceptions.RfcGetException: （乱码，无法通过网页验证）
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcGet.rfcget_gethead(RfcGet.java:459)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:35)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:33)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:1982)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ... 10 more
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - Caused by:
>RfcIoException:
message: （乱码，无法通过网页验证）
Return code: RFCIO_ERROR_DEALLOCATED_REMOTE_ERROR(33)<


2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.ab_rfcread(RfcIoOpenCntl.java:706)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - at com.sap.conn.rfc.engine.RfcGet.rfcget_gethead(RfcGet.java:455)
2019/07/13 15:55:28 - SAP input Z_RFC_MC9.0 - ... 13 more

[mliusq]

经过跟RFC接口开发人员确认，出现这个问题是因为调用接口的用户权限不够，给该用户添加了相应的角色权限后问题解决。