Hello,
I have following issue:
- Trying to extend CMDB by creating subclass of BMC_Dependency.
Result
– Change Pending status for that new class which turns to Error but
without description.
- Server Administration logs are unavailable – standard timeout error
when trying to switch on/off logs.
- Relogin to Remedy – not possible.
Information can be found in:
- Arerror.log:
------------------------------------------------------------------------------------------------------
ti mar 18 2014 09:24:31.5670 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
Thread Id: 1524
Version: 8.1.00 201301251157 Jan 25 2013 12:20:26
ServerName: arserver
Database: SQL -- SQL Server
Hardware: x86_64
OS: Windows 6.1
RPC Id: 383304
RPC Call: 75 (SCO)
RPC Queue: 390600
Client: User Hristo from Mid-tier (protocol 20) at IP address 192.168.233.30
Form:
Logging On: API
Code: c0000005
Operation: read
Access Addr: FFFFFFFFFFFFFFFF
Stack Begin:
Addr: 000000007493E8C0
Addr: 00AE3FC3D9FC8A3F
Stack End
ti mar 18 2014 09:24:31.5670 390600 : AR System server terminated when a
signal/exception was received by the server (ARNOTE 20)
ti mar 18 2014 09:24:31.5670 0xc0000005
- Switching on API+Filter+SQL provided following information for errors :
----------------------------------------------------------------------------------------------------
*/DROP TABLE AR0int2500
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */*** ERROR ***
Cannot drop the table 'AR0int2500', because it does not exist or you do not
have permission. (SQL Server 3701)
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */DROP TABLE
AR0float2500
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */*** ERROR ***
Cannot drop the table 'AR0float2500', because it does not exist or you do not
have permission. (SQL Server 3701)
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */DROP TABLE
AR0char2500
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */*** ERROR ***
Cannot drop the table 'AR0char2500', because it does not exist or you do not
have permission. (SQL Server 3701)
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */DROP TABLE
AR0decimal2500
<SQL > <TID: 0000002500> <RPC ID: 0000006029> <Queue: Admin > <Client-RPC:
390696 > <USER: Hristo >
<Overlay-Group: 0 > /* ti mar 18 2014 09:24:31.5670 */*** ERROR
Cannot drop the table 'AR0decimal2500', because it does not exist or you do not
have permission. (SQL Server 3701)
<API > <TID: 0000005076> <RPC ID: 0000006030> <Queue: List > <Client-RPC:
390620 > <USER: Remedy Application Service >
<Overlay-Group: 1 > /* ti mar 18 2014 09:24:31.5670
- Those tables AR0int/char/float/decimal [ThreadId] are temporary.
- We used to trace SQL transactions – those tables do not exist before
trying to extend, they are not created during the trying to extend the CMDB.
Only Drop statements can be found.
- These “Droping Table AR0…..” lines do not appear in another 8.1
environment for the same scenario.
My suggestions:
- Possible user account issue (after OS patch)- users – ARAdmin and the
user for Remedy service (OS were patched during weekend)?
- Corrupted dll file?
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
