error: identifier stored proc name is out of scope

Does anyone know what this error message is telling me.

Thanks in advance everyone.

RBCan you show us the code that is generating this error?

Terri|||Terri,

 Public Shared Function GetSelectedFunds() As DataTable
 'Dim GlobalConnString As String = System.Configuration.ConfigurationSettings.AppSettings("ConnectionString")
 'Dim SelectedCenter As Integer = ddlCenters.SelectedItem.Value
 Try
 Return ExecuteDataset(SqlHelper.GlobalConnString, CommandType.StoredProcedure, "GetSelectedFOIFunds", New SqlParameter("@.ParentFund", Test.SelectedCenter)).Tables(0)
 Catch Ex As Exception
 Throw New ApplicationException("An error occurred while executing GetSelectedFunds", Ex)
 End Try
 End Function
 Sub subCenterListChange(ByVal S As Object, ByVal E As EventArgs)
 SelectedCenter = ddlCenters.SelectedItem.Value
 ddlFOI.DataSource = GetSelectedFunds()
 ddlFOI.DataBind()
 End Sub

What i'm trying to do is once a user makes a selection on the first dropdown list then I want to fire off the second drop down list and fill it with a result set that is based on the first selection.

For some reason it is not firing off and it is saying the following:

''error: identifier 'stored procedure name' is out of scope'

Any help is appricated:

Thanks again

RB

Error: Data Mining message

This may well be embarrasingly simple but....

I get this massage from Management Studion when I try to run any MDX

Error (Data mining): Either the user, LEONARD\Will Riley, does not have permission to access the referenced mining model, Contribution_Interest, or the object does not exist.

Is there something really simple I have missed?

Most likely you made syntax error in your MDX up tp a degree that it actually looks more like DMX than MDX, so AS tries to find mining model instead of cube. If you will paste your MDX statement, the forum should be able to help and fix it.|||

Yep, you got it

Once I plugged in what I knew to be some correctly structured MDX, the issue went away.

Cheers, Will

Error: CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:\DOCUME~1\

Hello,

I am having a crystal report using datastored in a dataset. When I select one of items in a dropdownlist, it gives me this error message. Note that I used that code before in another web page using a different crystal report and a different dataSet and it worked successfully, but this time it doesn't work...anyone can tell me what causes this error and how to solve it?

NOTE: I am using a vb code behind in my .aspx page

Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:CrystalDecisions.CrystalReports.Engine.FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt: Error in formula <Record_Selection>. '{StProd2.ItemDescription}' The result of selection formula must be a boolean.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[FormulaException: Error in File C:\DOCUME~1\AM-TK-~1\ASPNET\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt:Error in formula <Record_Selection>. '{StProd2.ItemDescription}'The result of selection formula must be a boolean.]  . F(String  , EngineExceptionErrorID  )  . A(Int16   , Int32   )  . @.(Int16  ) CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestContext reqContext) CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestContext pageReqContext) CrystalDecisions.Web.ReportAgent.u(Boolean  N) CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Page.ProcessRequestMain()

Dear Frnd',

It will nice if you provied more info, like in drop you are selecting which report to get or some value on which parameter it get the dataset.

or what are the datatype in database & on report.

Some more detail need to get it root.

Error: ConnectionCheckForData (CheckforData()).

Here is the error message that I am getting:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

The situation is this:
Client: Microsoft Windows 2003 Standard
Client s/w: Microsoft SQL Server 2000 Client Tools (patched with SP4)

Server: Microsoft Windows 2003 Standard (SP1)
Server s/w: MSDE 2000, SP3

Network:
Connection is made over a MAN through two firewalls.

Error conditions:
1. I am able to make the initial connection.
2. I am able to perform:
a. SELECT @.@.VERSION
b. SELECT Host_Name()
c. SELECT TOP 1 * FROM sysfiles
3. I get the error whenever I attempt to perform any multi-row recordset (such as SELECT TOP 2 * FROM sysfiles).

We have restarted the SQL instance and the error repeated itself immediately.

When we restart the server, the error goes away. Right now, I am trying to figure out how long from the time the server is restarted to the time the failures appear. By the way, the server is not mine; it's managed by a partner agency so I have limited access to system statistical functions. I have tried inspecting @.@.PACK_SENT, @.@.PACK_RECEIVED and @.@.PACKET_ERRORS, but I do not have access to sysperfinfo or perf monitor.

I have tried Googling the error message and the results seem to be scattered: there was a problem with corrupt indexes (fixed in SP4), a problem with distributed inserts and some other issues that don't seem to apply in this situation.

I am mystified and I don't know what to suggest. If any of you have any ideas, I would be grateful for your thoughts.

Regards,

hmscottCheck ur networking hardware or configuration
somewhere. Look at your network interface settings - especially duplex
settings. Sometimes setting the NICs to Auto duples causes these errors.

checked SQL Server error log? Stack dumps?

Error: Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "

Hi,

I′m trying to make several distributed queries to a linked server, and for some of them I get this error message. I can′t find anytihing about it anywhere. Can anyone tell me what could be the reason of this error? The way I'm executing the query in my stored procedure is:

exec sp_executesql @.sqlinsert

@.sqlinsert being a nvarchar sentence that contains the distibuted query.

Thank you!

Mehdi

Guess the provider needs a return value. I don′t know if it needs a return status like return 1 or return 0, or he needs something to handle (just a dummy select or something else. Try setting the return value for the stored procedure.

HTH, Jens Suessmeyer.

Error: 823

Hi,

I am I notice this message on the event logs.

Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x000003182da000 in file 'e:\sqlData\FSDocsOnline.mdf'.

If I was to run:

DBCC CHECKDB
( 'database_name'
[ , NOINDEX
| { REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST
| REPAIR_REBUILD
} ]
) [ WITH { [ ALL_ERRORMSGS ]
[ , [ NO_INFOMSGS ] ]
[ , [ TABLOCK ] ]
[ , [ ESTIMATEONLY ] ]
[ , [ PHYSICAL_ONLY ] ]
}
]

Will it fix my problem or will I need to restore the database. Which have no backup.

LystraYou might be able to fix the database, but I'd be more comfortable with either restoring a backup, or better yet trying to copy the data out one table at a time (saving the backup for a last resort).

A lot depends on just what is broken and how it broke. I don't have a good way to guess what caused the problem, so I'd assume that it will be tough to fix.

-PatP|||Well there is no Backup for this database. The last time it was backup was in 10/03. And the files have since been deleted.

In order to copy the time out one at a time what would this accomplish. And to do this should I use the bCP out method?

Thanking you in advance.

Lystra|||Brett would say yes to the BCP part.|||The method you use for the copy isn't really significant. You can BCP to flat files, or you can just use an INSERT if both databases are on the same server, or DTS if they are on different servers.

The trick is to copy data until the copy fails (due to the problem with the disk), then find a way to resume the copy just past the problem. The easiest way to do this is using PK values to copy what you can, then move a few PK values higher and start again. If there was only one flaw, then you can copy from the low PK values up, then from the high PK values down and you will have all of the recoverable data. If you have more than one flaw, then you'll have to fuss with the copy a bit, trying to "jump" the flaws.

-PatPsql

Error: 7105, Severity: 22, State: 6

it is a SQL 2000 with SP4 on Windows server 2003 SP1.
"ME" <ME@.mail.com> wrote in message news:...
> My SQL server logs this in Application log:
> Error: 7105, Severity: 22, State: 6
> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
> for
> a hot fix for this problem.
> I believe this call is free because this is a bug. Can anyone confirm
> this?
> Thanks.
>
The affinity mask is set as default. The server is 2 dual core CPUs. SQL
sees and uses all of 4 CPUs.
"ME" <ME@.mail.com> wrote in message
news:egU%23OuT$GHA.1224@.TK2MSFTNGP04.phx.gbl...
> it is a SQL 2000 with SP4 on Windows server 2003 SP1.
>
> "ME" <ME@.mail.com> wrote in message news:...
>

Error: 7105, Severity: 22, State: 6

it is a SQL 2000 with SP4 on Windows server 2003 SP1.
"ME" <ME@.mail.com> wrote in message news:...
> My SQL server logs this in Application log:
>
> Error: 7105, Severity: 22, State: 6
> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
>
> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
> for
> a hot fix for this problem.
>
> I believe this call is free because this is a bug. Can anyone confirm
> this?
> Thanks.
>
>The affinity mask is set as default. The server is 2 dual core CPUs. SQL
sees and uses all of 4 CPUs.
"ME" <ME@.mail.com> wrote in message
news:egU%23OuT$GHA.1224@.TK2MSFTNGP04.phx.gbl...
> it is a SQL 2000 with SP4 on Windows server 2003 SP1.
>
> "ME" <ME@.mail.com> wrote in message news:...
>> My SQL server logs this in Application log:
>> Error: 7105, Severity: 22, State: 6
>> Page (1:952446), slot 39 for text, ntext, or image node does not exist.
>> MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS
>> for
>> a hot fix for this problem.
>> I believe this call is free because this is a bug. Can anyone confirm
>> this?
>> Thanks.
>>
>

Error: 644, Severity: 21, State: 3

How do I actually identify the table to which the index that is having the p
roblem applies? The error message detail gives me an "index page (1:427282)
" and an "index ID 0", in addition to the "RID some long binary string". In
order to reindex using DBC
C DBREINDEX, I need to know the table.
Also, this is the second time in a couple of weeks we've had this problem.
We've used DBCC CHECKDB with the rebuild/repair option (which requires the d
atabase be in single-user mode), received an error of similar kind on tempdb
, then used DBCC DBREINDEX
on the table (which we knew by fortuitous circumstance), and that resolved i
t...for about a week-and-a-half. What should we look into as the potential
cause of this recurrence?
Thanks!Not sure your SQL build, but there was an article for updates under Read
Uncommitted isolation with sort and spool operations:
http://support.microsoft.com/defaul...kb;en-us;328736
Christopher Winn
Business Intelligence Engineer
Edugration Corp.
"JohnAtAMCO" <John.Nowak@.AMCO.Net> wrote in message
news:0F42A68E-9F4A-4BCC-BFDB-33FF49079BBD@.microsoft.com...
> How do I actually identify the table to which the index that is having the
problem applies? The error message detail gives me an "index page
(1:427282)" and an "index ID 0", in addition to the "RID some long binary
string". In order to reindex using DBCC DBREINDEX, I need to know the
table.
> Also, this is the second time in a couple of weeks we've had this problem.
We've used DBCC CHECKDB with the rebuild/repair option (which requires the
database be in single-user mode), received an error of similar kind on
tempdb, then used DBCC DBREINDEX on the table (which we knew by fortuitous
circumstance), and that resolved it...for about a week-and-a-half. What
should we look into as the potential cause of this recurrence?
> Thanks!|||Thanks, Chris. I read that article, as well as a couple of others on the 64
4 error. Unfortunately, we don't seem to be doing any of the things mention
ed (such as collating a unicode column with Latin1_General_BIN, or using upp
ercase preference sort orde
r on a column, etc.).
Also, none of them tell me how to translate the Index Page, Index ID, or RID
Binary String into the actual table to which the Index belongs. That's one
of the things I really need to know in order to further troubleshoot and re
solve this problem.
Any suggestions?
Thanks,
John
-- Winn, Chris wrote: --
Not sure your SQL build, but there was an article for updates under Read
Uncommitted isolation with sort and spool operations:
http://support.microsoft.com/defaul...kb;en-us;328736
Christopher Winn
Business Intelligence Engineer
Edugration Corp.
"JohnAtAMCO" <John.Nowak@.AMCO.Net> wrote in message
news:0F42A68E-9F4A-4BCC-BFDB-33FF49079BBD@.microsoft.com...
> How do I actually identify the table to which the index that is having the
problem applies? The error message detail gives me an "index page
(1:427282)" and an "index ID 0", in addition to the "RID some long binary
string". In order to reindex using DBCC DBREINDEX, I need to know the
table.
We've used DBCC CHECKDB with the rebuild/repair option (which requires the
database be in single-user mode), received an error of similar kind on
tempdb, then used DBCC DBREINDEX on the table (which we knew by fortuitous
circumstance), and that resolved it...for about a week-and-a-half. What
should we look into as the potential cause of this recurrence?|||I'd be willing to bet, since you mentioned a similar error against the
tempdb, your server is experiecing hardware faults and you should be
prepared for failure. There is no such Index ID 0 anywhere in MSSQL. That
error shows up in only a few "bug fixes" as mentioned previously.
Chris
"JohnAtAMCO" <anonymous@.discussions.microsoft.com> wrote in message
news:3B57F016-6EA4-4561-B343-BC57DFEF9025@.microsoft.com...
> Thanks, Chris. I read that article, as well as a couple of others on the
644 error. Unfortunately, we don't seem to be doing any of the things
mentioned (such as collating a unicode column with Latin1_General_BIN, or
using uppercase preference sort order on a column, etc.).
> Also, none of them tell me how to translate the Index Page, Index ID, or
RID Binary String into the actual table to which the Index belongs. That's
one of the things I really need to know in order to further troubleshoot and
resolve this problem.
> Any suggestions?
> Thanks,
> John
> -- Winn, Chris wrote: --
> Not sure your SQL build, but there was an article for updates under
Read
> Uncommitted isolation with sort and spool operations:
> http://support.microsoft.com/defaul...kb;en-us;328736
> Christopher Winn
> Business Intelligence Engineer
> Edugration Corp.
> "JohnAtAMCO" <John.Nowak@.AMCO.Net> wrote in message
> news:0F42A68E-9F4A-4BCC-BFDB-33FF49079BBD@.microsoft.com...
having the
> problem applies? The error message detail gives me an "index page
> (1:427282)" and an "index ID 0", in addition to the "RID some long
binary
> string". In order to reindex using DBCC DBREINDEX, I need to know
the
> table.
problem.
> We've used DBCC CHECKDB with the rebuild/repair option (which
requires the
> database be in single-user mode), received an error of similar kind
on
> tempdb, then used DBCC DBREINDEX on the table (which we knew by
fortuitous
> circumstance), and that resolved it...for about a week-and-a-half.
What
> should we look into as the potential cause of this recurrence?
>
>|||Chris,
Too bad you're not the guy responsible for our server hardware He insist
s it can't be hardware, it's all redundantly fault-tolerant, so my earlier s
uggestions to look for a disk failure have not been heard...
Meanwhile, I'm still hoping someone can tell me how to locate the table, giv
en the info in the error message. The MSDN SQL Server Troubleshooting page
that corresponds to this error says:
1. Record the value of index page and index ID...
2. Identify which table and index correspond to the index page number.
...
But nowhere does it tell me how to get from step 1 to step 2! How do I iden
tify the table and index from the index page and index ID?
Thanks again,
John|||AN indid = 0 is a heap table ( no clustered index)..
The DBCC PAGE command will give you the object ID that the page belongs to,
then (in the appropriate db)
select object_name(id) will give you the table name
DBCC page details can be found at
http://support.microsoft.com/defaul...=kb;en-us;83065
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"JohnAtAMCO" <john.nowak@.amco.net> wrote in message
news:BD6079EB-4995-4FE7-90A1-E786D929BEC9@.microsoft.com...
> Chris,
> Too bad you're not the guy responsible for our server hardware He
insists it can't be hardware, it's all redundantly fault-tolerant, so my
earlier suggestions to look for a disk failure have not been heard...
> Meanwhile, I'm still hoping someone can tell me how to locate the table,
given the info in the error message. The MSDN SQL Server Troubleshooting
page that corresponds to this error says:
> 1. Record the value of index page and index ID...
> 2. Identify which table and index correspond to the index page number.
> ...
> But nowhere does it tell me how to get from step 1 to step 2! How do I
identify the table and index from the index page and index ID?
> Thanks again,
> John|||Hi John,
What kind of hardware is this? HP/Compaq? If so, I suggest upgrading
firmware of the controller. It may not be hard disk problem but
controller.
Yih-Yoon Lee
On Tue, 23 Mar 2004 09:36:06 -0800, JohnAtAMCO wrote:

