Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hello,

    Were you able to solve this?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2017 at 03:45 PM

    HI Guys,

    Were ye able to resolve this issue ?

    Regards,

    Patrick

    Add comment
    10|10000 characters needed characters exceeded