Hi Elvin. I reproduced it with MSOracle and latest LLBLGen v3.1
ASPX
<llblgenpro:LLBLGenProDataSource2 ID="_departmentsDS" runat="server"
AdapterTypeName="HR.LLBL.MSOracle.Adapter.v31.DatabaseSpecific.DataAccessAdapter, HR.LLBL.MSOracle.Adapter.v31DBSpecific"
DataContainerType="EntityCollection"
EntityFactoryTypeName="HR.LLBL.MSOracle.Adapter.v31.FactoryClasses.DepartmentEntityFactory, HR.LLBL.MSOracle.Adapter.v31"
EnablePaging="true" EnableViewState="true">
</llblgenpro:LLBLGenProDataSource2>
<rad:RadGrid AutoGenerateColumns="false" ID="RadGrid1" DataSourceID="_departmentsDS" Width="96%" EnableAJAX="True"
Skin="Outlook2007" AllowFilteringByColumn="True" AllowSorting="True" PageSize="15" ShowStatusBar="true"
ShowFooter="True" AllowPaging="True" runat="server" GridLines="None" >
<PagerStyle Mode="NextPrevAndNumeric" />
<MasterTableView
AutoGenerateColumns="false"
EditMode="InPlace"
AllowFilteringByColumn="True"
ShowFooter="True" Width="99%"
TableLayout="Fixed">
<Columns>
<rad:GridBoundColumn
DataField="DepartmentId"
HeaderText="DepartmentId"
SortExpression="DepartmentId"
UniqueName="DepartmentId">
<HeaderStyle Width="17%" />
</rad:GridBoundColumn>
<rad:GridBoundColumn
DataField="DepartmentName"
HeaderText="DepartmentName"
SortExpression="DepartmentName"
UniqueName="DepartmentName">
<HeaderStyle Width="27%" />
</rad:GridBoundColumn>
</Columns>
</MasterTableView>
</rad:RadGrid>
Generated SQL
SELECT *
FROM (SELECT a.*, rownum r___
FROM (SELECT "HR"."DEPARTMENTS"."DEPARTMENT_ID" AS "DepartmentId", "HR"."DEPARTMENTS"."DEPARTMENT_NAME" AS "DepartmentName", "HR"."DEPARTMENTS"."LOCATION_ID" AS "LocationId", "HR"."DEPARTMENTS"."MANAGER_ID" AS "ManagerId" FROM "HR"."DEPARTMENTS") a
WHERE rownum < :p4)
WHERE r___ >=:p2
Parameter: :p4 : Int32. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: -2147483648.
Parameter: :p2 : Int32. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 1.
Looking at the parameter creation source code at MSOracleDQE, the pageSize passed from the grid to the dataSource is 2147483647. The parameter creation code looks like:
DbParameter endNoParameter = this.Creator.CreateParameter(ParameterDirection.Input, (pageNumber * pageSize) + 1 );
... and for some reason 2147483647 + 1 = -2147483648 ... I think it's an int overflow and how .net managed the situation.
We will look into this.
(Edit)
BTW, this seems to be a Telerik's known issue: http://www.telerik.com/community/forums/aspnet-ajax/grid/maximum-rows-parameter-with-filtering.aspx