EOIO issue

[Former Member]

Hi,

  while processing 2 GB file from sender file channel am facing some issue. as I used EOIO in file cc.

  Am attached the error . Am expecting to increase the tablespace. there is issue from DB end in PI. Please confirm.

Error: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not assign next EOIO sequence number for SC: XI_OUTBOUND_BOM__GTQ100_Q. Reason: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not insert message 0c445fc0-e736-11e3-8561-00000924352b(OUTBOUND) into database. Reason: java.sql.SQLException: caused by java.io.IOException: ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517) at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:214) at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java:144) at com.sap.sql.jdbc.oracle.Oracle10gPreparedStatement.convertStreamToBlob(Oracle10gPreparedStatement.java:415) at com.sap.sql.jdbc.oracle.Oracle10gPreparedStatement.setBinaryStream(Oracle10gPreparedStatement.java:175) at com.sap.sql.jdbc.direct.DirectPreparedStatement.setBinaryStream(DirectPreparedStatement.java:830) at com.sap.sql.jdbc.common.dispatch.BlobHostVariable.setBinaryStream(BlobHostVariable.java:125) at com.sap.sql.jdbc.common.dispatch.SetterDispatcherImpl.setBinaryStream(SetterDispatcherImpl.java:76) at com.sap.sql.jdbc.common.CommonPreparedStatement.setBinaryStream(CommonPreparedStatement.java:802) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.setBinaryStream(PreparedStatementWrapper.java:517) at com.sap.engine.messaging.impl.core.store.MessageStore.insertMessage(MessageStore.java:482) at com.sap.engine.messaging.impl.core.store.MessageStore.putMessage(MessageStore.java:321) at com.sap.engine.messaging.impl.core.MessageController.putMessageInStore(MessageController.java:146) at com.sap.engine.messaging.impl.core.MessageController.putMessageInStore(MessageController.java:129) at com.sap.engine.messaging.impl.core.store.access.StoreAccess.assignSequenceNumber(StoreAccess.java:392) at com.sap.engine.messaging.impl.core.service.Send.execute(Send.java:187) at com.sap.engine.messaging.impl.spi.ServicesImpl.send(ServicesImpl.java:226) at com.sap.aii.adapter.xi.ms.XIMessage.prepareAndSend(XIMessage.java:2521) at com.sap.aii.adapter.xi.ms.XIEventHandler.onSend(XIEventHandler.java:254) at com.sap.engine.messaging.impl.api.ConnectionImpl.send(ConnectionImpl.java:181) at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process_sender(CallAdapterWithMessageBean.java:383) at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:211) at sun.reflect.GeneratedMethodAccessor7796.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:74) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:191) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:23) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133) at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164) at $Proxy316.process(Unknown Source) at com.sap.aii.af.app.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:290) at sun.reflect.GeneratedMethodAccessor4115.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:74) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:191) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:23) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16) at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:179) at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133) at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164) at $Proxy304.process(Unknown Source) at com.sap.aii.adapter.file.File2XI.send(File2XI.java:3519) at com.sap.aii.adapter.file.File2XI.processFileList(File2XI.java:1315) at com.sap.aii.adapter.file.File2XI.invoke(File2XI.java:630) at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:532) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280)

[Harish · Accepted solution]

Hi Aman,

It is suggest to use chunk mode for big files and 2 GB is huge size. Please refer the below blogs

regards,

Harish

[Former Member · Accepted solution]

is it works if FCC is there and mapping? as per one thread its showing like

As per the above screenshots, the split never cosiders the payload. It's just a binary split. So the following limitations would apply

• Only for File Sender to File Receiver
• No Mapping
• No Content Based Routing
• No Content Conversion
• No Custom Modules

so am using FCC in sender channel. so will it work for me?

[Harish · Accepted solution]

Hi Aman,

If you need mapping then you can not use the chunk mode.

The issue is with table space. please Check the Note 659946 - FAQ: Temporary tablespaces, and find the title ORA-01652.

regards,

Harish

[Former Member · Accepted solution]

Thanks Harish,

  am trying to increase tablespace from DBA end. lets see. Thanks once again for help.

[Former Member · Accepted solution]

Its working by increasing tablespace.