Problem with authentication prompting whilst fetching a report over the NET

Hi all,
I'm having a problem with accessing a report.
When I test it on my machine (2000 & reporting services installed on same
machine) there's no problem. As soon as I try to access it vie the internet
(I route through no-ip.org) then a window pops up wanting authentication. I
want to do away with this please.
How do I do this so no prompting occurs?
Regards
John.The authentication for a data source can be different for the dev env than
the production env... Go to the data source in the Prod env, and ensure
that something OTHER than prompt for credentials is set for the data
source...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <a@.b.c> wrote in message
news:%23iJ6eE7XFHA.2768@.tk2msftngp13.phx.gbl...
> Hi all,
> I'm having a problem with accessing a report.
> When I test it on my machine (2000 & reporting services installed on same
> machine) there's no problem. As soon as I try to access it vie the
> internet (I route through no-ip.org) then a window pops up wanting
> authentication. I want to do away with this please.
> How do I do this so no prompting occurs?
> Regards
> John.
>

Problem with assebly

I have problems with referensing assebly to my report. I copy my.dll to
\MSSQL\Reporting Services\ReportManager\bin
and
\MSSQL\Reporting Services\ReportServer\bin.
I have added the assembly to the report using the Referecnce tab poniting to \MSSQL\Reporting Services\ReportServer\bin but i still get error File or assembly name AssTest, or one of its dependencies, was not found.
In assebly i have simple function and it's static, i call method like this =Namespace.Class.Method.
Please, help.
AlešI did mistake in path to dll
Aleš
"AG, NLB d.d." wrote:
> I have problems with referensing assebly to my report. I copy my.dll to
> \MSSQL\Reporting Services\ReportManager\bin
> and
> \MSSQL\Reporting Services\ReportServer\bin.
> I have added the assembly to the report using the Referecnce tab poniting to \MSSQL\Reporting Services\ReportServer\bin but i still get error File or assembly name AssTest, or one of its dependencies, was not found.
> In assebly i have simple function and it's static, i call method like this =Namespace.Class.Method.
> Please, help.
> Aleš
>
>sql

Problem with AS data source

