| Line 119... |
Line 119... |
| 119 |
" TO_CHAR(rl.LAST_BUILD, 'HH:MI:SS PM') as last_build_hours," &_
|
119 |
" TO_CHAR(rl.LAST_BUILD, 'HH:MI:SS PM') as last_build_hours," &_
|
| 120 |
" TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days" &_
|
120 |
" TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days" &_
|
| 121 |
" FROM RELEASE_CONFIG rc, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
121 |
" FROM RELEASE_CONFIG rc, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
| 122 |
" WHERE rc.RTAG_ID =" &rtagid &_
|
122 |
" WHERE rc.RTAG_ID =" &rtagid &_
|
| 123 |
" AND rc.bmcon_id is not null" &_
|
123 |
" AND rc.bmcon_id is not null" &_
|
| 124 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
124 |
" AND rl.RCON_ID(+) = rc.RCON_ID" &_
|
| 125 |
" AND rc.bmcon_id = bm.bmcon_id(+)"
|
125 |
" AND rc.bmcon_id = bm.bmcon_id(+)"
|
| 126 |
|
126 |
|
| 127 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
127 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
| 128 |
If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
|
128 |
If (NOT rsQry.BOF) AND (NOT rsQry.EOF) Then
|
| 129 |
Dim delta, last_build, last_build_time, last_build_days
|
129 |
Dim delta, last_build, last_build_time, last_build_days
|
| Line 173... |
Line 173... |
| 173 |
' Check that there is exacly one master in the build set
|
173 |
' Check that there is exacly one master in the build set
|
| 174 |
query = _
|
174 |
query = _
|
| 175 |
"SELECT COUNT (rc.daemon_mode) as masterCount" &_
|
175 |
"SELECT COUNT (rc.daemon_mode) as masterCount" &_
|
| 176 |
" FROM release_manager.release_config rc, release_manager.run_level rl" &_
|
176 |
" FROM release_manager.release_config rc, release_manager.run_level rl" &_
|
| 177 |
" WHERE rc.rtag_id = :RTAG_ID" &_
|
177 |
" WHERE rc.rtag_id = :RTAG_ID" &_
|
| 178 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
178 |
" AND rl.RCON_ID(+) = rc.RCON_ID" &_
|
| 179 |
" AND rc.bmcon_id is not NULL" &_
|
179 |
" AND rc.bmcon_id is not NULL" &_
|
| 180 |
" GROUP BY rc.daemon_mode" &_
|
180 |
" GROUP BY rc.daemon_mode" &_
|
| 181 |
" HAVING rc.daemon_mode = 'M'"
|
181 |
" HAVING rc.daemon_mode = 'M'"
|
| 182 |
|
182 |
|
| 183 |
Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
|
183 |
Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )
|