> Chris,
> Too bad you're not the guy responsible for our server hardware He insi
sts it can't be hardware, it's all redundantly fault-tolerant, so my earlier
suggestions to look for a disk failure have not been heard...
> Meanwhile, I'm still hoping someone can tell me how to locate the table, g
iven the info in the error message. The MSDN SQL Server Troubleshooting pag
e that corresponds to this error says:
> 1. Record the value of index page and index ID...
> 2. Identify which table and index correspond to the index page number.
> ...
> But nowhere does it tell me how to get from step 1 to step 2! How do I id
entify the table and index from the index page and index ID?
> Thanks again,
> Johnsql

Error: 605, Severity: 21, State: 1

Below message is frequently appearing in error log file. Before posting this
issue I searched net but I am not sure how to overcome this issue as it is
Production System and I am not much aware of SQL Server 2000. I can count on
table 'ComputerVulnerability' but cannot export the data. Your guidance will
be highly appreciated in helping and solving the issue before it become
critical.
(1:182850)/(1:182850)0/612197231
... IAM indicates that page is allocated to this object
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:182850)
in database 'Prod' belongs to object '0', not to object
'ComputerVulnerability'..
Hello,
As a first step execute a DBCC CHECKDB and get mofre information on the
error. To solve this you may need to try executing the DBCC with
REPAIR_REBUILD and if the issue is not solved you may need to take a backup
of database execute DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS .
If nothing works out you may need to restore from a last good backup. In
parallel you could create a Microsoft case and get the help of microsoft
product support.
Thanks
Hari
"Bini" <Bini@.discussions.microsoft.com> wrote in message
news:9EAD09C3-23F9-4F85-AC26-A9E247D3502E@.microsoft.com...
> Below message is frequently appearing in error log file. Before posting
> this
> issue I searched net but I am not sure how to overcome this issue as it is
> Production System and I am not much aware of SQL Server 2000. I can count
> on
> table 'ComputerVulnerability' but cannot export the data. Your guidance
> will
> be highly appreciated in helping and solving the issue before it become
> critical.
> (1:182850)/(1:182850) 0/612197231
> ... IAM indicates that page is allocated to this object
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:182850)
> in database 'Prod' belongs to object '0', not to object
> 'ComputerVulnerability'..

