updating text datatype: error

Showing posts with label error. Show all posts

Friday, March 30, 2012

Problem with CLR in SSAS 2005

Two things

1 When the CLR is integrated in SSAS 2005 and used in MDX, I get the error as "#Error Infinite recursion detected. The loop of dependencies is: r_variable -> _variable.". Please help me what can be the issue

2 How do I debug CLR methods from SSAS 2005, I searched the net/MS Article but could not find anything important

I really appreciate your help.

This error is likely have nothing to do with your use of CLR, but it is because of wrong MDX calculations. If you will provide the content of your MDX Script, it will help to find where the error is.

Problem with Client Side Printing

After the Cumulative Security Update for Internet Explorer (912812) the client side printing doesn't work any more. Almost each client get the error:

"Unable to load client print control."

Other clients get an error with code '0x8007F304'.

What can i do? Will SP1 solve the issue?

Client Print is an Active X control. The security update may have disabled the ability to run Active X controls. Check your IE properties to see if Active X controls are allowed to run. In the patch notes I read the following.

Compatibility Patch – To help enterprise customers who need more time to prepare for the ActiveX update changes discussed in Microsoft Knowledge Base Article 912945 and included in Microsoft Security Bulletin MS06-013, Microsoft is releasing a Compatibility Patch on April 11, 2006. As soon as it is deployed, the Compatibility Patch will temporarily return Internet Explorer to the previous functionality for handling ActiveX controls. This Compatibility Patch will function until an Internet Explorer update is released as part of the June update cycle, at which time the changes to the way Internet Explorer handles ActiveX controls will be permanent. This compatibility patch may require an additional restart for systems it is deployed on. For more information, see Microsoft Knowledge Base Article 917425.

|||

i checked my internet properties and nothing has changed.

other activex controls doesn't worked any more too. for example scriptX. meadriod published a new version of their activeX control.

so how can i get it work?

|||

Launch IE

Go to Tools\Internet Options\Security\Custom Level.

In the Active X controls and plugins, select to enable. If this is already done, you may need to then go to General\Settings\View Objects and remove and then reinstall the Active X controls.

problem with c# stored procedure calling a class

I wrote a stored procedure in c# that calls a class. It deployed fine but when I try to execute it, I get the error...

Msg 6522, Level 16, State 1, Procedure UpdateJobAdSearch, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'UpdateJobAdSearch':
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at JobAd.WhaleJobAd.CreateSearchableRecord()
at JobAd.WhaleJobAd.CreateSearchableRecord(String JobId)
at StoredProcedures.UpdateJobAdSearch(String JobAdId)

I read an article on MSDN that didn't directly relate, but mentioned the same error message. It suggested using...

System.Data.SqlClient.SqlClientPermission pSql = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
pSql.Assert();

I tried that, but I get the same error.

I finally found the answer to this. I needed to set the projects properties > database permission level to external. However, I don't understand why. I've scaled back my code, pulled it out the class so everything executes in the stored procedures method call and all it does it create 2 connections to the local database and pull info from 6 tables and put that info into 1. It's not trying to access anything outside the database, so why does it have to be set to external? In order to get that to work, I had to then alter the database and turn trustworthy on which is scary because of the security holes that opens up.|||

cakewalkr7:
I've scaled back my code, pulled it out the class so everything executes in the stored procedures method call and all it does it create 2 connections to the local database and pull info from 6 tables and put that info into 1.

I think maybe connections opened by the class are considered as access to external resource. Did you try to open a connection in this way?

SqlConnection conn = new SqlConnection("context connection = true");

sql

Wednesday, March 28, 2012

problem with browser data from cube

All,

I'm having a problem with browser data from the cube in BI studio. the error MSG is " a connection cannot be made, make sure the server is running"

in fact , the server is running, and I can see anything within that cube with Management studio, where I went wrong? and what should I do to fix it?

Thanks.

Please do reprocess and reconnect on the browser tab.sql

problem with bigints in SS 2000

