Batch Headers Stuck "In Use"

[markdcci]

Batch Headers Stuck \"In Use\"

Two or three batch headers (out of hundreds) per month are getting stuck in use. No users are actually using the batch and neither the OneWorld application or even a direct database update allows me to change the status. It appears that a JDENET_K job is locking the record in F0011, presumably for a pending roll back, although why it doesn't roll back is beyond me. When we IPL our AS400 weekly and bring OneWorld services down it clears the locks. Anyone out there ever have a similar problem?

OneWorld XE, SP22
AS400 V5R1

 

[cshall]

RE: Batch Headers Stuck \"In Use\"

Since we upgraded to 8.10 in November, we have 8 to 10 batch headers "In
Use" per DAY! Mostly "O" and "N" batches but it happens in all batch types.
We also have one or 2 batches that create daily with NO Batch Headers and
have to add them back. No one seems to know why. We have daily procedure
to check for the these "In Use" batches every morning and then approve and
post. We also have a report that lists the batches created without headers
so we can re-create the header and then post those as well.

We would also welcome any suggestions as this is now additional daily
maintenance time for something that shouldn't be happening.

CS Hall
Enterprise One 8.10
Citrix

 

[zhusain90]

Re: Batch Headers Stuck \"In Use\"

Was having the same issue of Batches "In Use" with Oneworld Xe SP21 - Windows 2000/SQL Server environment.

Turned out most of the time the users were not exiting out of the JDE screens using the "Close" button -- but used the "x" button to close the window.

Retrained the users to use the "Close" button on the forms.

Further, implemented a Trigger on the F0011 table to capture - before & after snapshots of all batch transactions. This provided an easy way to recreate Batch Headers or invetigate sequence of steps which lead to a Batch Header going into "In Use" status.