on 01-29-2014 10:52 AM
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?
Hi, have you solved this problem?
Please, share your solution...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Some SCA build activities are geting queued. Have you tried restarting the server once? Sounds strange but works sometimes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ...
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.