Skip to end of metadata
Go to start of metadata

Use

User task <task_ID> blocked in state '<state_description>' since <duration> s, <appl_pid_and_node>

User task <task_ID> blocked in state '<state_description>' since <duration> s, command id: '<command_id>', <appl_pid_and_node>

User task <task_ID> blocked in state '<state description>', since <duration> s, DB procedure: <DB_procedure_name>, <appl_pid_and_node>


Explanation

The specified user task is active, however, its task state is not changing. This also blocks all other tasks in the same user kernel thread. In extreme cases, the blocking task may be in an endless loop.


User Response

Find out with x_cons command debugtask where the task is stuck.
  

More Information

Relevant  DB-Analyzer Files
Helpful with ...
DBAN_USER_TASK_STATES.csv 
DBAN_USER_TASKS_ACTIVITIES.prt 
SAP Note
 
  
Expert Sessions (Link to trainings)
Content / Helpful with ...
Session 27: SAP MaxDB Multi TaskingProvides general information about the concept of "cooperative" multi-tasking.
Documentation (Links)
Helpful with ...
 x_cons 
  • No labels