Error message 3624 - Definition in plain English? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Error message 3624 - Definition in plain English?

Author

Topic

debianne
Starting Member

5 Posts

Posted - 2005-06-14 : 13:06:22

Hi all. I posted the ntext message yesterday. There's some additional info I'd like to add. I have a field named description inside a view. When I script the table creation in analyzer, it says it is varchar(255). But in the object window pane in query analyzer, it says it is a text field. The biggest field in the order by clause is only a varchar(8), the others are varchar(4) or datetime.

Yesterday someone suggested I try to cast the field back to a varchar. Below is the error mesasage and the query that produced it:

Server: Msg 3624, Level 20, State 1, Line 1

Location: proc.c:1576
Expression: m_activeSdesList.Head () == NULL
SPID: 71
Process ID: 1192

Connection Broken

select tablea.account, tablea.fund, tablea.gl_code, tablea.department,
ydv.posting_date, cast(ydv.description as varchar(255)) from

account_master tablea,
ytd_detail_view ydv

where posting_date between '07/01/04' and '06/30/05' and
(tablea.account = ydv.account) and (tablea.fund like '1%')

order by fund, gl_code, department, object, posting_date

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-06-14 : 14:21:09

Can you tell us which service pack you are using?

Execute in QA:


SELECT  SERVERPROPERTY('productversion'), 
        SERVERPROPERTY ('productlevel'), 
        SERVERPROPERTY ('edition')
GO

debianne
Starting Member

5 Posts

Posted - 2005-06-14 : 15:39:43

Hi. The Product version is 8.00.760, the service pack is sp3, and the edition is standard edition

nathans
Aged Yak Warrior

938 Posts

Posted - 2005-06-14 : 16:27:27

I hesitate to say that your service pack or release version has anything to do with this error; though I have read in other forums that people encounter this error for various reasons. Most of these were reported resolved with the release of SP3 and SP4... but this seems like such a simple query?!?

Im hoping someone else can shed some light on the error message.

A few more questions: Does the query timeout with this error? Meaning, does it run for a long time before reporting this?

How many rows do you think you are returning? try to use rowcount to limit the resultset to a single row and comment the order by. Do you still receive the error?


SET ROWCOUNT 1

select	am.account, 
	am.fund, 
	am.gl_code, 
	am.department,
	ydv.posting_date, 
	cast(ydv.description as varchar(255)) 
from account_master am inner join ytd_detail_view ydv
	on am.account = ydv.account
where posting_date between '07/01/04' and '06/30/05' 
	and am.fund like '1%'
-- order by fund, gl_code, department, object, posting_date

SET ROWCOUNT 0

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources