Skip to Content

SAPSYS user slowing down SAP System

Dear Experts,


Our SAP DEV System is very slow after a RESTART, user SAPSYS running SAPMSSY2 program in client 000 consuming all the BTC processes and few DIA as well.

I tried following things to resolve :

1. As recommended by note 183648 - SAPMSSY2: long runtime in background process   DERANGEMENTED DISK to just 2% fragmentation now

2."Consistency check DB Tables" terminated with RUNTIME ERROR TIME_OUT.


3. No ARFC jobs are active in sm59


Please suggest to resolve this issue.



Kind Regards,

Domnic.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jul 14, 2015 at 01:55 PM

    Check for issues in the database.

    For eg. a database dead lock.

    Also, share the DB logs once.

    Can you see share the screenshot of dpmon ?

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Experts,

      I have

      1.Restarted the whole system from OS level

      2. Increased Processes and Sessions

          a. old value processes =80

              new value = 115

          b. old value =160

              new value = 220

      Still Iam seeing same user SAPSYS using Program SAPMSSY2 and consuming resources and transaction sm65 ending with runtime error : TIME_OUT.

      Regards,

      Domnic.

  • avatar image
    Former Member
    Jul 23, 2015 at 05:05 PM

    Is the JBLOG file very big? Are you running the cleanup process for joblogs (RSBTCDEL2)? You might try running this as DDIC in client 000.

    Does it take long for SAPSYS to use up all the background processes?

    Thanks!

    Joe

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      You might want to try and run BTCTRNS1 and unschedule all the background jobs. That would give you the chance to review the system and without having to fight all those background tasks.


      Your system may be trying to play catch up with jobs that are being released but never completely finishing.


      I looked at your logs but did not see anything specific that is causing the issue.


      Do you have external connections to the DB that might be using up the sessions? How many wp's do you have?


      Thanks!


      Joe

  • Jul 13, 2015 at 07:54 PM

    Hi

    Could you share your SAP kernel release, level & OS / DB?

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

    • Hi SS,

      SAP Kernel Information                                                                

      |SAP Kernel :  720_REL                                                                 

      |Database Client Library : OCI_10201_SHARE, 10.2.0.4.0                                 

      |created in  :  NT 5.2 3790 S x86 MS VC++ 14.00                                        

      |created on  :  Jul  8 2012 23:15:28                                            

      |Support Level  :  0                                                                   

      |Kernel Patch number : 300                                                       

      |Source ID  :  0.300                                                                  

      |DBSL Patch No. : 215                                                                 

      |ICU Version : 3.4 Unicode Version 4.1                                                 

      |libsapu16 Version : 2.0025  Jul  8 2012 19:57:48  

      OS: WINDOWS SERVER 2008 R2

      Database : Oracle 10g : 10.2.0.5.0

      Kind Regards,

      Domnic

  • Jul 22, 2015 at 06:12 AM

    Dear Experts,

    I still have SAPSYS users using all the BACKGROUND jobs here are  the ERRORS

    1.Developer_Trace :

    Dev_W15 :

    xhead.c   14350]

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C8339A530E7F706}_{conn-id=00000000000000000000000000000000}_0

    B  ComRolHook(BEFORE_COMMIT, free_all) failed

    B  db_con_commit received error -1 in before-commit action, returning 8

    M  ***LOG R38=> ThICommit3, db_commit98 ( 001024) [thxxhead.c   14350]

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C8339A530E7F706}_{conn-id=00000000000000000000000000000000}_0

    B  ComRolHook(BEFORE_COMMIT, free_all) failed

    B  db_con_commit received error -1 in before-commit action, returning 8

    M  ***LOG R38=> ThICommit3, db_commit98 ( 001024) [thxxhead.c   14350]

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C8339A530E7F706}_{conn-id=00000000000000000000000000000000}_0

    B  ComRolHook(BEFORE_COMMIT, free_all) failed

    B  db_con_commit received error -1 in before-commit action, returning 8

    M  ***LOG R38=> ThICommit3, db_commit98 ( 001024) [thxxhead.c   14350]

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C8339A530E7F706}_{conn-id=00000000000000000000000000000000}_0

    B  ComRolHook(BEFORE_COMMIT, free_all) failed

    B  db_con_commit received error -1 in before-commit action, returning 8

    M  ***LOG R38=> ThICommit3, db_commit98 ( 001024) [thxxhead.c   14350]

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C8339A530E7F706}_{conn-id=00000000000000000000000000000000}_0

    B  ComRolHook(BEFORE_COMMIT, free_all) failed

    B  db_con_commit received error -1 in before-commit action, returning 8

    M  ***LOG R38=> ThICommit3, db_commit98 ( 001024) [thxxhead.c   14350]

    M

    M Wed Jul 22 04:32:47 2015

    M  *** ERROR => ThCallHooks: event handler rstshpc_hook_prepare_for_commit for event BEFORE_COMMIT failed [thxxtool3.c  303]

    M  {root-id=005056A57CA41ED58C833C36062DB706}_{conn-id=00000000000000000000000000000000}_0

    2.SM21 :

    TemSe input/output to unopened fiTemSe input/output to unopened file.

    All the users have read/write permissions to the directory \\hostname\sapmnt\sap\sid\sys\global


    Experts Kindly guide me to solve this.


    Kind Regards,

    Domnic.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 28, 2015 at 08:15 AM

    Hi,

    the SAPMSSY2 program is the batch scheduler program,it will be executed every rdisp/btctime by sap system user SAPSYS and also be executed when a job finished.

    when execute SAPMSSY2 program, it will check batch job tables TBTCO and TBTCS ...

    Also, when do sm65 inconsistency check, it will also check batch job tables TBTCO and TBTCS...

    For batch job tables, please refer to following wiki:

    http://wiki.scn.sap.com/wiki/display/TechTSG/Database+Tables+for+Background+Processing+system

    For SM65, please refer to :

    http://wiki.scn.sap.com/wiki/display/TechTSG/FAQ+-+SM65

    Regarding of this issue:

    SAPSYS user is using Program SAPMSSY2 and consuming resources and transaction sm65 ending with runtime error : TIME_OUT

    Probably because that there are some invalid date entries in the TBTCO and TBTCS table(e.g. SDLSTRTDT colume),and because of this, there are a lot of TIME_OUT dumps which relate to program "SAPMSSY2", and the TIME_OUT dumps incidents that SAPMSSY2 program entry in a endless looping and finally time out due to rdisp/max_wprun_time parameter restriction.

    For such situation, I've also summarized into following BTC wiki page:

    http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=405178099

    At last, there is a BTC wiki page which included almost all the known issues,

    I believe you will get benefit when you have issue about BTC.

    http://wiki.scn.sap.com/wiki/display/TechTSG/SAP+Background+Processing

    Thanks and best regards,

    Shi Feng

    Add comment
    10|10000 characters needed characters exceeded