KETTLE调SAP 合并ECCS相关的函数时报错
2025/01/23 17:56:02 - SAP input.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
2025/01/23 17:56:02 - SAP input.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:
2025/01/23 17:56:02 - SAP input.0 - org.pentaho.di.trans.steps.sapinput.sap.SAPException:
2025/01/23 17:56:02 - SAP input.0 - Cannot excute SAP function
2025/01/23 17:56:02 - SAP input.0 - ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
2025/01/23 17:56:02 - SAP input.0 -
2025/01/23 17:56:02 - SAP input.0 -
2025/01/23 17:56:02 - SAP input.0 - Cannot excute SAP function
2025/01/23 17:56:02 - SAP input.0 - ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
2025/01/23 17:56:02 - SAP input.0 -
2025/01/23 17:56:02 - SAP input.0 -
2025/01/23 17:56:02 - SAP input.0 - at org.pentaho.di.trans.steps.sapinput.SapInput.processRow(SapInput.java:123)
2025/01/23 17:56:02 - SAP input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2025/01/23 17:56:02 - SAP input.0 - at java.lang.Thread.run(Unknown Source)
2025/01/23 17:56:02 - SAP input.0 - Caused by: org.pentaho.di.trans.steps.sapinput.sap.SAPException:
2025/01/23 17:56:02 - SAP input.0 - Cannot excute SAP function
2025/01/23 17:56:02 - SAP input.0 - ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
2025/01/23 17:56:02 - SAP input.0 -
2025/01/23 17:56:02 - SAP input.0 - at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.executeFunctionCursored(SAPConnectionImpl.java:353)
2025/01/23 17:56:02 - SAP input.0 - at org.pentaho.di.trans.steps.sapinput.SapInput.processRow(SapInput.java:121)
2025/01/23 17:56:02 - SAP input.0 - ... 2 more
2025/01/23 17:56:02 - SAP input.0 - Caused by: com.sap.conn.jco.JCoException: (104) RFC_ERROR_SYSTEM_FAILURE: ÌîÈëËùÓбØÐèµÄÌõÄ¿×ֶΠ(raised by system PRD|erpprdci)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc.generateJCoException(MiddlewareJavaRfc.java:637)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:1767)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:1107)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:940)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1140)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1114)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.AbapFunction.execute(AbapFunction.java:302)
2025/01/23 17:56:02 - SAP input.0 - at org.pentaho.di.trans.steps.sapinput.sap.impl.SAPConnectionImpl.executeFunctionCursored(SAPConnectionImpl.java:348)
2025/01/23 17:56:02 - SAP input.0 - ... 3 more
2025/01/23 17:56:02 - SAP input.0 - Caused by: RfcException: [PRD|erpprdci]
message: ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
Return code: RFC_SYS_EXCEPTION(3)
error group: 104
key: RFC_ERROR_SYSTEM_FAILURE
Exception raised by PRD|erpprdci
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2070)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:1715)
2025/01/23 17:56:02 - SAP input.0 - ... 9 more
2025/01/23 17:56:02 - SAP input.0 - Caused by: com.sap.conn.rfc.exceptions.RfcGetException: ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcGet.rfcget_gethead(RfcGet.java:479)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcGet.rfcget_run(RfcGet.java:40)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:23)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:33)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:1970)
2025/01/23 17:56:02 - SAP input.0 - ... 10 more
2025/01/23 17:56:02 - SAP input.0 - Caused by:
>RfcIoException:
message: ÌîÈëËùÓбØÐèµÄÌõÄ¿×Ö¶Î
Return code: RFCIO_ERROR_DEALLOCATED_REMOTE_ERROR(33)<
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcIoOpenCntl.ab_rfcread(RfcIoOpenCntl.java:700)
2025/01/23 17:56:02 - SAP input.0 - at com.sap.conn.rfc.engine.RfcGet.rfcget_gethead(RfcGet.java:475)
2025/01/23 17:56:02 - SAP input.0 - ... 14 more
2025/01/23 17:56:02 - SAP input.0 - 完成处理 (I=0, O=0, R=1, W=0, U=0, E=1)
2025/01/23 17:56:02 - CS - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : 错误被检测到!
2025/01/23 17:56:02 - Spoon - 转换完成!!
2025/01/23 17:56:02 - CS - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : 错误被检测到!
2025/01/23 17:56:02 - CS - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : 错误被检测到!
2025/01/23 17:56:02 - CS - 转换被检测
解决:
原因集成帐号为后台帐号从来没有使用过ECCS相关的程序,切换为前台帐号,并使用CXGP:维护一下合并的全局参数默认值。
保存后,再把帐号切换为后台帐号
在KETTLE执行成功。