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]

you can start deleting the deadlock in sm12. when loading data to the infocube you should drop the index before as this leads often to locks.

M.

[Former Member]

hi M,

ThankU for your attention, but the problem is, i cant find any lock in SM12.

Edited by: yuanyuan dong on Dec 20, 2010 8:51 AM

[Former Member]

then the lock is not the problem. check if there's no red request in the cube. do you have BIA? if yes you need to construct the BIA indexes and only then the data will be availbale for reporting.

M;

[Former Member]

hi M,

what is BIA?

[Former Member]

it's the famous accelerator. not every customer has one.

if you don't find any solution, you can try reloading the request. delete the index before you load, and recreate afterwards.

M.

[Former Member]

hi M,

i have delete all the data in this qube first, and then i used a chain to delete the index --- transfer the data --- creat the index.

it is still can not work.

and the other chain only creat the index ,still...no change

Edited by: yuanyuan dong on Dec 20, 2010 9:52 AM