Post reply

Cannot sort a row of size 8427

  • November 15, 2005 at 8:13 am

    #112285

    Hi guru's,

    I have this error message on one of my jobs.

    Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error

     Description:Cannot sort a row of size 8427, which is greater than the  allowable maximum of 8094. Step Error code: 80040E14. Step Error Help File: Step Error Help Context ID:0

    If I check the size of the row they are not more than 3456.

    Any help is appreiciated. Thanks in advance

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • November 15, 2005 at 10:14 am

    #603982

    sure you don't have some nvarchar columns ? each one is 2 chars so a nvarchar(100) is actually 200 wide.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 16, 2005 at 3:43 am

    #604130

    Hi,

    My table does not contain nvarchar but does contain decimal (13,25) and numeric(13,28). I use dataLenth() function to find the length of data.

    another thing is if I spilt the update statment into 2 parts and execute it runs okay. But actually the lenth of data is not more than 4000 with single update. How does SQL server calculate datalenth and what can be done. Have any idea how SQL server computes datalenth for numeric and decimal

    Thanks

     

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • November 16, 2005 at 12:29 pm

    #604270

    I've seen this error before ... By chance is this table involved in some type of JOIN processing ? If it is, then it's the JOINed result table that is having the issues, so you may have to specify fewer columns or resort to VIEWs.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • November 17, 2005 at 4:42 am

    #604384

    Hi rudy,

    thanks for your valuable comments. Infact it is the reason as we have come to the same conclusion

    Cheers


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • October 29, 2007 at 1:06 pm

    #746373

    Hi,

    I started to get the same error on a view which is in production from long time and was running successfully. I can't reduce the number of columns. Is there any other solution to this problem.

    Thanks

    Yogi

  • October 29, 2007 at 4:07 pm

    #746421

    yogendra_shivhare (10/29/2007)

    Hi,

    I can't reduce the number of columns.

    Ask someone who can.

    _____________
    Code for TallyGenerator

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply