Need to customize P03B102 to update F03B11 & having problems Table I/O

dfrom1988

Member
Problem Description: I need to update the F03B11 in the P03B102. I am updating the file in the OK "Post Button Pressed" button Pressed after the F03B11 has been updated in the table. The problem is that the Table I/O update is not being processed and is locked on the UPDATE statement.
The Update is after the file has been updated and the Cache is destroyed.

"Call the B03B0158 function to destroy the entry cache.
///
Receipts Entry Destroy Cache"

In the debug log the program stops on the TABLE UPDATE that I put in and does not move to the next statement no matter how long I wait.
If I kill the program after 1/2 plus hour the program back outs out all the previous table entries including the F03B11 and F03B14 records.
=======================================================================
FORM: Receipt Entry [HEADER DETAIL] (W03B102E)
=======================================================================
CONTROL: HYPITEM &OK
EVENT: Post Button Clicked
-----------------------------------------------------------------------
>>>>>> SKIPPED CODE >>>>>>>>>>
If VA frm_TypeTransaction is not equal to <Blank>
And VA frm_TypeTransaction is not equal to <Null>
F03B13Z2 Process Receipt Header Outbound Transaction
End If
End If
End If
If SL CountryCode is not equal to <Blank>
And SL CountryCode is not equal to <Null>
Plug & Play - P03B103 Country Server Exits
End If
//
B03B0069 function to maintain unapplied cash.
//
F03B14 Maintain Unapplied Cash
//
// ... Call the B03B0158 function to destroy the entry cache.
//
Receipts Entry Destroy Cache
//
// Update the RU document type using the Balance Sheet Business Unit for the
// company on the receipt. Both the F03B11 and the F03B14 tables.
//
F03B11.Select
F03B11.Select
F03B11.Fetch Next
F03B11.Update
 
Try moving your logic to ADD Grid rec to DB-Before ER, right after commit receipt detail BSFN.

You need to create a NER for the F03B11 Update. Called the NER using the Include in transaction check box.

The reason your application was stuck because it was a causing a block on F03b11 Table. Using the NER would remove the blocking and include the the table IO in the same transaction processing.

Thank you
Bondlela.
 
Hi dfrom1988,

This is typically a Transaction Handling issue, which had been discussed more times, here on Developers Forum.

Short Suggestion:
- Open the table with Include Transaction Advanced option before your Table I/Os
- Close the able after your Table I/Os.

Regards,

Zoltán
 
Thanks - Zoltan and Bondlela !!!!!!!!
I will try this ASAP. I thought it had to do with transaction processing but was unsure. The main thing was if I killed the job all the records were backed out (something Transaction Processing does on failure).

Ya'll are my hero's!!!!!
 
Back
Top