BSSV: Server failure while executing business function CommitSalesOrder

Hi Guys,

We are trying to process a request xml using SOAPUI, transaction takes a long time and return an error "An explicit transaction has not been committed or rolled back. All transactions must be complete prior to calling finishPublishedMethod. All active transaction boundaries will be rolled back" in response. A custom published BSSV is calling a standard BSSV to create sales order.

After looking at the BSSV logs, we found that error is coming due to server timeout. This issue is very weired because it is happening specifically for two request xmls.

Can someone please help with it?

Also, is it possible to get jdedebug log of complete transaction when we process request using SOAPUI?

System: JDE 9.1
Server: Windows 2012R2

Many Thanks!

-Pratik
 

brother_of_karamazov

Legendary Poster
Hi Guys,

We are trying to process a request xml using SOAPUI, transaction takes a long time and return an error "An explicit transaction has not been committed or rolled back. All transactions must be complete prior to calling finishPublishedMethod. All active transaction boundaries will be rolled back" in response. A custom published BSSV is calling a standard BSSV to create sales order.

After looking at the BSSV logs, we found that error is coming due to server timeout. This issue is very weired because it is happening specifically for two request xmls.

Can someone please help with it?

Also, is it possible to get jdedebug log of complete transaction when we process request using SOAPUI?

System: JDE 9.1
Server: Windows 2012R2

Many Thanks!

-Pratik

Is the Sales Order committing at the database?
 
Yes, Sales Order is committing but getting rolled back after sometime. We have captured jde log and found update operation is failing on table F03012 because it is in use.

Also, this issue is specifically for one sold to address#, all others are working fine with similar set of items.
 
Discover how to build no-code data integrations and business process automations.

brother_of_karamazov

Legendary Poster
Yes, Sales Order is committing but getting rolled back after sometime. We have captured jde log and found update operation is failing on table F03012 because it is in use.

Also, this issue is specifically for one sold to address#, all others are working fine with similar set of items.


Sounds like something has that particular record locked.
 
We have identified there was an exclusive lock on table F03012 at the record level. We deleted lock and reprocessed same xml, it failed again because there was similar record level lock on F03012. The transaction itself was putting a lock on table and failing to process further which was resulting a transaction rollback. To find root cause of issue, we tried reprocessing and deleting locks for few days and suddenly couple of days back, orders are getting created without any issue. We are not sure what was the root cause of it.

Have you ever come across such scenario?

Thanks in advance and apologies for late replies.
 
Top