Originally posted by: johnxp

Hi, we are intermittently having ORA-03135 issue. 

Usually the map will run successfully at first, afterwards we will get error 3135.

Below are the extraction from dbl file:

First run:

<16252964-2314-Tue Feb 21 17:50:34 2017>:    Validating the adapter command...
<16252964-2314-Tue Feb 21 17:50:34 2017>:    Database type is Oracle
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Participating in active transaction.
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Interface library version 8.3.0.4(13)_64bit
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Map: XXX.aix,  Timestamp: Tue Feb 21 17:50:34 2017.
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Data being retrieved for DBLOOKUP function.
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Database adapter: Oracle10g Version 8.3.0.4(13)_64bit
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Starting a database unload...
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Query      : UPDATE XXX SET STATUS = 'XXX', MODIFIED_DATE = CURRENT_DATE, MODIFIED_BY = 'WTX' WHERE ID = 'TT00000000000000004' 
<16252964-4887-Tue Feb 21 17:50:34 2017>:    DBLOOKUP Function, Transaction scope: Map
<16252964-4887-Tue Feb 21 17:50:34 2017>:    TRACE command specified, append mode, file: XXX.dbl
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Statement execution succeeded.
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Retrieved 0 records (0 bytes).
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Returned status: (0) Success
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Cleaning up and closing the transaction...
<16252964-4887-Tue Feb 21 17:50:34 2017>:    The transaction was successfully committed.
<16252964-4887-Tue Feb 21 17:50:34 2017>:    Returned status: (0) Success

...

Second run:

<16252964-2314-Wed Feb 22 08:47:50 2017>:    Validating the adapter command...
<16252964-2314-Wed Feb 22 08:47:50 2017>:    Database type is Oracle
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Connection from pool is being reused.
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Interface library version 8.3.0.4(13)_64bit
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Map: XXX.aix,  Timestamp: Wed Feb 22 08:47:50 2017.
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Data being retrieved for DBLOOKUP function.
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Database adapter: Oracle10g Version 8.3.0.4(13)_64bit
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Starting a database unload...
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Query      : select 'TT'||to_char(MySEQ.nextval,'FM00000000000000000') from dual
<16252964-4887-Wed Feb 22 08:47:50 2017>:    DBLOOKUP Function, Transaction scope: Map
<16252964-4887-Wed Feb 22 08:47:50 2017>:    TRACE command specified, append mode, file: XXX.dbl
<16252964-4887-Wed Feb 22 08:47:50 2017>:    Error returned by OCIStmtExecute, errcode=3135
ORA-03135: connection lost contact
Process ID: 36831238
Session ID: 56 Serial number: 16537

<16252964-4887-Wed Feb 22 08:47:50 2017>:    Returned status: (-13) No error text found

...

Thanks for your help.

Originally posted by: PaulBrettIBM

I recommend you download and apply Service Pack 7:

https://www-945.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Other%20software&product=ibm/WebSphere/WebSphere+Transformation+Extender&release=All&platform=All&function=textSearch&text=8.3.0+&source=fc

Also, review the IdleDB and KeepDB settings in the dtx.ini file.  Perhaps you could try KeepDB=-1?

Thank you.

Paul

Follow me on Twitter