Results 1 to 3 of 3

Thread: error 614

  1. #1
    Join Date
    Feb 2002
    Location
    South Carolina
    Posts
    2

    Unanswered: error 614

    One of our 6.5 servers is getting error 614 (A row on a page x was accessed that has an illegal length of y in database z.) However, we can read the specified tables with "select * from a" and can "select into" a new table from those tables with no errors reported. DBCC checkdb and newalloc show no problems. Has anyone else seen this behaviour? We are running diagnostics on the server and raid hardware to determine if those components have problems that might be causing the 614 errors.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    Microsoft has stated that this error was resolved in Service Pack 3 for SQL Server 6.5. Verify that you have the service pack installed

    Code:
    SELECT @@version
    
    6.50.258
    It looks like you can get this error if your SELECT statement contains a large GROUP BY list of columns, total length > 512 bytes.

  3. #3
    Join Date
    Feb 2002
    Location
    South Carolina
    Posts
    2
    Originally posted by achorozy
    Microsoft has stated that this error was resolved in Service Pack 3 for SQL Server 6.5. Verify that you have the service pack installed

    Code:
    SELECT @@version
    
    6.50.258
    It looks like you can get this error if your SELECT statement contains a large GROUP BY list of columns, total length > 512 bytes.
    -----------------------------------------------------------------------------
    Thanks for the reply.

    Our server version is 6.50.422 which is a "post SP5" version. I considered the large Group By as a possible cause, but no software changes were made prior to the first occurance of the error. I'll double check with the analyst who supports the app to make sure though.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •