Error During FTP of Large Files: "java.lang.RuntimeException: Cannot load attachment with dbKey:" (Doc ID 1908685.1)

Last updated on JULY 18, 2014

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, Technology Adapters

FTP Adapter Read as attachment for files greater than 100MB is not working when using BPEL component

Composite involved uses FTP adapter for polling using get operation with Read File As Attachment option and using BPEL component to assign the attachment to another FTP Adapter which is using put option to place the file in remote directory.

Following error is encountered when trying to poll files greater than 100MB.

<messages>
<input>
<Invoke1_Put_InputVariable>
<part  name="body">
<attachmentElement  href="VISAMAST-FTP/SampleFile.txt_1405003560000"/>
</part>
</Invoke1_Put_InputVariable>
</input>
<fault>
<bpelFault>
<faultType>0</faultType>
<remoteFault>
<part  name="summary">
<summary>java.lang.RuntimeException: Cannot load attachment with dbKey: VISAMAST-FTP/SampleFile.txt_1405003560000</summary>
</part>
<part  name="detail">
<detail>Cannot load attachment with dbKey: VISAMAST-FTP/SampleFile_1405003560000</detail>
</part>
</remoteFault>
</bpelFault>
</fault>
<faultType>
<message>0</message>
</faultType>
</messages>

If a smaller file is polled, there is no error as seen below.

<Invoke1_Put_InputVariable>
<part  name="body">
<attachmentElement  href="33B97DF0083911E4BF576F89F1F8C161"/>
</part>
</Invoke1_Put_InputVariable>

ERROR
-----------------------
[2014-07-09T14:44:08.236-05:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.system] [tid: Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms\n] [userId: <anonymous>] [ecid: bb9a209e61fd8dad:5e6aaf23:146b9cb0de4:-8000-0000000002f6187a,0] [APP: soa-infra] [composite_instance_id: 1380377] [composite_name: VISAMAST-FTP!1.0] [component_name: RouteData] Error while invoking bean "cube delivery": Exception not handled by the Collaxa Cube system.[[
an unhandled exception has been thrown in the Collaxa Cube systemr; exception reported is: "java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace DEV_IAS_TEMP

at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStreamContentsForBlobCritical(OraclePreparedStatement.java:8904)
at oracle.jdbc.driver.OraclePreparedStatement.setBlobInternal(OraclePreparedStatement.java:15046)
at oracle.jdbc.driver.OraclePreparedStatement.setBlobInternal(OraclePreparedStatement.java:15056)
:::::::::::::::::::::::::::::::::
Caused by: java.io.IOException: ORA-01652: unable to extend temp segment by 128 in tablespace DEV_IAS_TEMP

at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:350)
at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:200)
at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStreamContentsForBlobCritical(OraclePreparedStatement.java:8888)
... 126 more
Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace DEV_IAS_TEMP

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:822)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8TTILob.write(T4C8TTILob.java:182)
at oracle.jdbc.driver.T4CConnection.putBytes(T4CConnection.java:2901)
at oracle.sql.BLOB.setBytes(BLOB.java:1810)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:335)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms