Waiting for CBS for 4 hours then build fails

[Former Member]

Hi experts!

We have installed a brand new 7.40 SP05 WebAS as a NWDI-server with an Oracle database 11.2.0.3.0. For some time everything was fine but since last week every build process takes about 4 hours and then fails. At the logfile it looks like this:

20140129095032 Info :buildspace = xxx_ABC10D_C build request id = 243 
20140129095032 Info :wait until CBS queue of buildspace xxx_ABC10D_C is completely processed, before asking for build results
20140129095032 Info :waiting for CBS queue activity
20140129095102 Info :build process already running: waiting for another period of 30000 ms
20140129095132 Info :build process already running: waiting for another period of 30000 ms
20140129095202 Info :build process already running: waiting for another period of 30000 ms
20140129095232 Info :build process already running: waiting for another period of 30000 ms
20140129095302 Info :build process already running: waiting for another period of 30000 ms
20140129095332 Info :build process already running: waiting for another period of 30000 ms 
...

What we have found until now is a blocking database sql-statement which blocks the following sql-statement. The database process is also running at 100% our administrator told us. The blocking sql statement is changing but the blocked statement is always the same:

UPDATE "CBS_LOCK" SET "LOCKIT" = "LOCKIT" + 1 WHERE "LOCKGROUP" = :1  AND "LOCKID" = :2

Did anyone had the same problem and found a solution?

[Former Member]

Hi, have you solved this problem?

Please, share your solution...

[former_member191643]

Some SCA build activities are geting queued. Have you tried restarting the server once? Sounds strange but works sometimes.

[Former Member]

Thanks for your reply!

We have started the server several times and it removes the lock at the database. But if you try to reimport something in any track, the lock reappears ...

[ErvinSzolke]

Hi Richard,

is this issue still relevant ?

@Marcos : if you posted the same question due to your other SCN thread, then I believe Richard does not necessarily have the same problem like you, rather refer to the answer I gave in your thread.

Cheers,

Ervin

[Former Member]

Hi Ervin!

We have solved the problem. It was a problem at the database (Oracle 11g). I dont know what was done exactly but our admin said he "reorganized some additional db-statistics". This refers to the SAP Note # 1020260 http://service.sap.com/sap/support/notes/1020260. But the table mentioned in this note were not enough, our admin added some more tables ...

[ErvinSzolke]

Thank you Richard.