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

JDBC Outbound Adapter Problems

Posted on Jun 29, 2004 at 10:40 AM 30 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

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

    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 a 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

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.