amwalshjde
Well Known Member
We are getting an error when we try to create various inventory transactions
(for example, inventory transfer). The error occurs when the program tries
to update the Item ledger (f4111). The error we get is that the commit
failed and to look in the jde.log When I do I see an error message for a
duplicate key. I then go to my jdedebug.log and see where it is doing the
insert. First thing I notice is that there are two sql insert statements
back to back in the log. Should there be? If I cut one of them out, and
pasted into SQL and run it, it worked fine, and it was added to the F4111.
I know about the F00022 file and the R4111UK Program. I already ran the UBE,
and then went back and manually (via P00022) and made the value in the
F00022 be higher then the highest in the F4111. Still no luck. I also
noticed that each time I treid to write a record to the F4111, the value in
the F00022 got higher even though it never wrote to the F4111. So now my
value in the F00022 is several numbers higher then the highest number in the
F4111, is that normal?
Any assistance would be appreciated.
B7332 sp 13.1 AS/400 v4r5 (new from v4r4 a week ago) and NT app servers.
Mix citrix and fat client, with problem persisting on both.
Thanks
Aaron
_________________________________________________________
(for example, inventory transfer). The error occurs when the program tries
to update the Item ledger (f4111). The error we get is that the commit
failed and to look in the jde.log When I do I see an error message for a
duplicate key. I then go to my jdedebug.log and see where it is doing the
insert. First thing I notice is that there are two sql insert statements
back to back in the log. Should there be? If I cut one of them out, and
pasted into SQL and run it, it worked fine, and it was added to the F4111.
I know about the F00022 file and the R4111UK Program. I already ran the UBE,
and then went back and manually (via P00022) and made the value in the
F00022 be higher then the highest in the F4111. Still no luck. I also
noticed that each time I treid to write a record to the F4111, the value in
the F00022 got higher even though it never wrote to the F4111. So now my
value in the F00022 is several numbers higher then the highest number in the
F4111, is that normal?
Any assistance would be appreciated.
B7332 sp 13.1 AS/400 v4r5 (new from v4r4 a week ago) and NT app servers.
Mix citrix and fat client, with problem persisting on both.
Thanks
Aaron
_________________________________________________________