Results 1 to 7 of 7

Thread: BSSV: Server failure while executing business function CommitSalesOrder

  1. #1

    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
    Regards,
    Pratik P

    Technical Consultant | Release: XE, E8.10, E9.1, E9.2 | DB: Oracle, DB2

  2. #2
    Quote Originally Posted by pratikspandey View Post
    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?

  3. #3
    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.
    Regards,
    Pratik P

    Technical Consultant | Release: XE, E8.10, E9.1, E9.2 | DB: Oracle, DB2

  4. #4
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    978
    Can you successfully take an order for the sold to using the stock JDE SO entry app (P4210)?
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  5. #5
    Quote Originally Posted by pratikspandey View Post
    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.

  6. #6
    Yes Craig. It worked fine using standard SO application.
    Regards,
    Pratik P

    Technical Consultant | Release: XE, E8.10, E9.1, E9.2 | DB: Oracle, DB2

  7. #7
    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.
    Regards,
    Pratik P

    Technical Consultant | Release: XE, E8.10, E9.1, E9.2 | DB: Oracle, DB2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.