Skip to Content
author's profile photo Former Member
Former Member

exceeded row size of 88 bytes

the following table exists:

Column_name Type Length Prec Scale Nulls Default_name Rule_name Access_Rule_name Computed_Column_object Identity

------------------ ------- ------ ---- ----- ----- ------------ --------- ---------------- ---------------------- ----------

event_transferno_i int 4 NULL NULL 0 def_min1 NULL NULL NULL 0 dimension varchar 2 NULL NULL 0 def_blank NULL NULL NULL 0 due_at int 4 NULL NULL 1 NULL NULL NULL NULL 0 mutation int 4 NULL NULL 1 def_zero NULL NULL NULL 0 mutator varchar 8 NULL NULL 1 def_blank NULL NULL NULL 0 status int 4 NULL NULL 1 def_zero NULL NULL NULL 0 mutation_time int 4 NULL NULL 1 NULL NULL NULL NULL 0 created_by varchar 8 NULL NULL 1 NULL NULL NULL NULL 0 created_date int 4 NULL NULL 1 NULL NULL NULL NULL 0

If i run this update:

UPDATE mytable SET counterno_i = 62282 WHERE wo_transfer_dimension.event_transferno_i IN (32950, 32956) AND wo_transfer_dimension.dimension = 'D'

this error occurs:

Attempt to update or insert row failed because resultant row of size 6951 bytes is larger than the maximum size (88 bytes) allowed for this table.

How can the maximum row size be 88 bytes on a 2k page size server ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 19, 2013 at 03:53 PM

    Hello Mat,

    I think we need to know the columns of mytable (actually the datatype of counterno_i), however the error message remains confusing. Is there any trigger for update? I suppose the version is 15.7

    Best regards,

    Kimon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2013 at 04:51 PM

    Hi,

    The maximum row size for table is determined by the data type of each column for that table (plus row header).

    For some bizarre reason, your update is hitting this error.

    I notice the column being updated isn't in the table definition? Is it incomplete or a view being updated maybe?

    You should log a support message though service marketplace as we need to look into versions\known issues, execution plans, perhaps a reproduction from you etc etc.

    This doesn't look like an SAP application database btw, so future posts should really go in the Sybase ASE for custom apps group.

    Cheers,

    Simon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I'm sorry for the incorrect table definition. This is the layout of

      table wo_transfer_dimension:

      treq_intervalno_i int 4

      event_transferno_i int 4

      dimension varchar 2

      due_at int 4

      usage float 8

      mutation int 4

      mutator varchar 8

      status int 4

      mutation_time int 4

      created_by varchar 8

      created_date int 4

      counterno_i int 4

      And this is the update that fails:

      UPDATE wo_transfer_dimension SET counterno_i = 62282 WHERE wo_transfer_dimension.event_transferno_i IN (32950, 32956) AND wo_transfer_dimension.dimension = 'D'

      There exist an update trigger that updates the mutator,mutation and mutation_time columns.

      The update is executed from a Java application using JTDS.

      I'm quite sure that the error message is misleading and that the root cause is not the table layout.

      But I don't know if the trigger can cause this or any temporary object used by JTDS.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.