Unable to upload large size TPZ files

[Former Member]

Hi Experts,

We are trying to upload TPZ files thorugh Intergeration Builder. Small sized files (<2MB) are go through. But the big files are giving dump. Any idea to resolve the issue?

application.log:

-

---

(PropagatableProvider.java:821)

at com.tssap.dtr.pvc.objectpers.Propagator.import_(Propagator.java:104)

at com.sap.aii.ib.server.propagation.PropagatorImpl.importXiContent(PropagatorImpl.java:233)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.aii.ib.server.pvcadapt.PvcTransactionControlProxy.invoke(PvcTransactionControlProxy.java:79)

at $Proxy2669.importXiContent(Unknown Source)

at com.sap.aii.ib.server.propagation.Propagator.importXiContent(Propagator.java:92)

at com.sap.aii.ib.server.transport.impl.pvc.GenPvcTransport.genPvcImport(GenPvcTransport.java:65)

at com.sap.aii.ibrep.server.transport.impl.pvc.RepPvcTransport.pvcImport(RepPvcTransport.java:94)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.pvcImport(TransportServiceImpl.java:872)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.importZippedStream(TransportServiceImpl.java:955)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.importFromImportSource(TransportServiceImpl.java:668)

at com.sap.aii.ib.server.transport.TransportServiceBean.importFromImportSource(TransportServiceBean.java:189)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:43)

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

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

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

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

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

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

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 $Proxy1782.importFromImportSource(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:234)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:351)

at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:70)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:62)

at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:37)

at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:872)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:53)

at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:58)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:108)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:304)

Caused by: com.sap.sql.log.OpenSQLException: Connection object com.sap.sql.jdbc.common.CommonConnectionImpl@2e0c74fa has already been closed.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:95)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:188)

at com.sap.sql.jdbc.common.CommonConnectionImpl.validate(CommonConnectionImpl.java:1418)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(CommonConnectionImpl.java:1497)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:258)

at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:79)

at com.sap.aii.utilxi.sql.api.StatementWrapper.get(StatementWrapper.java:94)

... 84 more

##

#1.5 #00215E34DD6E003E0000C311000001BE00DD862D8A2A871A#1248266658451#/Applications/ExchangeInfrastructure#sap.com/com.sap.xi.repository#Transport#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003b49]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error#1#Transport#Java###Unable to save Process Integration Scenario IntegrationOfExternalWarehouseManagementSystem_V3 | http://sap.com/xi/APPL/Global2. Reason: Connection object com.sap.sql.jdbc.common.CommonConnectionImpl@2e0c74fa has already been closed.##

#1.5 #00215E34DD6E003E0000C315000001BE00DD862D8A2A871A#1248266658464#/Applications/ExchangeInfrastructure/Pvc#sap.com/com.sap.xi.repository#com.tssap.dtr.pvc.basics.transaction.StatementReleasingConnection#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003b49]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error#1#com.tssap.dtr.pvc.basics.transaction.StatementReleasingConnection#Plain###execution of Statement failed com.sap.sql.log.OpenSQLException: Statement object com.sap.sql.jdbc.common.CommonPreparedStatement@4866e68d has already been closed.#

-

---

defaultTrace.trc:

-

---

#1.5 #00215E34DD6E003E0000C394000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:62)#

#1.5 #00215E34DD6E003E0000C395000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:37)#

#1.5 #00215E34DD6E003E0000C396000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:872)#

#1.5 #00215E34DD6E003E0000C397000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:53)#

#1.5 #00215E34DD6E003E0000C398000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:58)#

#1.5 #00215E34DD6E003E0000C399000001BE00DD862D8A2A8743#1248267290563#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.core.thread.execution.Executable.run(Executable.java:108)#

#1.5 #00215E34DD6E003E0000C39A000001BE00DD862D8A2A8743#1248267290564#System.err#sap.com/com.sap.xi.repository#System.err#SHAUNO#15169#SAP J2EE Engine JTA Transaction : [05f24ffffffd6003c4c]#SAPPIDEV_IXD_6235350##04fdecf0768d11de8f3100215e34dd6e#Thread[output,5,Dedicated_Application_Thread]##0#0#Error##Plain### at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:304)#

Kind Regards,

Indrakumar

[Former Member]

Hi,

Finally we have resolved the issue.

We have change the value of OS parameter "QJOBMSGQFL = *WRAP" and rebooted the system. We are using OS/400 and DB400.

The issue, was, the size of thw job message queue has reached it's maximum limit in OS level.

Now, we are able to upload any size of files.

Please refer SAP Note : 428855 - IBM i system values

Kind Regards,

Indrakumar

[marksmyth]

Hello Indrakumar

This error is DB related. I recommend that you apply the latest available DB patches. This should resolve the issue.

Regards

Mark

[Former Member]

Hi Mark,

Thanks for your advise.

We did the changes. But, no go. Alos, we have changed the dbpool paramters in JDBC also. Nothing helped.

The main errors are following:

com.sap.aii.utilxi.misc.api.BaseRuntimeException: javax.ejb.EJBException: nested exception is: com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( SAP J2EE Engine JTA Transaction : [05f24ffffffd600dffffff8f] ) in rollback.

com.sap.engine.services.ts.exceptions.BaseSystemException: Exception ( SAP J2EE Engine JTA Transaction : [05f24ffffffd600dffffff8f] ) in rollback.

at com.sap.engine.services.ts.jta.impl.TransactionImpl.rollback(TransactionImpl.java:893)

at com.sap.engine.services.ts.jta.impl.TransactionManagerImpl.rollback(TransactionManagerImpl.java:443)

at com.sap.engine.services.ejb3.runtime.impl.TransactionAttributeHandler$Required.exit

############################################

com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:304)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: Connection object com.sap.sql.jdbc.common.CommonConnectionImpl@3c40c3f9 has already been closed

#######################################

Any help will be appreciated?

Kind Regards,

Indrakumar

[marksmyth]

Hi Yusuf

Try increasing the Exchange Profile parameter com.sap.aii.ib.client.jnlp.j2se.maxheapsize.

http://<server>:<port>/exchangeProfile

-> IntegrationBuilder

-> com.sap.aii.ib.client.jnlp.j2se.maxheapsize

Regards

Mark