Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: Slow UBE - some are very slow....

  1. #1
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,760

    Slow UBE - some are very slow....

    We have a couple UBEs, that run for HOURS.

    R09705 will run, sometimes, for more than four hours... we have a fairly beefy 400 - so the OPS guys want the 'developers' to figure out why the UBE takes so long to process.

    The UBE is not modified - but there are Select statements on the Version
    I have looked at indexes.
    I have looked for inherent issues... can't see any.

    Are some UBE(s) supposed to run for many hours?....

    Daniel

    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  2. #2

    RE: Slow UBE - some are very slow....

    The R09705 compare F0911 to F0902 to check for out of balance period. If
    there are two many records in F0911 and F0902 then it will take long time. I
    would suggest to pass in data selection i.e. compare the last months data.
    There is no use to compare data you have compared before. Use the Actual
    Amount "AA" ledger type to compare or other some other ledger which meet
    your business criteria. There is no need to compare ledgers which would be
    out of balance by design. This should cut down time. If this does not
    work, please let me know at moin@sumcomputers.com. We have done numerous
    things to increase performance and non of our process run for hours.
    Thanks
    Moin


  3. #3

    Re: Slow UBE - some are very slow....

    It shouldn't be a problem with the R09705, but have you considered that some of your slow UBEs might be wasting time waiting for record locks to be released by other processes?

    Do the batches run at the same speed when no one is in the system and nothing else is running?

    --Brian

    ERP 8.0 Update 1 SP22_L_1 AS/400 V5R2 Enterprise Central Objects on Windows 2000 Server WebSphere 4.01 HTML Thin Client

  4. #4
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,760

    Re: Slow UBE - some are very slow....

    I've been watching them - and I don't see any record locking issues.

    These jobs run at night.. and they take, about, the same amount of time each run.

    db
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  5. #5

    Re: Slow UBE - some are very slow....

    Hmm. I have no experience with the R09705 - what are some of the others that are running slowly?

    Making sure that indexes exist for the select/fetch statements is another obvious one, but that shouldn't be much of a problem with base objects.

    --Brian
    ERP 8.0 Update 1 SP22_L_1 AS/400 V5R2 Enterprise Central Objects on Windows 2000 Server WebSphere 4.01 HTML Thin Client

  6. #6
    Senior Member
    Join Date
    Jan 2001
    Location
    Erie, PA.
    Posts
    147

    Re: Slow UBE - some are very slow....

    Some do run for hours.

    When one is in question I usually start with a log to see if there are any unusual delays in SQL or business function calls.

  7. #7
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,760

    Re: Slow UBE - some are very slow....

    I hadn't thought to review the debug log for delays... that is a good catch, I'll look into it some more.

    Has someone released a tool to 'better' read the debug log? I'd heard that there was one - but I hadn't seen a release.

    Thanks

    db
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  8. #8
    Senior Member
    Join Date
    Jan 2001
    Location
    Erie, PA.
    Posts
    147

    Re: Slow UBE - some are very slow....

    I use an Access DB to look for delays. It is attached.

    Open Form1, enter the path and name of the log, hit the parse button.

    You can then look at the tables that are loaded and sort them by the response or delay time to find the long ones.

    It is nothing fancy.
    Attached Files Attached Files

  9. #9
    Senior Member
    Join Date
    Feb 2001
    Posts
    140

    Re: Slow UBE - some are very slow....

    Try the "Performance Workbench" from the KG (Support > performance workbench).

    It will take a log and produce a "call stack" telling you how long each BSFN call lasted

    Best Regards,

    Ian
    Xe SP22_I1, Oracle 9.2, W2K, Jas

  10. #10
    Member
    Join Date
    Aug 2001
    Location
    OR
    Posts
    690

    Re: Slow UBE - some are very slow....

    Never really looked at it before. We run that integrity in World - J09705 and it even takes 5 hours running it this way.
    Jean Driscoll
    Emerald Cube Solutions
    Quest Technology SIG
    Senior AS/400 and CNC support

Thread Information

Users Browsing this Thread

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

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