Hi,
We are seing some sporadic (very frequent) krasching on a server:
- Windows Server 2003
- MS SQL Server
- ARServer 6.3 patch 16 (patch 14 shows the same problem)
Here is a small exerpt from a combined logfile.bak just before the server
dies.
It is more or less similar each time.
At least regarding a number of rows similar to this, but with different
numbers at the end:
*** ERROR *** Cannot drop the table 'AR0int2128', because it does not
exist in the system catalog. (SQL Server 3701)
... 'AR0float2128' ...
... 'AR0char2128' ...
... 'AR0decimal2128' ...
Apparently the numbers at the end of the non existant 'tables' differ for
the user OMLA and Remedy Application Service.
I will report this to BMC Support as well, but was hoping to get some fast
input from you.
Thank you in advance!
Best Regards - Misi, RRR AB, http://www.rrr.se
<FLTR> <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
--> Passed -- perform actions
<FLTR> <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
0: Notify
<FLTR> <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
<deferred to phase 3>
<FLTR> <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9130 */ End of filter processing (phase 1)
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */CLOSE DATABASE
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */DROP TABLE AR0int2948
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */*** ERROR *** Cannot drop the table
'AR0int2948', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */DROP TABLE AR0float2948
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */*** ERROR *** Cannot drop the table
'AR0float2948', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */DROP TABLE AR0char2948
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */*** ERROR *** Cannot drop the table
'AR0char2948', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */DROP TABLE AR0decimal2948
<SQL > <TID:2948> <RPC:20> <Q:Fast> <C-RPC:390620> <USER: OMLA >
/* to maj 11 2006 17:04:52.9440 */*** ERROR *** Cannot drop the table
'AR0decimal2948', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9440 */CONNECT ARSystem, USER ARAdmin
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9600 */SET CONCAT_NULL_YIELDS_NULL OFF
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9600 */SELECT @@version
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9600 */BEGIN TRANSACTION
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9600 */SELECT dbVersion FROM control
<SQL > <TID:2408> <RPC:00> <Q:Fast> <C-RPC:000000> <USER: >
/* to maj 11 2006 17:04:52.9600 */COMMIT TRANSACTION
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */CLOSE DATABASE
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */DROP TABLE AR0int2128
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */*** ERROR *** Cannot drop the table
'AR0int2128', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */DROP TABLE AR0float2128
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */*** ERROR *** Cannot drop the table
'AR0float2128', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */DROP TABLE AR0char2128
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */*** ERROR *** Cannot drop the table
'AR0char2128', because it does not exist in the system catalog. (SQL
Server 3701)
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */DROP TABLE AR0decimal2128
<SQL > <TID:2128> <RPC:21> <Q:List> <C-RPC:390620> <USER: Rem App Svc>
/* to maj 11 2006 17:05:39.2450 */*** ERROR *** Cannot drop the table
'AR0decimal2128', because it does not exist in the system catalog. (SQL
Server 3701)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
