Im used SQL server 2000 with Services pack 3
i have problem if external program "gathercoda" want adding records to sql
db.
error message:
2005/06/30 13:53:22 (5)

to read the metrics
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
2005/06/30 13:53:22 (5)

Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
2005/06/30 13:53:22 (5)

Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)

Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
2005/06/30 13:53:22 (5)

Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
2005/06/30 13:53:22 (5)

Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)

Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
2005/06/30 13:53:22 (5)

Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
2005/06/30 13:53:22 (5)

Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
"RDS_LINUX_FILESYSTEMS"
2005/06/30 13:53:22 (5)

Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
"RDS_LINUX_DISKSIZES"
2005/06/30 13:53:22 (5)

matched metrics available
2005/06/30 13:53:22 (9)

Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)

GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)

Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)

RDS_GLOBAL records are up to date with 86400 second summarization
2005/06/30 13:53:22 (9)

Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)

RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)

Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)

UPTIME records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)

Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
2005/06/30 13:53:23 (5)

APPLICATION records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)

Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
2005/06/30 13:53:23 (5)

TRANSACTIONS records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)

Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (5)

GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)

Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (6)

Validating metrics for GLOBAL::CODA
2005/06/30 13:53:23 (3)

RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)

2005/06/30 13:53:23 (9)

Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
00:00:00)
2005/06/30 13:53:23 (2)

14 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (9)

ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
2005/06/30 13:53:23 (5)

permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
Server]
2005/06/30 13:53:23 (2)

denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
Server]
2005/06/30 13:53:23 (9)

ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
2005/06/30 13:53:23 (5)

invalid at this time
2005/06/30 13:53:23 (5)

State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (1)

TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
at this time
2005/06/30 13:53:23 (1)

State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (3)

RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)

2005/06/30 13:53:23 (9)

SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
2005/06/30 13:53:23 (9)

ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
2005/06/30 13:53:23 (5)

permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
Server]
2005/06/30 13:53:23 (2)

denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
Server]
2005/06/30 13:53:23 (9)

ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)

State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]
1;SQL Server]
2005/06/30 13:53:23 (5)

invalid at this time
2005/06/30 13:53:23 (5)

State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (E)

TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
2005/06/30 13:53:23 (1)

State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (2)

GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (9)

Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
03:00:00)
2005/06/30 13:53:23 (2)

11 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (E)

TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
2005/06/30 13:53:23 (2)

GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (5)

RDS_GLOBAL_CODA records are up to date with 86400 second summarization
2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (1)

2005/06/30 13:53:23 (4)

Collected 0 records for RDS_GLOBAL_CODA
2005/06/30 13:53:23 (1)

Collected 0 records in 0: 0: 2
2005/06/30 13:53:23 (E)

2005/06/30 13:53:23 (6)

can u help me please> 2005/06/30 13:53:23 (9)

> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

This looks like a permissions problem. Check to ensure that the account
being used to run this process has the needed permissions on the objects and
columns used. See GRANT in the SQL Server Books Online.
Hope this helps.
Dan Guzman
SQL Server MVP
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5)

> Start
> to read the metrics
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec ->
> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)

> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)

> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)

> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)

> matched metrics available
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)

> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)

> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)

> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)

> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)

> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)

> 2005/06/30 13:53:23 (9)

> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2)

> Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)

> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> 2005/06/30 13:53:23 (5)

> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (2)

> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (9)

> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> 2005/06/30 13:53:23 (5)

> invalid at this time
> 2005/06/30 13:53:23 (5)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)

> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation
> invalid
> at this time
> 2005/06/30 13:53:23 (1)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)

> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)

> 2005/06/30 13:53:23 (9)

> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> 2005/06/30 13:53:23 (9)

> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> 2005/06/30 13:53:23 (5)

> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (2)

> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (9)

> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]
> 2005/06/30 13:53:23 (5)

> invalid at this time
> 2005/06/30 13:53:23 (5)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)

> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)

> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)

> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2)

> Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (E)

> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)

> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)

> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (4)

> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)

> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)

> violation
> 2005/06/30 13:53:23 (6)

>
> can u help me please
>|||It seems that someone has messed up the permissions for the user that this a
pplication runs as. You
should contact the vendor of the application to see what permissions is requ
ired so you can set them
properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5)

rt
> to read the metrics
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_COD
A"
> 2005/06/30 13:53:22 (5)

> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)

> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)

> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)

> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)

> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)

> matched metrics available
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)

> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)

> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)

> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)

> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)

> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)

> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)

> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)

> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)

> 2005/06/30 13:53:23 (9)

> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2)

d
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)

DA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of objec
t
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> 2005/06/30 13:53:23 (5)

> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (2)

> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', databa
se
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (9)

DA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of objec
t
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> 2005/06/30 13:53:23 (5)

> invalid at this time
> 2005/06/30 13:53:23 (5)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)

> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation inval
id
> at this time
> 2005/06/30 13:53:23 (1)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)

> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)

> 2005/06/30 13:53:23 (9)

> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> 2005/06/30 13:53:23 (9)

DA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of objec
t
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> 2005/06/30 13:53:23 (5)

> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (2)

> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', databa
se
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver
][SQL
> Server]
> 2005/06/30 13:53:23 (9)

DA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of objec
t
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)

> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver]&
#91;SQL Server]
> 2005/06/30 13:53:23 (5)

> invalid at this time
> 2005/06/30 13:53:23 (5)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)

> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)

> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)

> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)

> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2)

d
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (E)

> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)

> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)

> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (1)

> 2005/06/30 13:53:23 (4)

> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)

> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)

on
> 2005/06/30 13:53:23 (6)

>
> can u help me please
>
No comments:
Post a Comment