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