Maximum request length succeeded

[Jason Thacker]

I have a simple web page, with one RadGrid being populated by a combination of three SQL data sources. The code I use is shown below:

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>
<div>
    <telerik:RadGrid ID="rgdTLCarrierLocations" runat="server" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" CellSpacing="0" DataSourceID="sdsTLCarrierLocations" GridLines="None" ShowGroupPanel="True">
        <ClientSettings AllowDragToGroup="True">
        </ClientSettings>
        <MasterTableView DataKeyNames="CarrierLocation_ID" DataSourceID="sdsTLCarrierLocations" CommandItemDisplay="Bottom" PageSize="20">
            <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
            <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                <HeaderStyle Width="20px"></HeaderStyle>
            </RowIndicatorColumn>
            <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                <HeaderStyle Width="20px"></HeaderStyle>
            </ExpandCollapseColumn>
            <Columns>
                <telerik:GridBoundColumn DataField="CarrierLocation_ID" DataType="System.Int32" FilterControlAltText="Filter CarrierLocation_ID column" HeaderText="CarrierLocation_ID" ReadOnly="True" SortExpression="CarrierLocation_ID" UniqueName="CarrierLocation_ID" Visible="False">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="CarrierLocation_CarrierID" DataType="System.Int32" FilterControlAltText="Filter CarrierLocation_CarrierID column" HeaderText="CarrierLocation_CarrierID" ReadOnly="True" SortExpression="CarrierLocation_CarrierID" UniqueName="CarrierLocation_CarrierID" Visible="False">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="CarrierLocation_LocationID" DataType="System.Int32" FilterControlAltText="Filter CarrierLocation_LocationID column" HeaderText="CarrierLocation_LocationID" ReadOnly="True" SortExpression="CarrierLocation_LocationID" UniqueName="CarrierLocation_LocationID" Visible="False">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="Carrier_Name" FilterControlAltText="Filter Carrier_Name column" HeaderText="Carrier" SortExpression="Carrier_Name" UniqueName="Carrier_Name" ReadOnly="True">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="LocationName" FilterControlAltText="Filter LocationName column" HeaderText="Location" ReadOnly="True" SortExpression="LocationName" UniqueName="LocationName">
                </telerik:GridBoundColumn>
                <telerik:GridDropDownColumn DataField="CarrierLocation_CarrierID" DataSourceID="sdsCarriers" FilterControlAltText="Filter column column" HeaderText="Carrier" ListTextField="Carrier_Name" ListValueField="Carrier_ID" SortExpression="Carrier_Name" UniqueName="column" Visible="False">
                </telerik:GridDropDownColumn>
                <telerik:GridDropDownColumn DataField="CarrierLocation_LocationID" DataSourceID="sdsTLLocations" FilterControlAltText="Filter column1 column" HeaderText="Location" ListTextField="LocationName" ListValueField="Location_ID" SortExpression="LocationName" UniqueName="column1" Visible="False">
                    <ItemStyle Width="200px" />
                </telerik:GridDropDownColumn>
            </Columns>
            <EditFormSettings>
                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                </EditColumn>
            </EditFormSettings>
        </MasterTableView>
        <FilterMenu EnableImageSprites="False">
        </FilterMenu>
        <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
        </HeaderContextMenu>
    </telerik:RadGrid>
</div>
<asp:SqlDataSource ID="sdsTLCarrierLocations" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:LogisticsConnectionString %>" DeleteCommand="DELETE FROM [log].[TLCarrierLocation] WHERE [CarrierLocation_ID] = @original_CarrierLocation_ID" InsertCommand="INSERT INTO [log].[TLCarrierLocation] ([CarrierLocation_CarrierID], [CarrierLocation_LocationID]) VALUES (@CarrierLocation_CarrierID, @CarrierLocation_LocationID)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [CarrierLocation_ID], [CarrierLocation_CarrierID], [CarrierLocation_LocationID], [Carrier].[Carrier_Name], [TLLocation].Location_City + ' (' + [TLLocation].Location_County + ', ' + [TLState].State_Name + ')' AS LocationName FROM [log].[TLCarrierLocation] INNER JOIN [log].[Carrier] ON Carrier_ID = CarrierLocation_CarrierID INNER JOIN [log].[TLLocation] ON Location_ID = CarrierLocation_LocationID INNER JOIN [log].[TLState] ON State_ID = Location_StateID" UpdateCommand="UPDATE [log].[TLCarrierLocation] SET [CarrierLocation_CarrierID] = @CarrierLocation_CarrierID, [CarrierLocation_LocationID] = @CarrierLocation_LocationID WHERE [CarrierLocation_ID] = @original_CarrierLocation_ID">
    <DeleteParameters>
        <asp:Parameter Name="original_CarrierLocation_ID" Type="Int32" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="CarrierLocation_CarrierID" Type="Int32" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="CarrierLocation_CarrierID" Type="Int32" />
        <asp:Parameter Name="CarrierLocation_LocationID" Type="Int32" />
        <asp:Parameter Name="original_CarrierLocation_ID" Type="Int32" />
    </UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="sdsTLLocations" runat="server" ConnectionString="<%$ ConnectionStrings:LogisticsConnectionString %>" SelectCommand="SELECT [Location_ID], [TLLocation].Location_City + ' (' + [TLLocation].Location_County + ', ' + [TLState].State_Name + ')' AS LocationName FROM [log].[TLLocation] INNER JOIN [log].[TLState] ON State_ID = Location_StateID"></asp:SqlDataSource>
<asp:SqlDataSource ID="sdsCarriers" runat="server" ConnectionString="<%$ ConnectionStrings:LogisticsConnectionString %>" SelectCommand="SELECT [Carrier_ID], [Carrier_Name] FROM [log].[Carrier] ORDER BY [Carrier_Name]"></asp:SqlDataSource>

Whenever I use this page to add a record I get the "Maximum request length exceeded" error. Does anybody have any ideas what could be causing this? I don't have this problem in any of my other pages, many of which are almost identical in layout/functionality.

Thanks in advance,

Jason

[Daniel]

Hello Jason,

This message usually appears when one is trying to transfer a large file. I examined your markup but failed to find anything suspicious that could be related to this problem.

You can try to increase the request length limit in web.config. The following setting will raise the bar to 32MB.

<configuration>
    <system.web>
        <httpRuntime maxRequestLength="32768" />
    </system.web>
</configuration>

Kind regards,
Daniel
the Telerik team