HELP! - P4312 PO Receipt freeze for a long time

Hi List/Forum,

Running P4312 PO Receipts(G43A11,)pressing OK take a long time to bring up Landed Cost Selection Screen.
Going from one row to the next entering the required data also take a long time on the Landed Cost Selection screen.
Pressing OK again, take a long time while R43512 - Receipt Traveler finishes and the Acrobat is comming up.

While this is happening, nobody else is able to run PO Receipts and it seems so that F43121 file is locked, because it isn't accessible while the whole process finishes.

Platform: B7332, SP11, ESU #4116422 have been applied, SQL7, NT 4.0 Enterprise Server, NT 4.0 Workstations.

This problem is very urgent for us.

Any help, advise will be very appreciated.

Zoltán

Hi List/Forum,
Some additional information to our original problem (please see my original
issue on the end).
I have found a suspicious portion in the debug log (inserted below).
This portion occurs many times in the log (not directly consecutively).
There is always 8-9 second delay at the:
"Data selection processed with high concurrency option."
entry row.
It seems for me that it is extremly high.
What does it mean "high concurrency option"?
Where can I set such kind of option?

Could somebody help us?
Has/Had anybody such kind of problem with P4312 PO Receipt?

Thanks in advance,
Zoltán Gyimesi

Oct 31 17:42:30 ** 293/289 Entering JDB_OpenTable( Table = F4102)
Oct 31 17:42:30 ** 293/289 Entering JDB_FetchKeyed
Oct 31 17:42:30 ** 293/289 Entering GetUserProfileCache
Oct 31 17:42:30 ** 293/289 GetUserProfileCache returns the value from
ghEnv
Oct 31 17:42:30 ** 293/289 Entering GetUserProfileCache
Oct 31 17:42:30 ** 293/289 GetUserProfileCache returns the value from
ghEnv
Oct 31 17:42:30 ** 293/289 RESET: SELECT IBITM, IBMCU, IBSLD, IBSRCE,
IBOT1Y, IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD FROM
PRODDTA.F4102 (NOLOCK) WHERE ( IBMCU = ? AND IBITM = ? )
Oct 31 17:42:30 ** 293/289 SELECT IBITM, IBMCU, IBSLD, IBSRCE, IBOT1Y,
IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD FROM PRODDTA.F4102
WHERE ( IBMCU = ' NET' AND IBITM = 13393.000000 )
Oct 31 17:42:38 ** 293/289 Data selection processed with high
concurrency option.
Oct 31 17:42:38 ** 293/289 SELECT IBITM, IBMCU, IBSLD, IBSRCE, IBOT1Y,
IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD FROM PRODDTA.F4102
(NOLOCK) WHERE ( IBMCU = ' NET' AND IBITM = 13393.000000 )
Oct 31 17:42:38 ** 293/289 Entering JDB_CloseTable( Table = F4102)
Oct 31 17:42:38 ** 293/289 Entering JDB_ClearSequencing
Oct 31 17:42:38 ** 293/289 Entering JDB_ClearSelection
Oct 31 17:42:38 ** 293/289 Entering JDB_FreeBhvr

>

Re: RE: HELP! - P4312 PO Receipt freeze for a long time

Our team is now experiencing the same problem in P4312. This seems to be an past experience for you but if you can remember the steps taken to resolve this issue please forward.

Thank You

Welford

Hello Zoltan

P4312 will run the receipt master business functions IN-LINE if you use R43512 Receipt Traveler; also with landed cost (but not, I don't think about blind landed cost). I think there are one or two other cases. Otherwise it processes the MBF asynchronously.

P4312 is notoriously slow when performing synchronous updates, don't know why. R43512 needs to run after the F43121 and F41021 are updated by the MBF, so that is the thinking behind forcing that one - the job may start before the database is updated correctly.

We use blind landed cost at my current client - landed costs are handled by the MBF - and as for the receipt traveler, we put in code in the Initialize event to check that ALL the data required for the receipt document is present before continuing. Not pretty but it works - even run locally!

Hope this helps.

Ian

Hello. Has anyone reported a reason or solution to the "Data selection processed with high concurrency option" debug message?