Skip to Content
author's profile photo Former Member
Former Member

JDBC Outbound Adapter Problems

Posted on Jun 29, 2004 at 10:40 AM 24 Views

Hello

We have a problem with our Outbound JDBC Adapter. This Adapter writes IDOC's into a ORACLE-Database.

After a certain amount of records the procedure breaks down with the error: ORA-08177: can't serialize access for this transaction.

Here is the configuration of the adapter out of the adapter-engine:

  1. jdbc adapter java class

classname=com.sap.aii.messaging.adapter.ModuleXMB2DB

mode=XMB2DB_XML

##Adress for XMB endpoint

XMB.httpPort=8210

XMB.httpService=/db/Receiver

##DB Adapter specific parameters (example for SQL-Server, see docu)

db.jdbcDriver=oracle.jdbc.driver.OracleDriver

db.connectionURL=jdbc:oracle:thin:sapxi/sapxi@migzx100.migros.ch:1521:gdmgbbw

SAP Process Integration
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Andrzej Filusz
    Andrzej Filusz
    Posted on Jun 29, 2004 at 12:32 PM

    Hi!!!

    1. Which version of Oracle database do you use?

    2. Are you sure that your db was patched? There is a patch for a bug that causes ORA-08177.

    3. Which transaction isolation level do you use? I suppose that SERIALIZABLE, cos Oracle generates ORA-08177 error when a serializable transaction tries to update or delete data modified by a transaction that commits after the serializable transaction began.

    Regards,

    Andrzej Filusz

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Andrzej Filusz
      Jul 01, 2004 at 09:19 AM

      Hi!

      I have get a message from SAP Support. There was a developer, his send me solution for my problem. The problem is that at the sp4, is a parameter name db.transactionIsolation default on SERIALIZABLE, this was not in sp3. The solution is that you can change the parameter with 0,1,2,4 und 8

      (0 -TRANSACTION_NONE ..

      1 - TRANSACTION_READ_UNCOMMITED,

      2 - TRANSACTION_READ_COMMITED,

      4 - TRANSACTION_REPEATABLE_READ,

      8 - TRANSACTION_SERIALIZABLE)

      For my problem i must change the parameter to

      db.transactionIsolation=2

      in my Adapter script and it is running. Great!!!!!

      About this Parameter, you can read in the new document SAP XI 2.0 SP5, but i don' t have it. I hope, i get this document from SAP

      Regards Thomas Neuhaus