Skip to Content
0

Data Store : JDBC transaction java.sql.SQLException: JZ0C0: Connection is already closed

Apr 25, 2017 at 12:00 PM

130

avatar image
Former Member

Hi

We are getting an error in a flow

An internal server error occured: Sequential processing failed for number 1. Exchange[ID-vsa2219503-od-sap-biz-36519-1493105689938-306-11]. Caused by: [org.springframework.transaction.TransactionSystemException - Could not roll back JDBC transaction; nested exception is java.sql.SQLException: JZ0C0: Connection is already closed.].

In this flow we are looping a process on an xml

This is a loop

This is a process

In the above screenshot you can see a Write data store operation. This operation works only when we run the loop once

<ShipToParty>	
	<urn:ZRfcCustSaleDump
		xmlns:urn="urn:sap-com:document:sap:soap:functions:mc-style">
		<IParvw>WE</IParvw>
		<ISpart>10</ISpart>
		<IVkorg>1000</IVkorg>
		<IVtweg>10</IVtweg>
		<Itab>
		</Itab>
	</urn:ZRfcCustSaleDump>
</ShipToParty>

And does not work when the loop runs more than once

<ShipToParty>
	<urn:ZRfcCustSaleDump
		xmlns:urn="urn:sap-com:document:sap:soap:functions:mc-style">
		<IParvw>WE</IParvw>
		<ISpart>10</ISpart>
		<IVkorg>6451</IVkorg>
		<IVtweg>20</IVtweg>
		<Itab>
		</Itab>
	</urn:ZRfcCustSaleDump>
	<urn:ZRfcCustSaleDump
		xmlns:urn="urn:sap-com:document:sap:soap:functions:mc-style">
		<IParvw>WE</IParvw>
		<ISpart>10</ISpart>
		<IVkorg>1000</IVkorg>
		<IVtweg>10</IVtweg>
		<Itab>
		</Itab>
	</urn:ZRfcCustSaleDump>
</ShipToParty>

Please help resolving the problem

Thank You

ships.png (14.6 kB)
singlepush.png (45.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jun 21, 2017 at 07:38 PM
0

Hello,

Were you able to solve this?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Oct 23, 2017 at 03:45 PM
0

HI Guys,

Were ye able to resolve this issue ?

Regards,

Patrick

Share
10 |10000 characters needed characters left characters exceeded