Error: 605, Severity: 21, State: 1

Below message is frequently appearing in error log file. Before posting this
issue I searched net but I am not sure how to overcome this issue as it is
Production System and I am not much aware of SQL Server 2000. I can count on
table 'ComputerVulnerability' but cannot export the data. Your guidance will
be highly appreciated in helping and solving the issue before it become
critical.
(1:182850)/(1:182850) 0/612197231
... IAM indicates that page is allocated to this object
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:182850)
in database 'Prod' belongs to object '0', not to object
'ComputerVulnerability'..Hello,
As a first step execute a DBCC CHECKDB and get mofre information on the
error. To solve this you may need to try executing the DBCC with
REPAIR_REBUILD and if the issue is not solved you may need to take a backup
of database execute DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS .
If nothing works out you may need to restore from a last good backup. In
parallel you could create a Microsoft case and get the help of microsoft
product support.
Thanks
Hari
"Bini" <Bini@.discussions.microsoft.com> wrote in message
news:9EAD09C3-23F9-4F85-AC26-A9E247D3502E@.microsoft.com...
> Below message is frequently appearing in error log file. Before posting
> this
> issue I searched net but I am not sure how to overcome this issue as it is
> Production System and I am not much aware of SQL Server 2000. I can count
> on
> table 'ComputerVulnerability' but cannot export the data. Your guidance
> will
> be highly appreciated in helping and solving the issue before it become
> critical.
> (1:182850)/(1:182850) 0/612197231
> ... IAM indicates that page is allocated to this object
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:182850)
> in database 'Prod' belongs to object '0', not to object
> 'ComputerVulnerability'..

