Job failed with error 3624

• jerry-394450

  Mr or Mrs. 500

  Points: 541

  More actions

  May 1, 2007 at 7:38 pm

  #370974

  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.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 3, 2007 at 9:54 am

  #704128

  It's kind of hard to pinpoint the reason for that error.  Take a look at this and see if any apply to what your job

  was doing: http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=2852&query=error+3624&pwt=false&title=false&kt=ALL&mdt=0&res=20&ast=1&ast=2&ast=3&ast=4&ast=7&ast=10&ast=12&mode=a&adv=1

  Greg

  Greg