Deadlock occurred

[#1]

hi,

I got a deadlock in SM21,this deadlock has locked my cube,makes the request of the cube is not available for reporting.I can see the data in rsa1 and the table ,but i cant see it in any query creat in this cube.

i think this should be settled by basis,but our basis can not work it out.so ,i have to fix it myself.

how can i fix it?

here is the message:

**************************************************************************************************************************

Time Type Nr Clt User TCode Grp N Text

18:05:07 BTC 017 *** user BY O Deadlock occurred

Deadlock occurred

Details

Recording at local and central time........................ 2010/12/09 18:05:07

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

09793 Background Processor No. 017 user 1 RSBATCH_EXECUTE_PROZESS S Operation Trace SBAC

Module nam Line Table Name Field Name

dbsh 1143

Documentation for system log message BY O :

A database deadlock occurs when two processes lock each other's

resources and are therefore unable to proceed. This problem can only

be solved by terminating one of the two transactions. The database

more or less at random terminates one of the transactions.

Example:

Process 1 locks resource A.

Process 2 locks resource B.

Process 1 requests resource A exclusively (-> lock) and waits for

process 2 to end its transaction.

Process 2 requests resource B exclusively (-> lock) and waits for

process 1 to end its transaction.

For example, resources are table records, which are locked by a

modification or a Select-for-Update operation.

Technical details

File Offset RecFm System log type Grp N variable message data

4227 557820 h Database Error (Non-SQL) BY O dbsh 1143

[Former Member]

is there any basis can help me?because the message in SM21 tell me that its a Database Error.

make the yellow statu in SM21 into red or green might work.can anyone tell me how to do it?

And,we have restart the service computer, it doesnot work.