Error: 605, Severity: 21, State: 1

Below message is frequently appearing in error log file. Before posting thi
s
issue I searched net but I am not sure how to overcome this issue as it is
Production System and I am not much aware of SQL Server 2000. I can count on
table 'ComputerVulnerability' but cannot export the data. Your guidance will
be highly appreciated in helping and solving the issue before it become
critical.
(1:182850)/(1:182850) 0/612197231
... IAM indicates that page is allocated to this object
Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:182850)
in database 'Prod' belongs to object '0', not to object
'ComputerVulnerability'..Hello,
As a first step execute a DBCC CHECKDB and get mofre information on the
error. To solve this you may need to try executing the DBCC with
REPAIR_REBUILD and if the issue is not solved you may need to take a backup
of database execute DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS .
If nothing works out you may need to restore from a last good backup. In
parallel you could create a Microsoft case and get the help of microsoft
product support.
Thanks
Hari
"Bini" <Bini@.discussions.microsoft.com> wrote in message
news:9EAD09C3-23F9-4F85-AC26-A9E247D3502E@.microsoft.com...
> Below message is frequently appearing in error log file. Before posting
> this
> issue I searched net but I am not sure how to overcome this issue as it is
> Production System and I am not much aware of SQL Server 2000. I can count
> on
> table 'ComputerVulnerability' but cannot export the data. Your guidance
> will
> be highly appreciated in helping and solving the issue before it become
> critical.
> (1:182850)/(1:182850) 0/612197231
> ... IAM indicates that page is allocated to this object
> Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:182850)
> in database 'Prod' belongs to object '0', not to object
> 'ComputerVulnerability'..

