Results 1 to 10 of 10

Thread: R03B16 Stats History Update - search for help

  1. #1
    New Member
    Join Date
    Sep 2001
    Location
    NSW SYDNEY AUSTRALIA
    Posts
    9

    R03B16 Stats History Update - search for help

    I have recently begun trying to run the UBE R03B16 to update the F03B16 and F03B16S tables.
    The initial run went for over 8 days and completed successfully.

    In order to promote the process to Production I needed to reduce the runtime, so applied ESUs JD12769,4350,5371 in Dev/Crp.
    This was supposed to speed up the process and prevent the UBE from ending in "error"
    I ran the "repost" R03B163, and have now attempted to rerun R03B16 which so far has been going 2.5 days.

    Table F03B11 has about 7 million records
    Table F03B13 has about 1 million records
    Table F03B14 has about 6 million records

    My questions are;
    Has anyone else gone through the pain of this UBE, and if so, can you provide any help in speeding up the process.
    Have I missed something critical in the process?

    Any help would be greatly appreciated

    B7332 SP11.3 & Sp19.1 NT servers, Oracle8 d/b on p590, Metaframe 1.8
    E812 W2000 servers, Oracle 9I d/b on P590

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,148

    Re: R03B16 Stats History Update - search for help

    This UBE is notorious for running a long time. Our tables are not as large as your's. The first time we ran this it did take considerable tim, I can't remember how long. We run this monthly and it takes about 7 to 8 hours. It could be indexes or something else. Because of our relatively small database the time taken is not a great inconvenience if we run it monhtly. I have heard that some places run ti nightly.

    Table F03B11 has 430,000 records
    Table F03B13 has 171,000 records
    Table F03B14 has 412,000 records
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    Senior Member peterban's Avatar
    Join Date
    Dec 2002
    Location
    Buckinghamshire, England
    Posts
    410

    Re: R03B16 Stats History Update - search for help

    Hi Douglas!

    Thats a fairly chunky database you have there!

    Have you tried splitting the run into multiple versions, each using a subset of the data, say split by gl-offset, or one of the category codes ?

    Warm regards

    Peter

  4. #4

    Re: R03B16 Stats History Update - search for help

    What exactly does the R03B16 do??
    E1 9.1.3
    WebLogic on Win2k8
    AS400 Enterprise Server (V7R1)
    Win2k8 Deployment Server

  5. #5
    New Member
    Join Date
    Sep 2001
    Location
    NSW SYDNEY AUSTRALIA
    Posts
    9

    Re: R03B16 Stats History Update - search for help

    Runs for *&^% hours! ( I have had 8 days before completion!)
    It uses tables such as F03b11,112,13,14 and calculates the Statistical Information for each debtor. There are various calculations to do, some of which can be turned off through processing options.
    None the less, with several million rows in the main tables it seems a ridiculously poor effort by the code.
    I am looking for ways to test the process and hav it in a workable fashion before I promote to production.
    B7332 SP11.3 & Sp19.1 NT servers, Oracle8 d/b on p590, Metaframe 1.8
    E812 W2000 servers, Oracle 9I d/b on P590

  6. #6
    Senior Member Robert Robinson's Avatar
    Join Date
    Oct 2000
    Location
    Toledo, OH
    Posts
    471

    Re: R03B16 Stats History Update - search for help

    The R03B16 is one step in a process to generate A/R statistics via a raft of A/R reports.

    When I tried to set up and run mine (after a conversion from World to OneWorld), the report runs for a very short period of time and contains very few records.

    Is there any tweaking that anyone had to do when running the "stats set" for the first time?
    Robert Robinson
    JD Edwards Business Systems Manager
    Health Care REIT, Inc.
    E1 900, Tools 9.1.3.3
    Oracle 11g, WebLogic 10.3.6.0
    Quest Business Intelligence SIG
    Toledo, Ohio, USA
    Viva la Devolution!

  7. #7
    New Member
    Join Date
    Apr 2004
    Location
    NSW, Australia
    Posts
    1

    Re: R03B16 Stats History Update - search for help

    Did you get any solutions for this problem? My files are no where as big as yours (yet), but the report falls over every time with an error "An Insert or Update failure to the F03B16S or F03B16 has occurred."

    Cheers,
    Matt
    7334 ERP8, AS400

  8. #8

    Re: R03B16 Stats History Update - search for help

    Hi
    I am facing the same problem now. R03B16 ended up with errors after run for 4 days. F03B16 had 3.9 milion records. Have you solved this problem? Can you please share your experience?

    Thanks
    Sathish
    B7333 - SP 19.1

  9. #9

    Re: R03B16 Stats History Update - search for help

    Hi
    Is the ESUs JD12769,4350 and 5371 helping to avoid error's while running R03B16? Is it required to set Date Pattern for all companies?

    Please help me on this issue.

    Thanks
    Sathish

  10. #10

    Re: R03B16 Stats History Update - search for help

    Hi List
    Did anyone found solution to improve the performance of R03B16? I am also facing the same problem that ube runs for 40hrs.

    Thanks
    Prakash
    Xe Update 7 SP22, Co-exist

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.