Skip to Content
avatar image
Former Member

Long running background jobs for standard jobs.

Hi experts,

I am facing a problem on background jobs for standard jobs. after scheduling the default schedule the standard jobs, the background jobs never completed/finishes, its running all the time, i have tried to schedule those from 000 by DDIC and also from running client by admin user but all over the same result. every time i have to manually kill the jobs from OS level. suppose the job number 20 is running for 57133 seconds long. until i kill it it will keep on running.

Please let me know what could be the solution.

Thanks

RAIM

B_jobs.JPG (45.8 kB)
B_jobs.JPG (45.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 10, 2013 at 05:44 AM

    Thanks Every body,

    I have just got the solution  by making the host system default at DB02

    The process is as bellow:

    GO to DB02>System Configuration > Select the Current system > Click on Default System Button.

    So the default icon will appear at default column. and again start the RSCOLL00 program for job SAP_COLLECTOR_FOR_PERFMONITOR. now its taking max 40 seconds to complete. and having data at STAD, ST03n as you see the following screen shoot at current data and time:

    My observation: Previously the system was not connection to the default database. after making it as default it directly connects the default system at first.

    Thanks

    RAIM


    db02.JPG (27.4 kB)
    st03n.JPG (96.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2012 at 08:48 AM

    Hi,

    Please check if Note 1233020 - RSORACOL allocates entire memory is relevant to your issue.

    Regards,

    Roman

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Divyanshu Srivastava

      Hi Srivastava,

      01.Why it is showing two systems.... BCP and BPP ??

           The process is running in BCP system only and the BPP is my remote database for SAP      EP server.

      02. What are the values of stat/files and stat/max_files, size of data directory, can you see and new stat files created in that location.

          

           New STAT file is also creating on the location

      and the directory is used only 42%.

      03. which DB are u using?

           I am using ORACLE 10.2.0.4

  • avatar image
    Former Member
    Dec 09, 2012 at 06:28 AM

    Hello,

    The job is still running after it scheduled by manually not its running for 163019 seconds.

    Please let me know how to digg in to the error log or solve it.

    Thanks

    RAIM


    Capture2.JPG (16.4 kB)
    Capture.JPG (15.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 09, 2012 at 04:35 PM

    have you checked oracle trace file( alert SID)?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello RAIM,

      Which system is this occuring in?  Does it occur in the other systems as well?  If not, what is different?

      -John

  • Jan 09, 2013 at 12:10 PM

    Please do not open a new thread just update this one.

    Regards, Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2013 at 12:49 PM

    Hello,

    This occur in production system. other systems are ok. the 2 months ago i have shutdown all the systems for maintenance. and after make all the systems up, this problem started in production system only.

    i didnt do any patch or note has been applied during this period.

    Thanks

    RAIM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Reagan Benjamin

      Hi RB,

      01. UNDO tablespace usage?

           The UNDO tablespace is used only 2%.

      02. Didn't find any abnormal in trace file.

      Thanks

      RAIM

  • avatar image
    Former Member
    Jan 10, 2013 at 09:17 AM

    Thanks for sharing the solution.

    Add comment
    10|10000 characters needed characters exceeded