locked
Column Limit Exceeded Error in infopath RRS feed

  • Question


  • I made a form with infopath and published it into sps2010 but I want to have more columns in my list just number fields but it couldn’t publish it and made this error:Column Limit Exceeded!
    how can I solve this problem,or how can I change this limit? I should have more number columns in my list about 150 or 200 fields.


    thanks alot

    Wednesday, May 4, 2011 4:35 AM

Answers

  • you might need to consider to redisgn your list

    see below for details

    Column limits

    SharePoint Server 2010 data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SharePoint Server will create several rows in the database when data will not fit on a single row. This is called row wrapping.

    Each time that a row is wrapped in SQL Server, an additional query load is put on the server when that item is queried because a SQL join must be included in the query. To prevent too much load, by default a maximum of six SQL Server rows are allowed for a SharePoint item. This limit leads to a particular limitation on the number of columns of each type that can be included in a SharePoint list. The following table describes the limits for each column type.

    The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit. For more information, see the "Designing Large Lists and Maximizing List Performance" white paper that can be accessed from Performance and capacity test results and recommendations (SharePoint Server 2010).

    Each column type has a size value listed in bytes. The sum of all columns in a SharePoint list cannot exceed 8,000 bytes. Depending on column usage, users can reach the 8,000 byte limitation before reaching the six-row row wrapping limitation.

    Taken From: http://technet.microsoft.com/en-us/library/ff608068.aspx

    relevant document: DesigningLargeListsMaximizingListPerformance.docx - 548KB @ http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fd1eac86-ad47-4865-9378-80040d08ac55&displaylang=en 

     


    Manish Sati
    • Marked as answer by Porter Wang Monday, May 9, 2011 2:23 AM
    Wednesday, May 4, 2011 6:58 AM

All replies

  • you might need to consider to redisgn your list

    see below for details

    Column limits

    SharePoint Server 2010 data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SharePoint Server will create several rows in the database when data will not fit on a single row. This is called row wrapping.

    Each time that a row is wrapped in SQL Server, an additional query load is put on the server when that item is queried because a SQL join must be included in the query. To prevent too much load, by default a maximum of six SQL Server rows are allowed for a SharePoint item. This limit leads to a particular limitation on the number of columns of each type that can be included in a SharePoint list. The following table describes the limits for each column type.

    The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit. For more information, see the "Designing Large Lists and Maximizing List Performance" white paper that can be accessed from Performance and capacity test results and recommendations (SharePoint Server 2010).

    Each column type has a size value listed in bytes. The sum of all columns in a SharePoint list cannot exceed 8,000 bytes. Depending on column usage, users can reach the 8,000 byte limitation before reaching the six-row row wrapping limitation.

    Taken From: http://technet.microsoft.com/en-us/library/ff608068.aspx

    relevant document: DesigningLargeListsMaximizingListPerformance.docx - 548KB @ http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fd1eac86-ad47-4865-9378-80040d08ac55&displaylang=en 

     


    Manish Sati
    • Marked as answer by Porter Wang Monday, May 9, 2011 2:23 AM
    Wednesday, May 4, 2011 6:58 AM
  • Thanks alot Manish Sati

    I know but I was searching for a way to solve my problem...

    I think there isn't any way except redesign my list.

    I'm looking for a creating web part for this purpose .

    Sunday, May 8, 2011 4:13 AM