cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

PatrickCulligan
Advisor
Advisor
0 Kudos

HI Guys,

Were ye able to resolve this issue ?

Regards,

Patrick

Former Member
0 Kudos

Hello,

Were you able to solve this?