Oracle AS SAP Adapter - Cannot receive IDOC from SAP over ALE

[Former Member]

Hello all,

I'm trying to send an IDOC from the SAP ERP system towards Oracle AS SAP Adapter which I use inside Oracle BPEL process.

Inside SAP the IDOC is successfully generated and sent as the status is green and sais "IDoc sent to SAP system or external program".

Unfortunately I receive some error in the receiver. Here is the log associated with it:

Fri, 30 May 2008 15:52:59.0248 EEST - Thread[JCO.ServerThread-3,5,main] [info ] [container] [SAP.channel_DEV_Channel] Check: C0A81E0C00C9483FF8A142FF

Fri, 30 May 2008 15:52:59.0342 EEST - Thread[JCO.ServerThread-3,5,main] [debug] [container] [SAP.channel_DEV_Channel] handleRequest called for tid=C0A81E0C00C9483FF8A142FF

Fri, 30 May 2008 15:52:59.0342 EEST - Thread[JCO.ServerThread-3,5,main] [debug] [container] [SAP.channel_DEV_Channel] function call received: IDOC_INBOUND_ASYNCHRONOUS

Fri, 30 May 2008 15:52:59.0342 EEST - Thread[JCO.ServerThread-3,5,main] [debug] [container] [SAP.channel_DEV_Channel] idoc will be XML encoded

Fri, 30 May 2008 15:52:59.0342 EEST - Thread[JCO.ServerThread-3,5,main] [debug] [container] [SAP.channel_DEV_Channel] start converting IDOC to XML

Fri, 30 May 2008 15:52:59.0342 EEST - Thread[JCO.ServerThread-3,5,main] [error] [container] [SAP.channel_DEV_Channel] com.sap.mw.jco.JCO$Exception: (106) JCO_ERROR_RESOURCE: Trying to access row values in a table which does not have any rows yet

at com.sap.mw.jco.JCO$Record.checkRowCapacity(JCO.java:11671)

at com.sap.mw.jco.JCO$Record.getString(JCO.java:12094)

at com.sap.mw.jco.JCO$Field.getString(JCO.java:10386)

at com.ibi.sap.inbound.IdocFunctionTransform.transform2XML(IdocFunctionTransform.java:103)

at com.ibi.sap.inbound.SapInboundAdapter$RfcServer.handleRequest(SapInboundAdapter.java:567)

at com.sap.mw.jco.JCO$Server.dispatchRequest(JCO.java:7504)

at com.sap.mw.jco.rfc.MiddlewareRFC$Server.nativeListen(Native Method)

at com.sap.mw.jco.rfc.MiddlewareRFC$Server.listen(MiddlewareRFC.java:1395)

at com.sap.mw.jco.JCO$Server.listen(JCO.java:7067)

at com.sap.mw.jco.JCO$Server.run(JCO.java:6996)

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

Fri, 30 May 2008 15:52:59.0358 EEST - Thread[JCO.ServerThread-3,5,main] [debug] [container] [SAP.channel_DEV_Channel] Rollback: C0A81E0C00C9483FF8A142FF

Fri, 30 May 2008 15:52:59.0358 EEST - Thread[JCO.ServerThread-2,5,main] [debug] [container] [SAP.channel_DEV_Channel] Confirm: C0A81E0C00C9483FF8A142FF

On the other hand I am able to send IDocs from the Oracle SAP adapter towards the SAP system without any issues.

Please anyone, could you suggest what could be causing this error in the JCo layer?

Best Regards,

Denitsa

Edited by: Denitsa Pelova on Jun 3, 2008 5:33 PM

[Former Member]

Hi Denitsa,

    I am facing problem while sending idoc from Oracle system to R3 system. Can you please let me the config you done for inbound interface in R3 side?

if any doc, you can send me on email..

my mail id : brindaban.hati@gmail.com

Many thanks in advance for your help.

Regards,

Brindaban

[shivhare]

Hi Pelova ,

Can you please tell me config . step for intgrating oracle SAP adapter to SAP ECC ...

Regards,

Amit

[Former Member]

Issue was resolved by using UNICODE for both the RFC connection and RFC listener.

[Former Member]

Hello everyone,

we have been stuck with that error since last week

I posted the error here since the topic seems the closest to what we have: "SAP on Oracle" and didn't find anything about Oracle Application Server SAP Adapter....

Nevertheless today we finally solved the issue - we changed the SAP listener to use UNICODE and specified the RFC connection on the SAP server as UNICODE too.

After that all went normal

Thanks,

Denitsa

[fidel_vales]

Hi,

This looks more an application issue than a database issue (I do not see any oracle error on the trace attached)

> Fri, 30 May 2008 15:52:59.0342 EEST - Threadhttp://JCO.ServerThread-3,5,main error container http://SAP.channel_DEV_Channel com.sap.mw.jco.JCO $Exception: (106) JCO_ERROR_RESOURCE: Trying to access row values in a table which does not have any rows yet

For the error it looks like you try to read something from a table that is empty.

the same error can be found on this [thread|

] on the Java forum. Perhaps it can help you