Error: 50001

Hi,
In these days in one of my db there is this message:
"Error: 50001, Severity: 15, State: 1
2006-06-06 06:00:18.01 spid53 error- NUMBER OF ROW IN
CRM_COMPANY_TO_MN O CRM_COMPANY_PRODUCT O OD_CRM_STATUS_DECODING NON
CORRECT."
What the problem?
Please let me know understand the reson of the trouble.
Thanks in advance.
LucaErrors with numbers equal to and above 50000 are user-defined errors. These
could also have been added as part of a software installation. You should
consult the vendors documentation, or your company's documentation.
ML
http://milambda.blogspot.com/|||ML ha scritto:

> Errors with numbers equal to and above 50000 are user-defined errors. Thes
e
> could also have been added as part of a software installation. You should
> consult the vendors documentation, or your company's documentation.
Ok thank you very much ML
>
> ML
> --
> http://milambda.blogspot.com/

Error: 3624 - SQL Server Assertion

Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
************************************************** **************************
***
Thanks in advance,
Jerry Dennany
Jerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/r...1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
************************************************** **************************
> ***
>
> Thanks in advance,
> Jerry Dennany
>
|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/r...1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
* ----
> 0x2EF0EDAD
> Server\MSSQL\log\SQLDump0033.txt
>
************************************************** **************************
>
|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||The following is the SqlException our code got when that happens. What Jerry and I don't understand is that the error message "Duplicate key was ignored" should be associated with SQL error 3604, which is only on severity level 16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster index (QueuedTime, Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual processors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient .SqlException:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$all ocator@.PAU_PARAM@.@.@.std@.@.@.std@.@.W4COMMANDTYPE@.@.@.Z(In t32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
|||Can you send me the code directly to my e-mail (just take out the "_please_reply..." part out of the address and I will try to reproduce the error? BTW, which versions of SQL Server and .NET Framework are you using?
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message news:uu3i%23lUJEHA.3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. What Jerry and I don't understand is that the error message "Duplicate key was ignored" should be associated with SQL error 3604, which is only on severity level 16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster index (QueuedTime, Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual processors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient .SqlException:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$all ocator@.PAU_PARAM@.@.@.std@.@.@.std@.@.W4COMMANDTYPE@.@.@.Z(In t32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>

Error: 3624 - SQL Server Assertion

Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************
************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************
************************************[vbc
ol=seagreen]
> ***
>
> Thanks in advance,
> Jerry Dennany
>[/vbcol]|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/...=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
* ----
> 0x2EF0EDAD
> Server\MSSQL\log\SQLDump0033.txt
>
****************************************
************************************[vbc
ol=seagreen]
>[/vbcol]|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>|||Can you send me the code directly to my e-mail (just take out the "_please_r
eply..." part out of the address and I will try to reproduce the error? BTW,
which versions of SQL Server and .NET Framework are you using?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message news:uu3i%23lUJEHA.3436@.tk2
msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. What Jerr
y and I don't understand is that the error message "Duplicate key was ignore
d" should be associated with SQL error 3604, which is only on severity level
16 that will not throw the exception, (while error 3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) with "Ign
ore duplicate key", and a composit cluster index (QueuedTime, Odometer). Th
e Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual process
ors.
Error: 3624
General message:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlExce
ption:
Location: insert.c:573
Expression: sdesP->m_pIndex->indindid == CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavio
r, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.
@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message news:ecsL
MESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> anything
>
> Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the problem
> would be reproducable.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>

Error: 3624 - SQL Server Assertion

Ok, I keep getting SQL Server assertions in the event log, with the
following stack dump message in the SQL Server logs. Any ideas?
DBCC CHECKDB reveals no problems.
* ----
--
2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is 0x2EF0EDAD
2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
line=573
Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
*Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
*Stack Dump being sent to I:\Microsoft SQL Server\MSSQL\log\SQLDump0033.txt
*
****************************************************************************
***
Thanks in advance,
Jerry DennanyJerry,
If you search MS site for error 3624, which is mentioned in the stack dump,
you will find plenty of articles
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
&qu=3624&na=32). There are many possible reasons for this error. Just by
reading the article titles I guess you will be able to narrow the search to
your problem.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Jerry Dennany" <jerry@.dennany.org> wrote in message
news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
>
> Ok, I keep getting SQL Server assertions in the event log, with the
> following stack dump message in the SQL Server logs. Any ideas?
> DBCC CHECKDB reveals no problems.
>
>
* ----
> --
> 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
0x2EF0EDAD
> 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> line=573
> Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> *Stack Dump being sent to I:\Microsoft SQL
Server\MSSQL\log\SQLDump0033.txt
> *
>
****************************************************************************
> ***
>
> Thanks in advance,
> Jerry Dennany
>|||I suppose that I should have mentioned that I've already performed the
typical google and support.microsoft.com searches, without finding anything
applicable. Any other ideas?
Thanks,
Jerry Dennany
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OTZriQGJEHA.3704@.TK2MSFTNGP11.phx.gbl...
> Jerry,
> If you search MS site for error 3624, which is mentioned in the stack
dump,
> you will find plenty of articles
>
(http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=b
> &qu=3624&na=32). There are many possible reasons for this error. Just by
> reading the article titles I guess you will be able to narrow the search
to
> your problem.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Jerry Dennany" <jerry@.dennany.org> wrote in message
> news:uMM$BVDJEHA.556@.TK2MSFTNGP10.phx.gbl...
> >
> >
> > Ok, I keep getting SQL Server assertions in the event log, with the
> > following stack dump message in the SQL Server logs. Any ideas?
> >
> > DBCC CHECKDB reveals no problems.
> >
> >
> >
>
* ----
> > --
> > 2004-04-02 04:03:13.39 spid234 Stack Signature for the dump is
> 0x2EF0EDAD
> > 2004-04-02 04:03:13.39 spid234 SQL Server Assertion: File: <insert.c>,
> > line=573
> > Failed Assertion = 'sdesP->m_pIndex->indindid == CLUSTIND'.
> > 2004-04-02 04:03:13.39 spid234 Error: 3624, Severity: 20, State: 1.
> > *Dump thread - spid = 84, PSS = 0x3e049238, EC = 0x3e049560
> > *Stack Dump being sent to I:\Microsoft SQL
> Server\MSSQL\log\SQLDump0033.txt
> > *
> >
>
****************************************************************************
> > ***
> >
> >
> > Thanks in advance,
> >
> > Jerry Dennany
> >
> >
>|||> I suppose that I should have mentioned that I've already performed the
> typical google and support.microsoft.com searches, without finding
anything
> applicable. Any other ideas?
Sorry, not directly. Maybe you can track down what happens before this
error, which command makes the problem? It would be nice if the problem
would be reproducable.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||This is a multi-part message in MIME format.
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The following is the SqlException our code got when that happens. What =Jerry and I don't understand is that the error message "Duplicate key =was ignored" should be associated with SQL error 3604, which is only on =severity level 16 that will not throw the exception, (while error 3624 =is on level 20).
The database table has a composit unique index (Odometer, QueueID) with ="Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote =in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_01B4_01C42527.F1365AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the error =message "Duplicate key was ignored" should be associated with SQL error 3604, =which is only on severity level 16 that will not throw the exception, (while =error 3624 is on level 20). The database table has a composit unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit cluster =index (QueuedTime, Odometer). The Odometer column (int) is involved in =both indexes.Also, the server has 4 physical CPUs with hypertheading =to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D =CLUSTINDSPID: 168Process ID: 2920Duplicate =key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: =168Process ID: 2920Duplicate key was ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before this> =error, which command makes the problem? It would be nice if the problem> =would be reproducable.> > -- > Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More =than just Training> www.SolidQualityLearning.com> >

---

--=_NextPart_000_01B4_01C42527.F1365AC0--|||This is a multi-part message in MIME format.
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can you send me the code directly to my e-mail (just take out the ="_please_reply..." part out of the address and I will try to reproduce =the error? BTW, which versions of SQL Server and .NET Framework are you =using?
-- Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Yang Cao" <yang@.yangcao88.com> wrote in message =news:uu3i%23lUJEHA.3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our code got when that happens. =What Jerry and I don't understand is that the error message "Duplicate =key was ignored" should be associated with SQL error 3604, which is only =on severity level 16 that will not throw the exception, (while error =3624 is on level 20).
The database table has a composit unique index (Odometer, QueueID) =with "Ignore duplicate key", and a composit cluster index (QueuedTime, =Odometer). The Odometer column (int) is involved in both indexes.
Also, the server has 4 physical CPUs with hypertheading to 8 virtual =processors.
Error: 3624
General message: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored. Detailed message: =ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: Location: insert.c:573
Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTIND
SPID: 168
Process ID: 2920
Duplicate key was ignored.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang Cao
MCSD, MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> =wrote in message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...
> > I suppose that I should have mentioned that I've already performed =the
> > typical google and support.microsoft.com searches, without finding
> anything
> > applicable. Any other ideas?
> > Sorry, not directly. Maybe you can track down what happens before =this
> error, which command makes the problem? It would be nice if the =problem
> would be reproducable.
> > -- > Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> >
--=_NextPart_000_003E_01C425F6.395B16F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Can you send me the code directly to my =e-mail (just take out the "_please_reply..." part out of the address and I will =try to reproduce the error? BTW, which versions of SQL Server and .NET =Framework are you using?
-- Dejan Sarka, SQL Server =MVPAssociate MentorSolid Quality LearningMore than just Traininghttp://www.SolidQualityLearning.com">www.SolidQualityLearning.com= "Yang Cao" wrote in =message news:uu3i%23lUJEHA.=3436@.tk2msftngp13.phx.gbl...
The following is the SqlException our =code got when that happens. What Jerry and I don't understand is that the =error message "Duplicate key was ignored" should be associated with SQL =error 3604, which is only on severity level 16 that will not throw the exception, =(while error 3624 is on level 20). The database table has a composit =unique index (Odometer, QueueID) with "Ignore duplicate key", and a composit =cluster index (QueuedTime, Odometer). The Odometer column (int) is =involved in both indexes.Also, the server has 4 physical CPUs with =hypertheading to 8 virtual processors. Error: 3624General message: Location: insert.c:573Expression: sdesP->m_pIndex->indindid ==3D=3D CLUSTINDSPID: 168Process ID: =2920Duplicate key was ignored. Detailed message: ELKUpdateStatusFromAnyStatus:System.Data.SqlClient.SqlException: = Location: insert.c:573Expression: sdesP->m_pIndex->indindid =3D=3D CLUSTINDSPID: 168Process ID: 2920Duplicate key was =ignored. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior =cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at =?RunCommand@.@.$$FYAXHPADPAV?$list@.PAU_PARAM@.@.V?$allocator@.PAU_PARAM@.@.@.std@.=@.@.std@.@.W4COMMANDTYPE@.@.@.Z(Int32
Yang CaoMCSD, =MCDBA"Dejan Sarka" wrote in =message news:ecsLMESJEHA.3068@.TK2MSFTNGP10.phx.gbl...> > I suppose =that I should have mentioned that I've already performed the> > =typical google and support.microsoft.com searches, without finding> anything> > applicable. Any other ideas?> => Sorry, not directly. Maybe you can track down what happens before =this> error, which command makes the problem? It would be nice if the problem> would be reproducable.> > -- > =Dejan Sarka, SQL Server MVP> Associate Mentor> Solid Quality Learning> More than just Training> www.SolidQualityLearning.com> >

---

--=_NextPart_000_003E_01C425F6.395B16F0--sql

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu