Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 23

Thread: P4205 locked after TR upgrade

  1. #1
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    580

    P4205 locked after TR upgrade

    Dear All,
    I'm working on TR upgrade 8.96 to 8.98.1.4 on 8.10 release running without web applications.

    The only issue occured is related to P4205 program.

    Running this app on new TR sometimes (5-10 per day) customer reports a unusual blocking status of the client after shipping confirmation (no jde.log information found). Transaction goes ok but application is blocked and users need to close JDE and log again into the system.

    I was unable to reproduce the error with jdedebug activated (and from this i assume some sync/async issue but i'm not sure). So i decide to switch one citrix server to the old TR and in this condition program works fine (tested by the users for different days).

    Did you have any suggestions about this issue?
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  2. #2
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,041

    Re: P4205 locked after TR upgrade

    This is a long-shot, but one thing I've had to do many times -- delete all user overrides for P4205 (and any other programs being used by it). User overrides (aka grid formats) have historically been very touchy, especially whilst upgrading tools releases.
    Don Sauve
    Wagstaff, Inc.
    E1 9.0, Win2008, Oracle 11.2.0.1, TR 9.1.4.4, WebLogic 10.3.5, BI Publisher

  3. #3
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    580

    Re: P4205 locked after TR upgrade

    Very good suggestion Don, many thnaks, but unfortunately it doesn't works.
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  4. #4
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: P4205 locked after TR upgrade

    Hi Bruno,

    Have you any customization/mods on P4205?
    Mainly in Button Clicked / Post Button Clicked events of OK button.

    Regards,

    Zoltán
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

  5. #5
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    580

    Re: P4205 locked after TR upgrade

    Hi Zoltan,
    of course, it was customized

    Next step in my test will be to move the code after the end doc to the post commit event but if it's a bsfn error i aspect some suggestion from jde.log but no information on this file leave me confused.

    I can suppose that a timeout at bsfn execution level can left the log without indication but not sure about this so jde.ini timoute increasing can be another way to find more info.

    If you have any idea............. i'm ready to try!!!!

    Thanks for your interest and best regards
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  6. #6
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: P4205 locked after TR upgrade

    Hi Bruno,
    Which event your customization is in?
    What does your customization?

    Do you Update some fields (with Table IO or with custom BSFN)in a table which is also handled by P4205?

    First check all Synch/Asynch and Include Transaction settings of the original BSFN calls.

    Waiting your reply and the further information to help you.

    Regards,

    Zoltán
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

  7. #7
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    580

    Re: P4205 locked after TR upgrade

    Well Zoltan,
    just looked at the code, it's realy a bad affair.

    ShipConfirm End doc was turned in SYNC mode and it's not in transaction, then there are differetn Table IO to F4211 and F4311 and other custom table, some custom BSFN call and some form interconnect to other screens.
    That's all.
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  8. #8
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: P4205 locked after TR upgrade

    Hi Bruno,

    [ QUOTE ]
    ShipConfirm End doc was turned in SYNC mode

    [/ QUOTE ]

    Then this in the Post Button Clicked event.

    Q1.) Have you checked the Button Clicked event too - here just for Include Transaction?

    Q2.) Are there other original BSFN call in tzhe event (in both)? f yes, what are their settings?

    Q3.) Is there any Open/Close statement for your custom TableIOs?

    Q4.) Are your all customization at the end of the event, after the original code?

    Q5.) What are the options in your custom BSFN call(s)?

    Regards,

    Zoltán
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

  9. #9
    Member 78aspide78's Avatar
    Join Date
    Mar 2008
    Location
    Italia
    Posts
    580

    Re: P4205 locked after TR upgrade

    Thanks for the response,

    1) In button clicked event BSFN are not included in transaction too
    2)i found the original EndDoc commented in the post button event and in this call include in transaction is enabled, in button cliecked i'm not sure because i see no comment.

    3) no open/close statement

    4)Not at all, some minor code beafore the original code (IO on F4211 and F4311 file)

    5) custom BSFN are called without include in transaction flag except a removeObjectReservation that i see with include in transaction flag.

    I'm not the developer of this code so realy not understand all the scope of the code (it was customized from client dusirng the years)

    Do you think can be a sync/async issue?
    E1 9.1 - TR 9.1.4.4 AS400 + WIN2008 - WAS 8.5

  10. #10
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: P4205 locked after TR upgrade

    Hi Bruno,

    [ QUOTE ]
    Do you think can be a sync/async issue?

    [/ QUOTE ]

    No, I suppose this is a Transaction Handling / Record Locking issue.

    What am I already know about your scenario - is a bit confused to me.

    Can you attach the code of both event of OK?
    Can I see, which are the custom code?
    Can you include the setting for each BSFN call?

    Regards,

    Zoltán
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Locked Rows" table
    By Frosty the Coder in forum JD Edwards® EnterpriseOne Applications
    Replies: 2
    Last Post: 11-30-2010, 09:32 AM
  2. Locked "IF" statements
    By Frosty the Coder in forum JD Edwards® EnterpriseOne Developers
    Replies: 3
    Last Post: 05-06-2008, 03:03 PM
  3. Locked Work Order
    By DMiller in forum JD Edwards® EnterpriseOne Applications
    Replies: 3
    Last Post: 04-06-2004, 02:34 AM
  4. next number locked
    By bee in forum JD Edwards® EnterpriseOne
    Replies: 4
    Last Post: 02-04-2002, 07:15 AM
  5. PO Locked
    By jberry123 in forum JD Edwards® EnterpriseOne Developers
    Replies: 1
    Last Post: 02-22-2001, 08:28 PM

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, Oracle or Peoplesoft.