Anybody know what this error means:
"Server: Msg 3624, Level 20, State 1, Line 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 111
Process ID: 2028
Connection Broken"
I have a RESTORED database with about 10 large tables. A simple select
would return a couple of thousand of rows and then suddenly bomb out with
the above error. Interestingly the problem occurs only on the tables that
contain bigint columns, so I'm not sure if it's related. If I run "dbcc
checktable" on these table it returns lots of errors. I'm pretty sure the
database is not corrupt - it happens on any number of machines, plus the
database works fine at its original location. When I try to repair the
restored tables using "checktable" I can only do so with
"repair_allow_data_loss", not a good option of course. Also I have to
remove any indexes I have on the bigint columns. Any ideas?
Thanks
Have you tried using checktable with Repair_Rebuild. If that does not work then I would try deleting the indexes and rechecking then.
Jeff
MCDBA, MCSE+I
|||Hi,
Thanks for the reply. Yes, I have tried that, but it doesn't work - it only
works with "repair_allow_data_loss". Most of the errors are "consistency"
errors. It seems to me the problem lies with the bigint fields, but I'm not
sure why. I'm pretty sure the problem is not related to the indexes,
because only two of the problem tables have indexes. If I drop the indexes,
some of the errors (like "missing parents") go away, but the "consistency"
ones remain.
Tnx,
Pieter
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:100C38FB-3B9B-43F6-8700-DECF9E014C74@.microsoft.com...
> Have you tried using checktable with Repair_Rebuild. If that does not
work then I would try deleting the indexes and rechecking then.
> Jeff
> MCDBA, MCSE+I

problem with bigints in SS 2000

Anybody know what this error means:
"Server: Msg 3624, Level 20, State 1, Line 1
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 111
Process ID: 2028
Connection Broken"
I have a RESTORED database with about 10 large tables. A simple select
would return a couple of thousand of rows and then suddenly bomb out with
the above error. Interestingly the problem occurs only on the tables that
contain bigint columns, so I'm not sure if it's related. If I run "dbcc
checktable" on these table it returns lots of errors. I'm pretty sure the
database is not corrupt - it happens on any number of machines, plus the
database works fine at its original location. When I try to repair the
restored tables using "checktable" I can only do so with
"repair_allow_data_loss", not a good option of course. Also I have to
remove any indexes I have on the bigint columns. Any ideas?
ThanksHi,
Thanks for the reply. Yes, I have tried that, but it doesn't work - it only
works with "repair_allow_data_loss". Most of the errors are "consistency"
errors. It seems to me the problem lies with the bigint fields, but I'm not
sure why. I'm pretty sure the problem is not related to the indexes,
because only two of the problem tables have indexes. If I drop the indexes,
some of the errors (like "missing parents") go away, but the "consistency"
ones remain.
Tnx,
Pieter
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:100C38FB-3B9B-43F6-8700-DECF9E014C74@.microsoft.com...
> Have you tried using checktable with Repair_Rebuild. If that does not
work then I would try deleting the indexes and rechecking then.
> Jeff
> MCDBA, MCSE+I

problem with bigints in SS 2000

Anybody know what this error means:
"Server: Msg 3624, Level 20, State 1, Line 1
Location: p:\sql\ntdbms\storeng\drs\include\record
.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 111
Process ID: 2028
Connection Broken"
I have a RESTORED database with about 10 large tables. A simple select
would return a couple of thousand of rows and then suddenly bomb out with
the above error. Interestingly the problem occurs only on the tables that
contain bigint columns, so I'm not sure if it's related. If I run "dbcc
checktable" on these table it returns lots of errors. I'm pretty sure the
database is not corrupt - it happens on any number of machines, plus the
database works fine at its original location. When I try to repair the
restored tables using "checktable" I can only do so with
"repair_allow_data_loss", not a good option of course. Also I have to
remove any indexes I have on the bigint columns. Any ideas?
ThanksHave you tried using checktable with Repair_Rebuild. If that does not work
then I would try deleting the indexes and rechecking then.
Jeff
MCDBA, MCSE+I|||Hi,
Thanks for the reply. Yes, I have tried that, but it doesn't work - it only
works with "repair_allow_data_loss". Most of the errors are "consistency"
errors. It seems to me the problem lies with the bigint fields, but I'm not
sure why. I'm pretty sure the problem is not related to the indexes,
because only two of the problem tables have indexes. If I drop the indexes,
some of the errors (like "missing parents") go away, but the "consistency"
ones remain.
Tnx,
Pieter
"Jeff Duncan" <jduncan@.gtefcu.org> wrote in message
news:100C38FB-3B9B-43F6-8700-DECF9E014C74@.microsoft.com...
> Have you tried using checktable with Repair_Rebuild. If that does not
work then I would try deleting the indexes and rechecking then.
> Jeff
> MCDBA, MCSE+I

Problem with backup and restore

When I am backuping and after restoring the DB on another server, all Users
of this DB can't connect to this DB. I am getting teh error "login failed
for user 'somebody' ".
In DB Folder Users , this user exist.Vaidas
Search on internet for two stored procedures ('sp_help_revlogin') provided
by MS to move logins with their original SID
"Vaidas Gudas" <vaidas.gudas@.rst.lt> wrote in message
news:%23Dp$na43FHA.3880@.TK2MSFTNGP12.phx.gbl...
> When I am backuping and after restoring the DB on another server, all
> Users of this DB can't connect to this DB. I am getting teh error "login
> failed for user 'somebody' ".
> In DB Folder Users , this user exist.
>|||Hi ,
use dts tranfer login task . It will tranfer all the logins to the
restored database server.
from
Doller
Uri Dimant wrote:
> Vaidas
> Search on internet for two stored procedures ('sp_help_revlogin') provided
> by MS to move logins with their original SID
> "Vaidas Gudas" <vaidas.gudas@.rst.lt> wrote in message
> news:%23Dp$na43FHA.3880@.TK2MSFTNGP12.phx.gbl...
> > When I am backuping and after restoring the DB on another server, all
> > Users of this DB can't connect to this DB. I am getting teh error "login
> > failed for user 'somebody' ".
> > In DB Folder Users , this user exist.
> >|||yes but not with their oridinal SID
"doller" <sufianarif@.gmail.com> wrote in message
news:1130921760.840115.43300@.g14g2000cwa.googlegroups.com...
> Hi ,
> use dts tranfer login task . It will tranfer all the logins to the
> restored database server.
> from
> Doller
> Uri Dimant wrote:
>> Vaidas
>> Search on internet for two stored procedures ('sp_help_revlogin')
>> provided
>> by MS to move logins with their original SID
>> "Vaidas Gudas" <vaidas.gudas@.rst.lt> wrote in message
>> news:%23Dp$na43FHA.3880@.TK2MSFTNGP12.phx.gbl...
>> > When I am backuping and after restoring the DB on another server, all
>> > Users of this DB can't connect to this DB. I am getting teh error
>> > "login
>> > failed for user 'somebody' ".
>> > In DB Folder Users , this user exist.
>> >
>sql

Problem with backup and restore

Problem with Backup

Hello!
I am starting to use SQL Server in my Company and I am having problem
with DataBase Backup.
The following error appears on the History Job.
The SQL Statement is:
BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME =
PcyMgntProd backup, NOSKIP , STATS = 10, DESCRIPTION = Daily
backup, NOFORMAT
The error is:
Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
(WrapperRead()). [SQLSTATE 01000] (Message 258) General network
error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
- - - - -
If anybody knows what is happen.
Thanks
Juliano Horta
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Probl...ict253160.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=874693
Hi
This may be the issue:
http://support.microsoft.com/default...b;en-us;827452
John
"jhnegrao" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_874693_3539bcc3020afe5f4788b11551220d0a@.dbf orumz.com...
> Hello!
> I am starting to use SQL Server in my Company and I am having problem
> with DataBase Backup.
> The following error appears on the History Job.
> The SQL Statement is:
> BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME =
> 'PcyMgntProd backup', NOSKIP , STATS = 10, DESCRIPTION = 'Daily
> backup', NOFORMAT
> The error is:
> Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
> (WrapperRead()). [SQLSTATE 01000] (Message 258) General network
> error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
> 10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
> - - - - -
> If anybody knows what is happen.
> Thanks
> Juliano Horta
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/Server-Probl...ict253160.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=874693

Problem with Backup

Hello!
I am starting to use SQL Server in my Company and I am having problem
with DataBase Backup.
The following error appears on the History Job.
The SQL Statement is:
BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME =
PcyMgntProd backup, NOSKIP , STATS = 10, DESCRIPTION = Daily
backup, NOFORMAT
The error is:
Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
(WrapperRead()). [SQLSTATE 01000] (Message 258) General network
error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
- - - - -
If anybody knows what is happen.
Thanks
Juliano Horta
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Prob...pict253160.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz
.com/eform.php?p=874693Hi
This may be the issue:
http://support.microsoft.com/defaul...kb;en-us;827452
John
"jhnegrao" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_874693_3539bcc3020afe5f4788b11551
220d0a@.dbforumz.com...
> Hello!
> I am starting to use SQL Server in my Company and I am having problem
> with DataBase Backup.
> The following error appears on the History Job.
> The SQL Statement is:
> BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME =
> 'PcyMgntProd backup', NOSKIP , STATS = 10, DESCRIPTION = 'Daily
> backup', NOFORMAT
> The error is:
> Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
> (WrapperRead()). [SQLSTATE 01000] (Message 258) General network
> error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
> 10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
> - - - - -
> If anybody knows what is happen.
> Thanks
> Juliano Horta
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/Server-Prob...pict253160.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=874693

Problem with Backup

Hello!
I am starting to use SQL Server in my Company and I am having problem
with DataBase Backup.
The following error appears on the History Job.
The SQL Statement is:
BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME = ?PcyMgntProd backup?, NOSKIP , STATS = 10, DESCRIPTION = ?Daily
backup?, NOFORMAT
The error is:
Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
(WrapperRead()). [SQLSTATE 01000] (Message 258) General network
error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
- - - - -
If anybody knows what is happen.
Thanks
Juliano Horta
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Server-Problem-Backup-ftopict253160.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=874693Hi
This may be the issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
John
"jhnegrao" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_874693_3539bcc3020afe5f4788b11551220d0a@.dbforumz.com...
> Hello!
> I am starting to use SQL Server in my Company and I am having problem
> with DataBase Backup.
> The following error appears on the History Job.
> The SQL Statement is:
> BACKUP DATABASE [PcyMgntProd] TO PMIProdBkp WITH INIT, NAME => 'PcyMgntProd backup', NOSKIP , STATS = 10, DESCRIPTION = 'Daily
> backup', NOFORMAT
> The error is:
> Executed as user: NT AUTHORITY\SYSTEM. ConnectionRead
> (WrapperRead()). [SQLSTATE 01000] (Message 258) General network
> error. Check your network documentation. [SQLSTATE 08S01] (Error 11)
> 10 percent backed up. [SQLSTATE 01000] (Error 3211). The step failed.
> - - - - -
> If anybody knows what is happen.
> Thanks
> Juliano Horta
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/Server-Problem-Backup-ftopict253160.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=874693

Monday, March 26, 2012

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 an xpath parameter to StoredProc

Hey,
I am getting a parse error on this SP expression. I'd assumed this work
work.
error is "Incorrect syntax near the keyword 'exists'."
CREATE PROCEDURE dbo.sp_ListTemplates
(
@.PropXPath varchar(1024),
)
AS
BEGIN
SET XACT_ABORT ON
SET NOCOUNT ON
SELECT fileName, docProps, version
FROM Template
WHERE docProps.exists('sql:variable("@.PropXPath")') = 1
END
GO
Chris Harrington
Active Interface, Inc.
http://www.activeinterface.comNever mind - "exist" not "exists"
"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:%23TqFrlBlGHA.4444@.TK2MSFTNGP02.phx.gbl...
> Hey,
> I am getting a parse error on this SP expression. I'd assumed this work
> work.
> error is "Incorrect syntax near the keyword 'exists'."
> CREATE PROCEDURE dbo.sp_ListTemplates
> (
> @.PropXPath varchar(1024),
> )
> AS
> BEGIN
> SET XACT_ABORT ON
> SET NOCOUNT ON
> SELECT fileName, docProps, version
> FROM Template
> WHERE docProps.exists('sql:variable("@.PropXPath")') = 1
> END
> GO
> Chris Harrington
> Active Interface, Inc.
> http://www.activeinterface.com
>|||Seems it doesn't work after all. SP compiles but when I pass in an XPath
expression, it returns all records - regardless of the XPath I pass in:
EXEC dbo.sp_ListTemplates '/o:CustomDocumentProperties[o:Category="6"]';
GO
-- returns all records, not just those which match xpath
Obviously I don't fully understand the use of sql:variable() here.
Anyone got a solution for passing a string param which is used as an XPath
expression?
Chris
"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:%23TqFrlBlGHA.4444@.TK2MSFTNGP02.phx.gbl...
> Hey,
> I am getting a parse error on this SP expression. I'd assumed this work
> work.
> error is "Incorrect syntax near the keyword 'exists'."
> CREATE PROCEDURE dbo.sp_ListTemplates
> (
> @.PropXPath varchar(1024),
> )
> AS
> BEGIN
> SET XACT_ABORT ON
> SET NOCOUNT ON
> SELECT fileName, docProps, version
> FROM Template
> WHERE docProps.exists('sql:variable("@.PropXPath")') = 1
> END
> GO
> Chris Harrington
> Active Interface, Inc.
> http://www.activeinterface.com
>|||Chris,
The behavior you're experiencing is by design. When you use sql:variable()
the way you do you construct a text node, and therefore the exist method wil
l
always return one since the expression didn't return the empty sequence. The
contents of the variable are in no way interpreted as an XPath expression.
Currently there is no way to parameterize the expression used by the exist
method. You can however construct the whole T-SQL statement in a string vari
able
and run it using sp_executesql.
Denis Ruckebusch
http://blogs.msdn.com/denisruc
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:uTDXOEKlGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Seems it doesn't work after all. SP compiles but when I pass in an XPath
> expression, it returns all records - regardless of the XPath I pass in:
> EXEC dbo.sp_ListTemplates '/o:CustomDocumentProperties[o:Category="6"]';
> GO
> -- returns all records, not just those which match xpath
> Obviously I don't fully understand the use of sql:variable() here.
> Anyone got a solution for passing a string param which is used as an XPath
> expression?
> Chris
>
> "ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
> news:%23TqFrlBlGHA.4444@.TK2MSFTNGP02.phx.gbl...
>

problem with an UPDATE...

trying to create an UPDATE but am getting and error.
"Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."

update XAPCHECKS
set xapck_amt =
(select sum(apph_paymnts), * from APPHISTF
LEFT JOIN APTRANF on apt_comp = apph_comp and apt_vend = apph_vend and apt_type = apph_type and apt_id = apph_id
LEFT JOIN APBANKF ON apb_code = apt_bank
left join CHMASTF on chm_comp = apb_comp and chm_acct = apb_cash and chm_no = apph_payck
where (apph_comp = '01') and (apph_vend = '1010') and
xapck_check = apph_payck and xapck_chk_type = (CASE chm_type WHEN null THEN ' ' ELSE chm_type END) and xapck_check_status = (CASE chm_stat when null then ' ' ELSE chm_stat END)
and xapck_bank = apt_bank
GROUP by apph_comp, apph_vend, apph_payck, chm_type, chm_stat, apph_paymnts, apph_stat, apph_type, apt_bank, apph_id, apph_paymnts)the problem is here --

set xapck_amt = (select sum(apph_paymnts), *

the error says the subquery has more than one column|||"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated."|||ah, that's because the subquery used in a SET can return only one column, one row

it's called a scalar subquery because it's supposed to return only a single scalar value|||not sure why i had that in there but it seems to working ok.
thanks

Friday, March 23, 2012

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]
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) 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) 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) 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 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 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)