Friday, March 9, 2012

Job failed with error 3624

Hi Guys,
In my develoment server, I got error with 3624 when job running, error
message is like:
Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
Location: p:\sql\ntdbms\storeng\drs\include\record
.inl:1447 Expression:
m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
[SQLSTATE 01000] (Error 3624). The step failed.
The server was very slow, and like hang up. I cannot connect to server from
my computer. after while, maybe 4 minutes roughly, the server was recovered.
I got that error, and the job runing correctly.
the job runs every one minute to pupulate into a table, which selected from
other tables, and server is a subscriber server that has data replicated
from other server. Can somebody tell me what is reason? Thanks.Why nobody answer me this question? nobody had this error?
"Iter" wrote:

> Hi Guys,
> In my develoment server, I got error with 3624 when job running, error
> message is like:
> Executed as user: Devl\Administrator. [SQLSTATE HY000] (Error 3624)
> Location: p:\sql\ntdbms\storeng\drs\include\record
.inl:1447 Expression:
> m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID: 75 Process ID: 1752
> [SQLSTATE 01000] (Error 3624). The step failed.
> The server was very slow, and like hang up. I cannot connect to server fro
m
> my computer. after while, maybe 4 minutes roughly, the server was recovere
d.
> I got that error, and the job runing correctly.
> the job runs every one minute to pupulate into a table, which selected fro
m
> other tables, and server is a subscriber server that has data replicated
> from other server. Can somebody tell me what is reason? Thanks.|||This can either be a corruption in the database (see DBCC CHECKDB) or a bug
in the product (open a
case with MS if DBCC doesn't report a corruption).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...[vbcol=seagreen]
> Why nobody answer me this question? nobody had this error?
>
> "Iter" wrote:
>|||I checked the database with dbcc checkdb, no error reported. Is this sql
server software bug? Thanks.
"Tibor Karaszi" wrote:

> This can either be a corruption in the database (see DBCC CHECKDB) or a bu
g in the product (open a
> case with MS if DBCC doesn't report a corruption).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:E9DF8C82-38F6-4737-A2FC-E775CA38D522@.microsoft.com...
>|||Yes, if the database comes out clean, I'd strongly suspect a bug. Perhaps yo
u can try this on the
most recent service pack and/or check if there are hotfixes available for th
is?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:C5F65767-84F7-4E7A-9E8E-444CBA9F55EB@.microsoft.com...[vbcol=seagreen]
>I checked the database with dbcc checkdb, no error reported. Is this sql
> server software bug? Thanks.
>
> "Tibor Karaszi" wrote:
>

No comments:

Post a Comment