• State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 1287 views
  • Users 0 members are here
Options
Related

Membership of roles and profiles in SAP function operation is stuck in DB Queue and are not getting processed

himani1 j
over 3 years ago

I have created SAP function instances and DB queue operation "Membership of roles and profiles in SAP function" is stuck.

Rest of the JOb queue process and DB queue operations are getting processed successfully but ONLY this particular operation is stuck due to which i am getting 'Dead slot resetting error".

Kindlly suggest possible workaround to come out of this deadlock.

Thanks in advance!

  • 0 over 3 years ago

    Did you check the database journal for any errors?

    What version are you using?

  • 0 over 3 years ago

    If you get the slot resets after the KeepAlive-timeout (20 min by default) you can try to increase the Timeout (Configparm QBM\DBQueue\KeepAlive).
    I had cases where I had to set to 10 hours. NOTE: The DBQueue will be more or less blocked while calculating the SAPinstances. So only do this when you can afford it (maybe over the weekend).

    If the DBQueue shows multiple SAPFunction instance calculations you may want to set "MinBulk" and "MaxBulk" in the table "QBMDBQueueTaskPerf_fix" for the calculation task (sorry don't have the name/UID available right now). This will reduce the parallel groups calculated and enable progress. Normal operations will increase the values again, so you might have to repeat the setting of the values.

    Also contact support, we got a hotfix that improved the calculation procedure (I think it was for 8.1.1.). Sorry again, I don't have the hotfix number available. They should find it connected to my name though.

    It might also help to make your temp-DB fast. I.e. put the temp-DB on SSD-storage and increase the RAM of your DB-Server.

  • 0 over 3 years ago in reply to Klaus Müller

    Thanks for the reply ! Can you please help me in getting the hotfix number, this would be of great help !

  • 0 over 3 years ago in reply to himani1 j

    Sorry I currently don't have access to the system in question. From my mails it was likely Hotfix #32805 but I can't be sure atm.

    Please also be aware that that hotfix might not be relevant for your version, so give support you exact versionnumber to check against.