I've successfully created a data source and reports against an Analysis
Services database.
The AS database is on the same machine as RS (let's call this Server
1).
I tried this against a second AS database (on Server 2), and it works
fine from Visual Studio, but when I deploy it to RS (on Server 1) and
try to run it, I get the error:
"...Cannot create a connection to data source 'DevServer'.
(rsErrorOpeningConnection)
A connection cannot be made. Ensure that the server is running.
Unable to read from the transport connection: An existing connection
was forcibly closed by the remote host."
I'm not doing anything complicated. It's just that the AS database is
on a different machine from the RS server. Shouldn't this work?
Ideas?
TIA,
JimHi Jim.
Could 'devserver' have firewall on for its network connection?
<jhcorey@.yahoo.com> wrote in message
news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
> I've successfully created a data source and reports against an Analysis
> Services database.
> The AS database is on the same machine as RS (let's call this Server
> 1).
> I tried this against a second AS database (on Server 2), and it works
> fine from Visual Studio, but when I deploy it to RS (on Server 1) and
> try to run it, I get the error:
> "...Cannot create a connection to data source 'DevServer'.
> (rsErrorOpeningConnection)
> A connection cannot be made. Ensure that the server is running.
> Unable to read from the transport connection: An existing connection
> was forcibly closed by the remote host."
> I'm not doing anything complicated. It's just that the AS database is
> on a different machine from the RS server. Shouldn't this work?
> Ideas?
> TIA,
> Jim
>|||I just tried deploying everything to Server 2, and it works fine.
So my conclusion is that for a report that goes against an AS cube, RS
must be on the same machine as AS. But it would be great if I was
wrong.
Jim
Tim Dot NoSpam wrote:
> Hi Jim.
> Could 'devserver' have firewall on for its network connection?
> <jhcorey@.yahoo.com> wrote in message
> news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
> > I've successfully created a data source and reports against an Analysis
> > Services database.
> > The AS database is on the same machine as RS (let's call this Server
> > 1).
> >
> > I tried this against a second AS database (on Server 2), and it works
> > fine from Visual Studio, but when I deploy it to RS (on Server 1) and
> > try to run it, I get the error:
> >
> > "...Cannot create a connection to data source 'DevServer'.
> > (rsErrorOpeningConnection)
> > A connection cannot be made. Ensure that the server is running.
> > Unable to read from the transport connection: An existing connection
> > was forcibly closed by the remote host."
> >
> > I'm not doing anything complicated. It's just that the AS database is
> > on a different machine from the RS server. Shouldn't this work?
> > Ideas?
> >
> > TIA,
> > Jim
> >|||It is great! <g>
I'm not a configuration wiz, but here are some things you could do until you
figure out how to get reporting services to correctly pass the user's
credentials to AS:
1) change the datasource in report manager for the OLAP conection to use a
domain user that has the necessary privileges on AS (preferrably a domain
account that's not an admin in AS).
Ideally, RS will pass the credentials of the user to AS during the
connection.
A good enterprise configuration for a smaller group could be to split sql
server, analysis services and reporting services across 3 boxes, preferrably
64bit.
<jhcorey@.yahoo.com> wrote in message
news:1150824174.761885.143160@.h76g2000cwa.googlegroups.com...
>I just tried deploying everything to Server 2, and it works fine.
> So my conclusion is that for a report that goes against an AS cube, RS
> must be on the same machine as AS. But it would be great if I was
> wrong.
> Jim
> Tim Dot NoSpam wrote:
>> Hi Jim.
>> Could 'devserver' have firewall on for its network connection?
>> <jhcorey@.yahoo.com> wrote in message
>> news:1150819548.395205.74950@.r2g2000cwb.googlegroups.com...
>> > I've successfully created a data source and reports against an Analysis
>> > Services database.
>> > The AS database is on the same machine as RS (let's call this Server
>> > 1).
>> >
>> > I tried this against a second AS database (on Server 2), and it works
>> > fine from Visual Studio, but when I deploy it to RS (on Server 1) and
>> > try to run it, I get the error:
>> >
>> > "...Cannot create a connection to data source 'DevServer'.
>> > (rsErrorOpeningConnection)
>> > A connection cannot be made. Ensure that the server is running.
>> > Unable to read from the transport connection: An existing connection
>> > was forcibly closed by the remote host."
>> >
>> > I'm not doing anything complicated. It's just that the AS database is
>> > on a different machine from the RS server. Shouldn't this work?
>> > Ideas?
>> >
>> > TIA,
>> > Jim
>> >
>

Problem with Analysis Services Provider

Hi,

For some reason I cannot execute reports using the provider "Microsoft SQL Server Analysis Services (AdomdClient)". I can see my cube through the Query Builder and execute the queries with it too, but when I run the query I get an error...

An error has occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'.
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it

When I change the provider to "Microsoft OLE DB Provider for Analysis Services 9.0" I can execute the report, but I lose the ability to use the MDX query builder with this provider!

Can someone tell me how I can get the analysis services provider to work or how I can get the mdx query builder to work using the old db propvider?

I have no trouble connecting to the Analysis Services server using the sql 2000 "mdx sample application" and I can also connect to it with excel by importing a datasource. But I cannot connect to it from sql management studio 2005, I get a similar error to above. Could it be that sql server 2005 cannot connect to AS2000?

Thanks,

Lachlan

Did you try to add the ConnectTo property to your connection string when connecting to AS 2000:

data source=localhost;initial catalog=SalesMartCube; ConnectTo=8.0

-- Robert

|||

Hi Robert,

I tried your suggestion but I get a different error when I click on the preview pane using "ConnectTo=8.0" in the connection string...

An error has occurred during local report processing.
An error has occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'.
The LCID or Compare String flags have already been set by an existing connection. They cannot be changed.

It seems strange to me that I can see the query results in query builder but get an error on the preview pane.

I've also noticed that some of the query builder features are not available to me such as query parameters, command type and query designer. Is this because I am connecting to AS2000 rather than AS2005?

Thanks for your help.

Lachlan

problem with analysis server connection string

i have just installed a new version of analysis services 2000 on a test machine. when i try to connect to the local host i get the error "Datasource name is too long". I have set the datasource string to

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\MsOLAPRepository$\msmdrep.mdb

This is the same string as i have on other analysis servers, bar the server name, but it still does not work. any ideas?

The olap service is running correctly, just in case its a detail you need to know.

I assume you use Analysis Manager or DSO program to connect, and you change the "Repository Connection String" property from Analysis Manager. Can you check whether you can open msmdrep.mdb repository file from Access ? Or try to migrate repository to SQL Server - will you get the same error ?

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?sql

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?

Problem with an aggregation

Hi,

I am new to the reporting services and I've been working on problem in one of my reports all day long and after 8 hours of frusturation I decided ask for a profesional help.

Ok here is my problem: I have a report that calculates the amount of meetings with our clients. The dataset contains an activity_id field that we assign for each our meetings with our clients. SSRS counts these meetings and shows it in a drilldown enabled report. Everything seems fine on the report except that someof the activities involves few different clients and SSRS is not counting the activities multiple times in region drilldown as there is only one activity id associates in that region even though it contains different companies. And I want those companies to be calculated in too.

From the crude drawing below I wanted to explain my dilemma visually. As it can be seen the total number of meetings we had is actually 40. But as we had 3 activities that involves more than 1 clients it only gives 37 as a count. I would like to know is there a way to make the report count the same activity multiple times if activity_id is associated with more than one clients.

I hope I managed to explain my problem

**********************************************************************************************

Manager Region Market Company Meeting Detail

+Manager 1 (9 meetings)

+Manager 2 (37 meetings)

- West (37 meetings)

-Denver (37 meetings)

+Company 1 (5 meetings)

+Company 2 (2meetings)

+Company 3 (2meetings)

+Company 4 (3meetings)

+Company 5 (0meetings)

+Company 6 (0meetings)

+Company 7 (5meetings)

+Company 8 (1meetings)

+Comapny 9 (19meetings)

+Company 10 (3meetings)

Total (40 meetings)

You would need to use a composite key by grouping on the combination of the activity_id and company_id rather than just the activity_id. I believe strongly in doing as much of the math as possible in the SQL statement, rather than the report. That way you can use your same report and simply show the total that was calculated rather than the calculating the total. For example:

Code Snippet

SELECT

base.Manager,

base.Region,

base.Market,

base.Company,

base.MeetingDetail,

MTot.Total as ManagerTotal,

RTot.Total as RegionTotal,

M2Tot.Total as MarketTotal,

CTot.Total as CompanyTotal

FROM

baseTable base,

(SELECT COUNT(*) AS Total FROM baseTable bt WHERE bt.Manager = base.Manager) MTot,

(SELECT COUNT(*) AS Total FROM baseTable bt WHERE bt.Manager = base.Manager AND bt.Region = base.Region) RTot,

etc.

This is really bad SQL, but I don't know the actual structure that you are working from and I think this conveys the idea.

If this isn't clear, post or send me the table structures and I will help you build a query that calculates your totals.

Larry

|||

Thank you Larry,

I will try to follow up with your suggestion hopefully it will help. if I got stuck I will post the table structure to you. Thank you again for your prompt response.

Regards,

Burak

|||

Hi Larry,

I've been trying to use your suggestion but I couldn't figure it out a way to use it.

My sql code is as follows

Code Snippet

SELECT DISTINCT
TOP 100 PERCENT ACTIVITY_ID, Date, ACTIVITY_TYP_NM, LAST_NM, FIRST_NM, COMPANY_NM, DISPLAY_NM, Region, SUMMARY, MLAE, Market,
STATE, Expr1
FROM dbo.INTV_Sales_Funnel
GROUP BY ACTIVITY_ID, Date, ACTIVITY_TYP_NM, LAST_NM, FIRST_NM, COMPANY_NM, DISPLAY_NM, Region, SUMMARY, MLAE, Market, STATE,
Expr1
ORDER BY ACTIVITY_ID, Date, SUMMARY, COMPANY_NM

MLAE represents the Manager

and Expr1 represents the Count

the thing is when I used the count im getting a value that more than I should get and the reason for this, is in some of our events we invite multiple people from a company or multiple people from multiple companies.But the report should reflect only 1 count of the event if the meeting had either 1 person or more from a single company. I managed to get rid of those extra people on the meetings over the report so activities only listed once. But it seems like I really need to find a way to make that calculation over the report. Is there a way to use Count Distinct on report with 2 values. Right now I am using Activity ID but I guess if add both activity id and company name as you mentioned earlier on your response I might be able to solve this problem.

|||

First, on re-reading your original post, I am not sure that your original solution wasn't correct. If you had 37 meetings and 3 meetings had two customers each then you would show the result of the sum of the meetings that each customer attended was 40 rather than 37 because each of the three meetings with two customers each would be counted twice.

That said, here is a method of generating the query that will return your results. Lets start with what you know that you want and build the query from left to right on your table above. This will not get us the most optimized query, but it should show the method of layering results within a query that can allow you to get complex results with simple nested queries. One advantage to this method is that you can check the results at each stage.

First, let's get a count of all of the meetings for the managers:

Code Snippet

SELECT
DISF.MLAE,
COUNT(DISF.Activity_Id) ManagerTotal
FROM
(SELECT
DISTINCT
MLAE,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE

Then, let's get the count of meetings per region per manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
COUNT(DISF.Activity_Id) RegionTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region

Next, let's get the count of meetings per market within a region for each manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
DISF.Market,
COUNT(DISF.Activity_Id) MarketTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Market,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region,
DISF.Market

Lastly, let's get the count of meetings per customer within each market and region for each manager:

Code Snippet

SELECT
DISF.MLAE,
DISF.Region,
DISF.Market,
DISF.Company_NM,
COUNT(DISF.Activity_Id) CompanyTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Market,
Company_NM,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region,
DISF.Market,
DISF.Company_NM

Then, when you want to combine them and return all of the values, join each of the four queries to the main query as follows:

Code Snippet

SELECT
main.Activity_Id,
main.Date,
main.ACTIVITY_TYP_NM,
main.LAST_NM,
main.FIRST_NM,
main.COMPANY_NM,
main.DISPLAY_NM,
main.Region,
main.SUMMARY,
main.MLAE,
main.Market,
main.STATE,
mgr.ManagerTotal,
rgn.RegionTotal,
mkt.MarketTotal,
cmp.CompanyTotal
FROM
INTV_Sales_Funnel main
JOIN
(
SELECT
DISF.MLAE,
COUNT(DISF.Activity_Id) ManagerTotal
FROM
(SELECT
DISTINCT
MLAE,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE
) mgr
ON
main.MLAE = mgr.MLAE
JOIN
(
SELECT
DISF.MLAE,
DISF.Region,
COUNT(DISF.Activity_Id) RegionTotal
FROM
(SELECT
DISTINCT
MLAE,
Region,
Activity_Id
FROM
INTV_Sales_Funnel
) DISF
GROUP BY
DISF.MLAE,
DISF.Region
) rgn
ON
main.MLAE = rgn.MLAE
AND
main.Region = rgn.Region
etc.

I hope this helps. Please let me know how it turns out.

Larry

Problem with added data from external gathering software to SQL DB

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)2648) server_where_gathercoda_gathering_data, Start
to read the metrics
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
"RDS_LINUX_FILESYSTEMS"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
"RDS_LINUX_DISKSIZES"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
matched metrics available
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL records are up to date with 86400 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
UPTIME records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
APPLICATION records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
TRANSACTIONS records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
Validating metrics for GLOBAL::CODA
2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
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)2648) server_where_gathercoda_gathering_data, Read
14 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
The cursor was not declared.
2005/06/30 13:53:23 (5)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
The cursor was not declared.
2005/06/30 13:53:23 (2)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
at this time
2005/06/30 13:53:23 (1)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
The cursor was not declared.
2005/06/30 13:53:23 (5)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
The cursor was not declared.
2005/06/30 13:53:23 (2)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
2005/06/30 13:53:23 (1)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
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)2648) server_where_gathercoda_gathering_data, Read
11 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_CODA records are up to date with 86400 second summarization
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
Collected 0 records for RDS_GLOBAL_CODA
2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
Collected 0 records in 0: 0: 2
2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access violation
2005/06/30 13:53:23 (6)2648) End of Program
can u help me please
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> 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)2648) Error -1;
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)2648) server_where_gathercoda_gathering_data,
> Start
> to read the metrics
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec ->
> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> 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)2648) server_where_gathercoda_gathering_data,
> Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation
> invalid
> at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> 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)2648) server_where_gathercoda_gathering_data,
> Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access
> violation
> 2005/06/30 13:53:23 (6)2648) End of Program
>
> can u help me please
>
|||It seems that someone has messed up the permissions for the user that this application runs as. You
should contact the vendor of the application to see what permissions is required 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)2648) server_where_gathercoda_gathering_data, Start
> to read the metrics
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> 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)2648) server_where_gathercoda_gathering_data, Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
> at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; 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'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close 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)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> 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)2648) server_where_gathercoda_gathering_data, Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access violation
> 2005/06/30 13:53:23 (6)2648) End of Program
>
> can u help me please
>